ProgrammerJee - Asad Abbas(AddY)

SQL (Query with transaction under try and catch)

2016-02-03T03:11:00.002-08:00

BEGIN TRY

BEGIN TRANSACTION

--Your Set Of Query/Quries Here...

SELECT 'A QUICK BROWN FOX JUMP OVER THE LAZZY DOG'

COMMIT TRANSACTION

END TRY

BEGIN CATCH

RAISERROR('Custom Error Message Here...',16,-1)

ROLLBACK TRANSACTION

END CATCH

SQL(Quries with automatic date ranges)

2016-01-29T04:25:00.001-08:00

-- [THIS DATES LOGIC HELP YOU TO GET THE RESULTS WITH DATES WITHOUT ENTERING DATES MANUALLY]

--{THIS QUERY GET THE RECORDS ENTERED IN THE CURRENT MONTH TILL TO DATE}

SELECT *

FROM <Table_Name>

WHERE <Date_Column> BETWEEN Dateadd(MONTH, Datediff(MONTH, 0, Getdate()), 0) AND Getdate()

--IF CURRENT MONTH IS = 'January'

--IF CURRENT DAY IS = '18'

--RESULT: 'Get The result from 1st day of January Till Today(Now)'

--{THIS QUERY GET THE RECORDS ENTERED IN PREVIOUS WHOLE MONTH }
SELECT *

FROM <Table_Name>

WHERE <Date_Column> BETWEEN Dateadd(MONTH, Datediff(MONTH, 0, Getdate()) - 1, 0) AND Dateadd(MONTH, Datediff(MONTH, -1, Getdate()) - 1, -.00001)

--IF CURRENT MONTH IS = 'January'

--IF CURRENT DAY IS = '18'

--IF CURRENT YEAR IS = '2016'

--RESULT: 'Get The result from 1st day of Previous Month Till Last Day Of Previous Month

-- in this case it will get the result of December of last year'

SQL - Paging In SQL Query

2016-01-17T22:08:00.002-08:00

DECLARE @PageNumber INT = 1, --@PageNumber comming from gridview from codebihind

@PageSize INT = 100 --@PageSize comming from gridview from codebihind

SET NOCOUNT ON;

SELECT *

FROM dbo.<TableName>

WHERE <Condition> = <value>

ORDER BY <Column_Name>

OFFSET @PageSize * (@PageNumber - 1) ROWS

FETCH NEXT @PageSize ROWS ONLY OPTION (RECOMPILE);

ASP.NET Pie Chart with Random Number Generation Using ADO.NET Alog With Tooltip, Percentage and Legends

2014-06-18T04:12:00.000-07:00

<tr>
  <td align="right">

    Charttype
  </td>
  <td>

    <asp:DropDownListID="ddlChartType"runat="server"></asp:DropDownList>
  </td>
</tr>

protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
if (!IsPostBack)
{
// bind chart type names to ddl

ddlChartType.DataSource = Enum.GetNames(typeof(SeriesChartType));
ddlChartType.DataBind();

}
DataBind();
}

<tr>
     <td align="right">

          Days

     </td>
     <td>

          <asp:DropDownListID="ddlDays"runat="server">

               <asp:ListItemText="10Days"Value="10"Selected="True"></asp:ListItem>

               <asp:ListItemText="20Days"Value="20"></asp:ListItem>

               <asp:ListItemText="30Days"Value="30"></asp:ListItem>

               <asp:ListItemText="40Days"Value="40"></asp:ListItem>

               <asp:ListItemText="50Days"Value="50"></asp:ListItem>

          </asp:DropDownList>

     </td>
</tr>




<tr>
    <td align="right">
        3D Settings
    </td>
     <td>
        <asp:CheckBoxID="cbUse3D"runat="server"Text="Use3DChart"/>
     </td>
</tr>



<tr>
     <td colspan="2">
          <asp:ButtonID="btnGetPOResults"runat="server"Text="Result" onclick="btnGetPOResults_Click"/>
     </td>
</tr>



protectedvoidbtnGetPOResults_Click(objectsender,EventArgse)
{
 ShowChart();
}
 
private void ShowChart()
{
 //definetestdata
 #regionByHashTable
 //Dictionary<DateTime,int>testData=newDictionary<DateTime,int>();
  
 //Randomrnd=newRandom(Guid.NewGuid().GetHashCode());
 //for(inti=0;i<3;i++)
 //{
 //testData.Add(DateTime.Now.AddDays(i),rnd.Next(1,50));
 //}
 //chartPOValidationStatus.Series["Testing"].Points.DataBind(testData,"Key","Value",string.Empty);
 
 //chartPOValidationStatus.Series["Testing"].Points[0].Color=Color.Green;
 //chartPOValidationStatus.Series["Testing"].Points[1].Color=Color.Red;
 //chartPOValidationStatus.Series["Testing"].Points[2].Color=Color.Blue;
 
 #endregion
 
 #regionByDataTable
 
 Randomrnd=newRandom(Guid.NewGuid().GetHashCode());
 vartable=newDataTable();
 
 table.Columns.Add("Status",typeof(string));
 table.Columns.Add("TotalJobs",typeof(long));
 
 varrow=table.NewRow();
 row["Status"]="Passed";
 row["TotalJobs"]=rnd.Next(1,50);;
 table.Rows.Add(row);
 
 row=table.NewRow();
 row["Status"]="Failed";
 row["TotalJobs"]=rnd.Next(1,50);;
 table.Rows.Add(row);
 
 row=table.NewRow();
 row["Status"]="NotVarifid";
 row["TotalJobs"]=rnd.Next(1,50);;
 table.Rows.Add(row);
 
 chartPOValidationStatus.DataSource=table;
 chartPOValidationStatus.DataBind();
 #endregion
  
 //Properties
 chartPOValidationStatus.Series["Testing"].XValueMember="Status";
 chartPOValidationStatus.Series["Testing"].YValueMembers="TotalJobs";
 chartPOValidationStatus.Series["Testing"].ChartTypeName=ddlChartType.SelectedValue;
 chartPOValidationStatus.Series["Testing"].IsValueShownAsLabel=true;
 chartPOValidationStatus.Series["Testing"].IsVisibleInLegend=true;
 
 //chartPOValidationStatus.Series["Testing"].Label="#PERCENT{P2}";
 //chartPOValidationStatus.Series["Testing"].LegendText="#VALX";
 
 chartPOValidationStatus.Series["Testing"].ToolTip="#VAL";
 chartPOValidationStatus.Series["Testing"].Label="#VAL";
 chartPOValidationStatus.Series["Testing"].LegendText="#VALX"+"("+"#PERCENT{P1}"+")";
 
 chartPOValidationStatus.ChartAreas[0].Area3DStyle.Enable3D=cbUse3D.Checked;
 chartPOValidationStatus.ChartAreas[0].Area3DStyle.Inclination=Convert.ToInt32(0);
}






<asp:ChartID="chartPOValidationStatus"runat="server"Height="400px"Width="800px"BackColor="Transparent">
     <legends>
        <asp:LegendAlignment="Center"Docking="Bottom"IsTextAutoFit="False"Name="Default"LegendStyle="Row"/>
     </legends>
     <Series>
        <asp:SeriesName="Testing"IsValueShownAsLabel="true"IsVisibleInLegend="true"IsXValueIndexed="true">
         </asp:Series>
      </Series>
      <ChartAreas>
         <asp:ChartAreaName="chartAreaPOValidations">
          <Area3DStyle/>
         </asp:ChartArea>
       </ChartAreas>
</asp:Chart>

ASP.NET (Generate Report and Create PDF)

2013-11-06T20:27:00.001-08:00


try

{

    // Create a Document object
    Document document = new Document(PageSize.A4, 0, 0, 0, 0);

   DataTable dt = new DataTable();

   dt =  BLL.GetInstance.GetValuesFromDataBase();
   dt.AcceptChanges();

    ReportDataSource rds = new ReportDataSource("DataSet1", dt);

   ReportViewer1.ProcessingMode = ProcessingMode.Local;
   ReportViewer1.LocalReport.ReportPath = Server.MapPath(@"~/Report1.rdlc")

   ReportViewer1.LocalReport.DataSources.Add(rds);



    // Create a new PdfWrite object, writing the output to a MemoryStream

   var output = new MemoryStream();

   var writer = PdfWriter.GetInstance(document, output);
    Warning[] warnings;
    string[] streamIds;
    string mimeType = string.Empty;
    string encoding = string.Empty;
    string extension = string.Empty;


    byte[] bytes = null;
    bytes = ReportViewer1.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamIds, out warnings);



    Response.Buffer = true;

    Response.Clear();

    Response.ContentType = mimeType;

    Response.AddHeader("content-disposition", "attachment; filename=" + "LabelsforIMCB-" + JobID + "." + extension);

    Response.BinaryWrite(bytes); // create the file

     Response.Flush(); // send it to the client to download 

    //Response.ClearContent();

    //Response.ClearHeaders();

     Response.End();
  }

  catch (Exception ex){}

JS(Animated title)

2013-11-06T20:19:00.002-08:00

<scripttype="text/javascript">
/*Begin*/
varmessage=newArray();
 
message[0]="Your First Tile Line Here";
message[1]="Your Second Tile Line Here";
message[2]="Your Third Tile Line Here";
 
varreps=1;
varspeed=300;//Settheoveralltypingspeed(largernumber=sloweraction).
varhold=5      //setthelengthoftimetodisplaythewholephrase

//DONOTEDITBELOWTHISLINE.
varp=message.length;
varq=0;
varr=0;
varC=0;
varmC=0;
vars=0;
varsT=null;
 
if(reps<1){
reps=1;
}
functionsetMessage(){
typing=message[mC];
q=typing.length;
r=q+hold;
typeMessage();
}
functiontypeMessage(){
if(s>r){
s=0;
}
if(s>q){
document.title=''+typing+'...';
}
else{
document.title=''+typing.substr(0,s)+'...';
}
if(C<(r*reps)){
sT=setTimeout("typeMessage()",speed);
C++;
s++;
}
else{
C=0;
s=0;
mC++;
if(mC>p-1){mC=0;}
sT=null;
setMessage();
}
}
setMessage();
 
/*end*/
 
</script>

ASP.Net, C# (Data Access Layer - New )

2013-09-29T21:42:00.001-07:00

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data;

using System.Data.SqlClient;

using System.Text.RegularExpressions;

namespace DataAccessLayer

{

public class DAL

{

public SqlConnection cn = new SqlConnection();

string Error = string.Empty;

public void OpenConnection()

{

try

{

if (cn.State == ConnectionState.Open)

{

CloseConnection();

}

int time = cn.ConnectionTimeout;

cn.ConnectionString = bs_config.getConnectionString("bs_cnn");

//cn.ConnectionString = bs_config.getConnectionString(

cn.Open();

}

catch (Exception ae)

{

bs_log.WriteError("DAL.cs", "OpenConnection()", ae.Message);

throw new System.ArgumentException("Database Connection not made, Please see Event Log for more details"); ;

}

public void CloseConnection()

{

try

{

if (cn.State == ConnectionState.Open)

{

cn.Close();

cn.Dispose();

}

catch (Exception)

{

}

public DataSet FetchDataSet(string sql)

{

return FetchDataSet(sql, ref Error);

}

public DataSet FetchDataSet(string sql, ref string strError)

{

OpenConnection();

DataSet ds = new DataSet();

string error = string.Empty;

int i = 0;

try

{

Regex reg = new Regex("~@~");

string[] queries = reg.Split(sql);

foreach (string qry in queries)

{

SqlDataAdapter sdapt = new SqlDataAdapter(qry, cn);

DataTable dt = new DataTable();

sdapt.Fill(dt);

ds.Tables.Add(dt);

i++;

}

catch (Exception ae)

{

error += "Query Number: " + i.ToString() + " " + ae.Message.ToString();

}

finally

{

CloseConnection();

}

strError = error;

return ds;

}

public DataSet FetchDataSet(SqlCommand command)

{

return FetchDataSet(command, ref Error);

}

public DataSet FetchDataSet(SqlCommand command, ref string strError)

{

OpenConnection();

DataSet ds = new DataSet();

int i = 0;

try

{

string strQuery = command.CommandText;

strError = "";

Regex reg = new Regex("~@~");

string[] queries = reg.Split(strQuery);

foreach (string qry in queries)

{

SqlCommand cmd = new SqlCommand(qry, cn);

SetSqlCommandParameters(cmd, qry, command);

SqlDataAdapter sdapt = new SqlDataAdapter(cmd);

DataTable dt = new DataTable();

sdapt.Fill(dt);

ds.Tables.Add(dt);

i++;

}

catch (Exception ae)

{

strError += "Query Number: " + i.ToString() + " " + ae.Message.ToString();

}

finally

{

CloseConnection();

}

if (strError == "" || strError == null)

{

strError = "T";

}

return ds;

}

public DataSet FetchDataSet(string StoredProcedure, SqlParameter[] parameters)

{

return FetchDataSet(StoredProcedure, parameters, ref Error);

}

public DataSet FetchDataSet(string StoredProcedure, SqlParameter[] parameters, ref string strError)

{

OpenConnection();

try

{

SqlCommand command = new SqlCommand(StoredProcedure, cn);

command.CommandType = CommandType.StoredProcedure;

if (parameters != null)

{

foreach (SqlParameter param in parameters)

command.Parameters.AddWithValue(param.ParameterName, param.Value);

}

SqlDataAdapter sdapt = new SqlDataAdapter(command);

DataSet ds = new DataSet();

sdapt.Fill(ds);

strError = "T";

return ds;

}

catch (Exception ae)

{

strError = ae.Message;

return null;

}

finally

{

CloseConnection();

}

public DataTable FetchDataTable(string sql)

{

return FetchDataTable(sql, ref Error);

}

public DataTable FetchDataTable(string sql, ref string strError)

{

OpenConnection();

try

{

SqlCommand command = new SqlCommand(sql, cn);

DataTable dt = new DataTable();

SqlDataAdapter sdapt = new SqlDataAdapter(command);

sdapt.Fill(dt);

strError = "T";

return dt;

}

catch (Exception ae)

{

strError = ae.Message;

return null;

}

finally

{

CloseConnection();

}

public DataTable FetchDataTable(SqlCommand command)

{

return FetchDataTable(command, ref Error);

}

public DataTable FetchDataTable(SqlCommand command, ref string strError)

{

OpenConnection();

try

{

command.Connection = cn;

DataTable dt = new DataTable();

SqlDataAdapter sdapt = new SqlDataAdapter(command);

sdapt.Fill(dt);

strError = "T";

return dt;

}

catch (Exception ae)

{

strError = ae.Message;

return null;

}

finally

{

CloseConnection();

}

public DataTable FetchDataTable(string StoredProcedure, SqlParameter[] parameters)

{

return FetchDataTable(StoredProcedure, parameters, ref Error);

}

public DataTable FetchDataTable(string StoredProcedure, SqlParameter[] parameters, ref string strError)

{

OpenConnection();

try

{

SqlCommand command = new SqlCommand(StoredProcedure, cn);

command.CommandType = CommandType.StoredProcedure;

if (parameters != null)

{

foreach (SqlParameter param in parameters)

command.Parameters.AddWithValue(param.ParameterName, param.Value);

}

SqlDataAdapter sdapt = new SqlDataAdapter(command);

DataTable dt = new DataTable();

sdapt.Fill(dt);

strError = "T";

return dt;

}

catch (Exception ae)

{

strError = ae.Message;

return null;

}

finally

{

CloseConnection();

}

public IDataReader FetchReader(string sql)

{

return FetchReader(sql, ref Error);

}

public IDataReader FetchReader(string sql, ref string strError)

{

OpenConnection();

try

{

SqlCommand command = new SqlCommand(sql, cn);

SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);

strError = "T";

return reader;

}

catch (Exception ae)

{

strError = ae.Message;

return null;

}

public IDataReader FetchReader(SqlCommand command)

{

return FetchReader(command, ref Error);

}

public IDataReader FetchReader(SqlCommand command, ref string strError)

{

OpenConnection();

try

{

command.Connection = cn;

SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);

strError = "T";

return reader;

}

catch (Exception ae)

{

strError = ae.Message;

return null;

}

public IDataReader FetchReader(string StoredProcedure, SqlParameter[] parameters)

{

return FetchReader(StoredProcedure, parameters, ref Error);

}

public IDataReader FetchReader(string StoredProcedure, SqlParameter[] parameters, ref string strError)

{

OpenConnection();

try

{

SqlCommand command = new SqlCommand(StoredProcedure, cn);

command.CommandType = CommandType.StoredProcedure;

if (parameters != null)

{

foreach (SqlParameter param in parameters)

command.Parameters.AddWithValue(param.ParameterName, param.Value);

}

SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);

strError = "T";

return reader;

}

catch (Exception ae)

{

strError = ae.Message;

return null;

}

public object FetchScaler(string sql)

{

return FetchScaler(sql, ref Error);

}

public object FetchScaler(string sql, ref string strError)

{

OpenConnection();

try

{

SqlCommand command = new SqlCommand(sql, cn);

object value = command.ExecuteScalar();

strError = "T";

return value;

}

catch (Exception ae)

{

strError = ae.Message;

return null;

}

finally

{

CloseConnection();

}

public object FetchScaler(SqlCommand command)

{

return FetchScaler(command, ref Error);

}

public object FetchScaler(SqlCommand command, ref string strError)

{

OpenConnection();

try

{

command.Connection = cn;

object value = command.ExecuteScalar();

strError = "T";

return value;

}

catch (Exception ae)

{

strError = ae.Message;

return null;

}

finally

{

CloseConnection();

}

public object FetchScaler(string StoredProcedure, SqlParameter[] parameters)

{

return FetchScaler(StoredProcedure, parameters, ref Error);

}

public object FetchScaler(string StoredProcedure, SqlParameter[] parameters, ref string strError)

{

OpenConnection();

try

{

SqlCommand command = new SqlCommand(StoredProcedure, cn);

command.CommandType = CommandType.StoredProcedure;

if (parameters != null)

{

foreach (SqlParameter param in parameters)

command.Parameters.AddWithValue(param.ParameterName, param.Value);

}

object value = command.ExecuteScalar();

strError = "T";

if (value == null)

value = "";

return value;

}

catch (Exception ae)

{

strError = ae.Message;

return null;

}

finally

{

CloseConnection();

}

public object FetchScaler(string sql, SqlConnection thisConnection, SqlTransaction thisTransaction)

{

string strError = string.Empty;

return FetchScaler(sql, ref strError, thisConnection, thisTransaction);

}

public object FetchScaler(string sql, ref string strError, SqlConnection thisConnection, SqlTransaction thisTransaction)

{

try

{

SqlCommand command = new SqlCommand(sql, thisConnection);

command.Transaction = thisTransaction;

object value = command.ExecuteScalar();

strError = "T";

return value;

}

catch (Exception ae)

{

strError = ae.Message;

return null;

}

public bool Execute(string StoredProcedure, SqlParameter[] parameters)

{

return Execute(StoredProcedure, parameters, true, ref Error);

}

public bool Execute(string StoredProcedure, SqlParameter[] parameters, ref string strError)

{

return Execute(StoredProcedure, parameters, true, ref strError);

}

public bool Execute(string StoredProcedure, SqlParameter[] parameters, bool hasTransaction)

{

return Execute(StoredProcedure, parameters, hasTransaction, ref Error);

}

public bool Execute(string StoredProcedure, SqlParameter[] parameters, bool hasTransaction, ref string strError)

{

OpenConnection();

SqlTransaction trans = null;

try

{

SqlCommand command = new SqlCommand(StoredProcedure, cn);

if (hasTransaction)

{

trans = cn.BeginTransaction();

command.Transaction = trans;

}

command.CommandType = CommandType.StoredProcedure;

if (parameters != null)

{

foreach (SqlParameter param in parameters)

command.Parameters.AddWithValue(param.ParameterName, param.Value);

}

command.ExecuteNonQuery();

if (hasTransaction)

trans.Commit();

strError = "T";

return true;

}

catch (Exception ae)

{

strError = ae.Message;

if (trans != null) trans.Rollback();

return false;

}

finally

{

CloseConnection();

}

public bool Execute(SqlCommand sqlCommand)

{

string strError = string.Empty;

return Execute(sqlCommand, ref strError);

}

public bool Execute(SqlCommand sqlCommand, ref string strError)

{

OpenConnection();

SqlTransaction trans = null;

try

{

sqlCommand.Connection = cn;

trans = cn.BeginTransaction();

sqlCommand.Transaction = trans;

sqlCommand.ExecuteNonQuery();

trans.Commit();

strError = "T";

return true;

}

catch (Exception ae)

{

if (trans != null) trans.Rollback();

strError = ae.Message;

return true;

}

finally

{

CloseConnection();

}

public IDataReader ExecuteAndGetReader(string StoredProcedure, SqlParameter[] parameters)

{

return ExecuteAndGetReader(StoredProcedure, parameters, true, ref Error);

}

public IDataReader ExecuteAndGetReader(string StoredProcedure, SqlParameter[] parameters, ref string strError)

{

return ExecuteAndGetReader(StoredProcedure, parameters, true, ref strError);

}

public IDataReader ExecuteAndGetReader(string StoredProcedure, SqlParameter[] parameters, bool hasTransaction)

{

return ExecuteAndGetReader(StoredProcedure, parameters, hasTransaction, ref Error);

}

public IDataReader ExecuteAndGetReader(string StoredProcedure, SqlParameter[] parameters, bool hasTransaction, ref string strError)

{

OpenConnection();

SqlTransaction trans = null;

try

{

SqlCommand command = new SqlCommand(StoredProcedure, cn);

if (hasTransaction)

{

trans = cn.BeginTransaction();

command.Transaction = trans;

}

command.CommandType = CommandType.StoredProcedure;

if (parameters != null)

{

foreach (SqlParameter param in parameters)

command.Parameters.AddWithValue(param.ParameterName, param.Value);

}

SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);

if (hasTransaction)

trans.Commit();

strError = "T";

return reader;

}

catch (Exception ae)

{

strError = ae.Message;

if (trans != null) trans.Rollback();

return null;

}

public DataTable ExecuteAndGetTable(string StoredProcedure, SqlParameter[] parameters)

{

return ExecuteAndGetTable(StoredProcedure, parameters, true, ref Error);

}

public DataTable ExecuteAndGetTable(string StoredProcedure, SqlParameter[] parameters, ref string strError)

{

return ExecuteAndGetTable(StoredProcedure, parameters, true, ref strError);

}

public DataTable ExecuteAndGetTable(string StoredProcedure, SqlParameter[] parameters, bool hasTransaction)

{

return ExecuteAndGetTable(StoredProcedure, parameters, hasTransaction, ref Error);

}

public DataTable ExecuteAndGetTable(string StoredProcedure, SqlParameter[] parameters, bool hasTransaction, ref string strError)

{

OpenConnection();

SqlTransaction trans = null;

try

{

SqlCommand command = new SqlCommand(StoredProcedure, cn);

if (hasTransaction)

{

trans = cn.BeginTransaction();

command.Transaction = trans;

}

command.CommandType = CommandType.StoredProcedure;

if (parameters != null)

{

foreach (SqlParameter param in parameters)

command.Parameters.AddWithValue(param.ParameterName, param.Value);

}

SqlDataReader reader = command.ExecuteReader();

DataTable dt = new DataTable();

dt.Load(reader);

reader.Close();

if (hasTransaction)

trans.Commit();

strError = "T";

return dt;

}

catch (Exception ae)

{

strError = ae.Message;

if (trans != null) trans.Rollback();

return null;

}

public object ExecuteAndGetScaler(string StoredProcedure, SqlParameter[] parameters)

{

return ExecuteAndGetScaler(StoredProcedure, parameters, true, ref Error);

}

public object ExecuteAndGetScaler(string StoredProcedure, SqlParameter[] parameters, ref string strError)

{

return ExecuteAndGetScaler(StoredProcedure, parameters, true, ref strError);

}

public object ExecuteAndGetScaler(string StoredProcedure, SqlParameter[] parameters, bool hasTransaction)

{

return ExecuteAndGetScaler(StoredProcedure, parameters, hasTransaction, ref Error);

}

public object ExecuteAndGetScaler(string StoredProcedure, SqlParameter[] parameters, bool hasTransaction, ref string strError)

{

OpenConnection();

SqlTransaction trans = null;

try

{

SqlCommand command = new SqlCommand(StoredProcedure, cn);

if (hasTransaction)

{

trans = cn.BeginTransaction();

command.Transaction = trans;

}

command.CommandType = CommandType.StoredProcedure;

if (parameters != null)

{

foreach (SqlParameter param in parameters)

command.Parameters.AddWithValue(param.ParameterName, param.Value);

}

object value = command.ExecuteScalar();

if (hasTransaction)

trans.Commit();

strError = "T";

return value;

}

catch (Exception ae)

{

strError = ae.Message;

if (trans != null) trans.Rollback();

return null;

}

finally

{

CloseConnection();

}

private void SetSqlCommandParameters(SqlCommand cmd, string qry, SqlCommand command)

{

foreach (System.Data.Common.DbParameter item in command.Parameters)

{

if (qry.Contains(item.ParameterName))

{

cmd.Parameters.AddWithValue(item.ParameterName, item.Value);

}

C#(Generate Random String)

2013-05-27T00:45:00.000-07:00

private static string GeneratePassword()

{

Random rd = new Random(DateTime.Now.Millisecond);

string allowedCharsAll = "abcdefghijkmnopqrstuvwxyzABCDEFGHJKLMNOPQRSTUVWXYZ0123456789";

string allowedCharsUpper = "ABCDEFGHJKLMNOPQRSTUVWXYZ";

string allowedCharsNum = "0123456789";

int passwordLength = rd.Next(8, 8);

char[] chars = new char[passwordLength];

chars[0] = allowedCharsUpper[rd.Next(0, allowedCharsUpper.Length)];

chars[1] = allowedCharsNum[rd.Next(0, allowedCharsNum.Length)];

for (int i = 2; i < passwordLength; i++)

{

chars[i] = allowedCharsAll[rd.Next(0, allowedCharsAll.Length)];

}

return new string(chars);

}

ASP.NET + JS (Show loading model popup on button click with JS)

2013-05-15T02:09:00.001-07:00

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>

//This will call the model popup

function showloadingImage() {

//The below first line is for IE-8 Users

$('#<%= popupProcessingPanel.ClientID %>').append('<img src="../../Images/yourloadingimage.gif" alt="" style="position:absolute; top:40%; left:45%;" />');

//The below line will call the model popup

$('#<%= targetButton.ClientID %>').click();

}

</script>

<asp:ScriptManager ID="ScriptManager1" runat="server" />

<asp:Panel ID="popupProcessingPanel" runat="server" Style="display: none; width:100%; height :100%; background-color:white; opacity:0.9;">

</asp:Panel>

<asp:Button ID="targetButton" runat="server" Text="targetButton" Style="display: none;" CausesValidation="false" />

<asp:ModalPopupExtender ID="ModalPopupExtender1" BehaviorID="mpe" runat="server"

PopupControlID="popupProcessingPanel" Enabled="True" TargetControlID="targetButton">

</asp:ModalPopupExtender>

//Three ways to call model popup
First:

Second:

Third:

ASP.NET, C# (Insert data form file into database using SqlBulkCopy)

2013-04-03T06:41:00.000-07:00

/// Data from text file

/// Implementation

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Data;

using System.IO;

using System.Data.SqlClient;

/// <summary>

/// Summary description for Class1

/// </summary>

public class Class1

{

/// <summary>

///Table feilds as in the table in Database

/// </summary>

enum TableFeilds

{

ID,

FName,

LName,

Age,

Address,

}

/// <summary>

///Parcing data from file

/// </summary>

public DataTable CreateDataTableFromData(StreamReader strReader)

{

string sRdrLine = String.Empty;

DataTable dt = new DataTable("TableName"); //Table Name should be the same as in the DataBase

try

{

foreach (String strEnumsValues in Enum.GetNames(typeof(TableFeilds)))

{

dt.Columns.Add(strEnumsValues);

}

while (!strReader.EndOfStream)

{

sRdrLine = strReader.ReadLine();

DataRow row = dt.NewRow();

if (sRdrLine.Trim() != string.Empty)

{

if (sRdrLine.Split('|').GetValue(0).ToString().Trim().Length > 0)

row["ID"] = sRdrLine.Split('|').GetValue(0).ToString();

else

row["ID"] = DBNull.Value;

if (sRdrLine.Split('|').GetValue(1).ToString().Trim().Length > 0)

row["FName"] = sRdrLine.Split('|').GetValue(1).ToString();

else

row["FName"] = DBNull.Value;

if (sRdrLine.Split('|').GetValue(2).ToString().Trim().Length > 0)

row["LName"] = sRdrLine.Split('|').GetValue(2).ToString();

else

row["LName"] = DBNull.Value;

if (sRdrLine.Split('|').GetValue(3).ToString().Trim().Length > 0)

row["Age"] = sRdrLine.Split('|').GetValue(3).ToString();

else

row["Age"] = DBNull.Value;

if (sRdrLine.Split('|').GetValue(4).ToString().Trim().Length > 0)

row["Address"] = sRdrLine.Split('|').GetValue(4).ToString();

else

row["Address"] = DBNull.Value;

dt.Rows.Add(row);

sRdrLine = null;

}

catch (Exception ex)

{

throw ex;

}

return dt;

}

/// <summary>

///Inserting Data into data base

/// </summary>

public bool InsertDataViaSqlBulkCopy(DataTable dt, string strStoreProcedure)

{

string mySqlConnectionString = ""; //Your DB SonnectionString here...

bool isDone = false;

SqlConnection conn = null;

SqlTransaction trans = null;

SqlCommand cmd = null;

try

{

conn = new SqlConnection(mySqlConnectionString);

conn.Open();

trans = conn.BeginTransaction();

cmd = new SqlCommand(strStoreProcedure, conn);

cmd.CommandTimeout = 550;

cmd.CommandType = CommandType.StoredProcedure;

cmd.Transaction = trans;

cmd.ExecuteNonQuery();

using (SqlBulkCopy objbulkCopy = new SqlBulkCopy(conn, SqlBulkCopyOptions.KeepIdentity, trans))

{

objbulkCopy.BulkCopyTimeout = 550;

foreach (DataColumn dtColumn in dt.Columns)

{

objbulkCopy.ColumnMappings.Add(dtColumn.ColumnName, dtColumn.ColumnName);

}

objbulkCopy.DestinationTableName = dt.TableName;

objbulkCopy.BatchSize = dt.Rows.Count;

objbulkCopy.WriteToServer(dt);

isDone = true;

}

trans.Commit();

conn.Close();

}

catch (Exception ex)

{

if (trans != null)

{

trans.Rollback();

}

throw ex;

}

finally

{

if (conn != null)

{

conn.Dispose();

conn = null;

}

return isDone;

}

/// <summary>

/// Class1 constructor

/// </summary>

public Class1()

{

if (File.Exists("FilePath") == true)

{

using (StreamReader strReaderSup = File.OpenText("FilePath"))

{

DataTable dt = CreateDataTableFromData(strReaderSup);

strReaderSup.Dispose();

if (dt.Rows.Count > 0)

{

InsertDataViaSqlBulkCopy(dt, "yourSPName");

}

C# (Play Sound On Button Click)

2013-04-02T03:55:00.003-07:00

using System.Media;

protected void Button1_Click(object sender, EventArgs e)
{
         SoundPlayer sd = new SoundPlayer();
         sd.SoundLocation = Server.MapPath("~/sounds/File.wav");
         sd.Play();
}

ASP.NET(DropDownList Tooltip)

2013-03-18T08:13:00.001-07:00

//Simple way to add tooltip in dropdown on asp.net

//OnPreRender of your DropDown Call this this method it will create your tooltip automaticly!

public static void SetToolTiptitle(DropDownList ddl)

{

foreach (ListItem li in ddl.Items)

{

li.Attributes.Add("title", li.Text);

}

SQL(Query with numeric padding)

2013-02-27T05:22:00.001-08:00

SELECT Cast(RIGHT('000000' + Rtrim ( Max(Cast(RIGHT(Rtrim ([FeildName]), 6) AS INT)) + 1 ), 6) AS VARCHAR(6))

FROM <TableName>

--Note: The use of right is deployed in the query because FeildName contains alphabets before numerics that is why we use to pull the 6 numeric digits form the right and get the max value and add a number and give the padding of 6 numeric with '000000'.

Difference b/w Sealed and Abstract Classes

2012-10-03T03:43:00.000-07:00

Some days before i was ask in the interview that what is the difference b/w sealed and abstact class.
the answers which i have given is that...

Sealed Classes can not be inherited in the namespace.
Abstract Classes does not allow to create an instance.

please give me your comments regarding the question?

JS(Add comma sepration into the amount)

2012-08-30T04:27:00.000-07:00

//A simple javascript function to decoration of numerics specially amount with comma seprated ex: "10,000"

function addCommas(nStr) {

nStr += '';

x = nStr.split('.');

x1 = x[0];

x2 = x.length > 1 ? '.' + x[1] : '';

var rgx = /(\d+)(\d{3})/;

while (rgx.test(x1)) {

x1 = x1.replace(rgx, '$1' + ',' + '$2');

}

return x1 + x2;

}

SQL(Insert with XML into SQL through C#)

2012-08-27T22:41:00.000-07:00

//C#

/* Note: This is the simple example to insert data into database with xml. This will help the database server to handle multiple request at a time.*/

using System.Xml;

DALayer layer = new DALayer();

SqlConnection cn = layer.ReturnConnection();

SqlTransaction trans = null;

SqlDataReader reader = null;

try

{

XmlDocument xmldoc = new XmlDocument();

XmlElement doc = xmldoc.CreateElement("doc");

xmldoc.AppendChild(doc);

string[] arrValues = new string[] { "one", "two", "three", "four", "five" };

for (int i = 0; i < arrValues.Length; i++)

{

XmlElement item = xmldoc.CreateElement("item");

doc.AppendChild(item);

item.AppendChild(xmldoc.CreateElement("ColumnNameasPerDatabase")).InnerText = arrValues[i].ToString();

}

trans = cn.BeginTransaction();

SqlCommand command = new SqlCommand("sp_ProcedureName", cn);

command.CommandType = CommandType.StoredProcedure;

command.Parameters.AddWithValue("@LoginId", long.Parse(“1”));

command.Parameters.AddWithValue("@doc", xmldoc.OuterXml);

command.Transaction = trans;

reader = command.ExecuteReader();

int OrderId = 0;

while (reader.Read())

{

OrderId = long.Parse(reader["OrderId"].ToString());

}

reader.Close();

trans.Commit();

if (OrderId > 0)

{

//Query Performed Sucessfully
return true;

}

else

{

throw new Exception("Query Failed ");

}

}
catch (Exception ex)
{
     if (trans != null)
     {
         trans.Rollback();
     }
     if (reader != null)
     {
          if (!reader.IsClosed) reader.Close();
     }
     return false;
}

Finally
{
cn.Close();
cn.Dispose();
}

-- SQL

-- The StoreProcedure with XML regarding to the example
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
Go

ALTER PROCEDURE [dbo].[sp_ProcedureName]
(@LoginId bigint,
@doc varchar(max))

DECLARE
@id bigint, @hdoc int,
@StatusN varchar(1), @StatusC varchar(1), @Amount decimal

SELECT @Amount=0, @StatusN='1', @StatusC='A'

INSERT INTO OrderMaster(LoginID) VALUES(@LoginId)

-- Get The Auto IncrementId into @id
set @id = scope_identity()

EXEC sp_xml_preparedocument @hdoc OUTPUT, @doc

-- Column Name as per Table to insert into database from XML
SELECT @id id, x.ColumnNameasPerDatabase

into #tmpTable
    FROM OPENXML ( @hdoc, '/doc/item', 2 )
WITH (
          -- Comma seprated multiple colums
          COLUMNNAMEASPERDATABASE DataType 'ColumnNameasPerDatabase(s))'
    ) AS x

-- Release XML handle
EXEC sp_xml_removedocument @hdoc

--Detail Insert Query
INSERT INTO DetailTable(ColumnNameasPerDatabase(s))
SELECT ColumnNameasPerDatabase(s) FROM #tmpTable

--Return The OrderId If The Query Inserted Sucessfully!
SELECT @id OrderId

SQL(Dynamic SQL with storeprocedure)

2012-08-01T22:32:00.002-07:00

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

CREATE PROCEDURE [dbo].[ProcedureName](@Status varchar(1), @QueryBy varchar(150))

--DynamicSQL

declare @SQL nvarchar(max),

@params nvarchar(4000)

SET @SQL= 'SELECT Top (@PerPage) * FROM <Table_Name> WHERE a.Status = @Status AND @QueryBy'

SELECT @params = N'@Status varchar(1),'+

N'@QueryBy varchar(150)'

execute sp_executesql @SQL, @params, @Status=@Status, @QueryBy=@QueryBy

c#(get the first, second table from storeprocedure)

2012-07-31T22:29:00.000-07:00

//NOTE: This will help you to get the first table and second table from your store_procedure returning at once

public void MethodName()

{

DALayer layer = new DALayer();

SqlConnection cn = layer.ReturnConnection();

SqlDataReader reader = null;

#region Post

try

{

string strQuery = "ProcedureName";

string strError = string.Empty;

SqlCommand cmd = new SqlCommand(strQuery, cn);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@ParameterName",”Value”);

reader = cmd.ExecuteReader();

Blogtopic.InnerHtml = string.Empty;

//FIRST_TABLE

while (reader.Read())

{

//This will get the result from the first table only return by your storeprocedure

}

//SECOND_TABLE

if (reader.NextResult())

{

while (reader.Read())

{

//This will get the result from the second table return by your storeprocedure

}

catch (Exception ex)

{

return;

}

finally {

reader.Close();

cn.Close();

}

#endregion

}

ASP.Net(Javascript Notification Alert Improved)

2012-07-22T20:44:00.000-07:00

// Step 01: Copy this CSS in your code as "jquery.toastmessage-min.css"

/*Start Notification CSS*/

.toast-container{width:280px;z-index:9999;}

* html .toast-container{position:absolute;}

.toast-item{height:auto;background:#0C4F9E;opacity:.9;-moz-border-radius:10px;-webkit-border-radius:10px;color:#eee;padding-top:20px;padding-bottom:20px;padding-left:6px;padding-right:6px;font-family:Arial;font-size:13px;border:2px solid #999;display:block;position:relative;margin:0 0 12px 0;}

.toast-item p{text-align:left;margin-left:50px; color: White;}

.toast-item-close{background:url(../../images/close.gif);width:22px;height:22px;position:absolute;top:7px;right:7px;}

.toast-item-image{width:32px;height:32px;margin-left:10px;margin-top:10px;margin-right:10px;float:left;}

.toast-item-image-notice{background:url(../images/notice.png);}

.toast-item-image-success{background:url(../../images/success.png);}

.toast-item-image-warning{background:url(../images/twarning.png);}

.toast-item-image-error{background:url(../images/terror.png);}

.toast-type-notice{color:white;}

.toast-type-success{color:white;}

.toast-type-warning{color:white;border-color:#FCBD57;}

.toast-type-error{color:white;border-color:#B32B2B;}

.toast-position-top-left{position:fixed;left:20px;top:20px;}

.toast-position-top-center{position:fixed;top:20px;left:50%;margin-left:-140px;}

.toast-position-top-right{position:fixed;top:20px;right:20px;}

.toast-position-middle-left{position:fixed;left:20px;top:50%;margin-top:-40px;}

.toast-position-middle-center{position:fixed;left:50%;margin-left:-140px;margin-top:-40px;top:50%;}

.toast-position-middle-right{position:fixed;right:20px;margin-left:-140px;margin-top:-40px;top:50%;}

/*End Notification CSS*/

// Step 02: Download Icons in your project's Image folder from here.

// Step 03: Copy this JS in your code as "jquery.toastmessage-min.js"

/*Start Notification JS*/

(function (c) {

var b = { inEffect: { opacity: "show" }, inEffectDuration: 600, stayTime: 5000, text: "", sticky: false, type: "notice", position: "top-right", closeText: "", close: null };

var a = { init: function (d) {

if (d) {

c.extend(b, d)

}

}, showToast: function (f) {

var g = {};

c.extend(g, b, f);

var j, e, d, i, h;

j = (!c(".toast-container").length) ? c("<div></div>").addClass("toast-container").addClass("toast-position-" + g.position).appendTo("body") : c(".toast-container");

e = c("<div></div>").addClass("toast-item-wrapper");

d = c("<div></div>").hide().addClass("toast-item toast-type-" + g.type).appendTo(j).html(c("<p>").append(g.text)).animate(g.inEffect, g.inEffectDuration).wrap(e);

i = c("<div></div>").addClass("toast-item-close").prependTo(d).html(g.closeText).click(function () {

c().toastmessage("removeToast", d, g)

});

h = c("<div></div>").addClass("toast-item-image").addClass("toast-item-image-" + g.type).prependTo(d);

if (navigator.userAgent.match(/MSIE 6/i)) {

j.css({ top: document.documentElement.scrollTop })

} if (!g.sticky) {

setTimeout(function () {

c().toastmessage("removeToast", d, g)

}, g.stayTime)

} return d

}, showNoticeToast: function (e) {

var d = { text: e, type: "notice" };

return c().toastmessage("showToast", d)

}, showSuccessToast: function (e) {

var d = { text: e, type: "success" };

return c().toastmessage("showToast", d)

}, showErrorToast: function (e) {

var d = { text: e, type: "error" };

return c().toastmessage("showToast", d)

}, showWarningToast: function (e) {

var d = { text: e, type: "warning" };

return c().toastmessage("showToast", d)

}, removeToast: function (e, d) {

e.animate({ opacity: "0" }, 600, function () {

e.parent().animate({ height: "0px" }, 300, function () {

e.parent().remove()

})

});

if (d && d.close !== null) {

d.close()

}

};

c.fn.toastmessage = function (d) {

if (a[d]) {

return a[d].apply(this, Array.prototype.slice.call(arguments, 1))

} else {

if (typeof d === "object" || !d) {

return a.init.apply(this, arguments)

} else {

c.error("Method " + d + " does not exist on jQuery.toastmessage")

}

})(jQuery);

/*End Notification JS*/

// Step 04: Declare the central class to callout every page from the web easily

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Text;

/// <summary>

/// Summary description for Notifications

/// </summary>

public static class Notifications

{

public static string getNotification(string Message, int notificationType)

{

StringBuilder sb = new StringBuilder();

switch (notificationType)

{

case NotificationType.SuccessToast:

sb.AppendLine("$().toastmessage('showSuccessToast', '" + Message + "');");

break;

case NotificationType.SuccessSticky:

sb.AppendLine("$().toastmessage('showToast', {");

sb.AppendLine(" text: '" + Message + "',");

sb.AppendLine(" sticky: true,");

sb.AppendLine(" position: 'top-right',");

sb.AppendLine(" type: 'success',");

sb.AppendLine(" closeText: '',");

sb.AppendLine(" });");

break;

case NotificationType.NoticeToast:

sb.AppendLine("$().toastmessage('showNoticeToast', '" + Message + "');");

break;

case NotificationType.NoticeSticky:

sb.AppendLine("$().toastmessage('showToast', {");

sb.AppendLine(" text: '" + Message + "',");

sb.AppendLine(" sticky: true,");

sb.AppendLine(" position: 'top-right',");

sb.AppendLine(" type: 'notice',");

sb.AppendLine(" closeText: '',");

sb.AppendLine("});");

break;

case NotificationType.WarningToast:

sb.AppendLine("$().toastmessage('showWarningToast', '" + Message + "');");

break;

case NotificationType.WarningSticky:

sb.AppendLine("$().toastmessage('showToast', {");

sb.AppendLine(" text: '" + Message + "',");

sb.AppendLine(" sticky: true,");

sb.AppendLine(" position: 'top-right',");

sb.AppendLine(" type: 'warning',");

sb.AppendLine(" closeText: '',");

sb.AppendLine("});");

break;

case NotificationType.ErrorToast:

sb.AppendLine("$().toastmessage('showErrorToast', '" + Message + "');");

break;

case NotificationType.ErrorSticky:

sb.AppendLine("$().toastmessage('showToast', {");

sb.AppendLine(" text: '" + Message + "',");

sb.AppendLine(" sticky: true,");

sb.AppendLine(" position: 'top-right',");

sb.AppendLine(" type: 'error',");

sb.AppendLine(" closeText: '',");

sb.AppendLine("});");

break;

}

return sb.ToString();

}

public class NotificationType

{

public const int SuccessToast = 1;

public const int SuccessSticky = 2;

public const int NoticeToast = 3;

public const int NoticeSticky = 4;

public const int WarningToast = 5;

public const int WarningSticky = 6;

public const int ErrorToast = 7;

public const int ErrorSticky = 8;

}

// Step 05: Include the CSS and Javascript headers files for notification alert!

// Step 06: Method to show notification and needs to be call from the page to show.

private void DisplayNotification(string Message, int notificationType)

{

#region NotificationAlert

ScriptManager requestSM = ScriptManager.GetCurrent(this);

if (requestSM != null && requestSM.IsInAsyncPostBack)

{

ScriptManager.RegisterClientScriptBlock(this,

typeof(Page),

Guid.NewGuid().ToString(),

Notifications.getNotification(Message, notificationType),

true);

}

else

{

ClientScript.RegisterStartupScript(typeof(Page),

Guid.NewGuid().ToString(),

Notifications.getNotification(Message, notificationType),

true);

}
#endregion

}

ASP.NET(Send Server Request Using Javascript)

2012-07-09T02:14:00.001-07:00

//This Example Will Allow You To Send Request On The Server Using Javascript

//Step01:JS code will help you to send the request on HTTP Handler.

var var01 = document.getElementById(elementID1);var var02 = document.getElementById(elementID2);

var var03 = document.getElementById( elementID3);

var dataString = ' var01=' + var01 + '&var02=' + var02 + '&var03=' + var03;

$.ajax({

type: "POST",

url: "HandlerName.ashx",

data: dataString

})

.done(function (msg) { alert("Done: " + msg);})

.fail(function (msg) { alert("NotDone: " + msg); })

.always(function () { alert("Complete"); });

//Step02:Handler Performing the Insert Query Into DataBase.(You can also Update, delete the record into the database or etc…)

public class manageaddress : IHttpHandler, IRequiresSessionState {

public void ProcessRequest (HttpContext context)

{

context.Response.ContentType = "text/html";

try

{

if (context.Request.Form["var01"] != null && context.Request.Form["var02"] != null && context.Request.Form["var03"] != null)

{

SqlConnection cn = new SqlConnection();

cn.ConnectionString =ConfigurationManager.ConnectionStrings["ConnectinStringName"].ConnectionString;

cn.Open();

string strSql = "INSERT INTO <Table_Name> (column01, column02, column03) values (@var01, @var02, @var03)";
SqlCommand command = new SqlCommand(strSql, cn);

command.Parameters.AddWithValue("@var01", context.Request.Form["var01"].ToString());

command.Parameters.AddWithValue("@var02", context.Request.Form["var02"].ToString());

command.Parameters.AddWithValue("@var03", context.Request.Form["var03"].ToString());

command.ExecuteNonQuery();

}

catch (Exception ex)

{

throw new Exception(ex.Message);

}

ASP.NET(Configure Skype Call On Your WebPage)

2012-07-02T04:35:00.001-07:00

<div>

</script>

<a href="skype:<Skype_ID>?call" class="skype-call">skypecall</a></div>

</div>

ASP.NET(Cascading Dropdown with WEBService)

2012-07-01T22:47:00.000-07:00

//NOTE: This Example will help you to populate dropdowns without postback of the page working together like one combo populates the countries and other populate the relivent cites of it, and you will require the ajax control toolkit to do that you also have to make a service locally.

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>

//Step01: Country DropDown

<asp:DropDownList ID="ddlCountry" runat="server"></asp:DropDownList>

//Step02: City DropDown
<asp:DropDownList ID="ddlCity" runat="server"></asp:DropDownList>

//Step03: Use Cascading Dropdown with the appropriate ASP dropdown controls

<asp:CascadingDropDown ID="CDD_Country" runat="server"

TargetControlID="ddlCountry"

Category="Country"

PromptText="Select a Country"

LoadingText="Please wait..."

ServicePath="~/ServiceName.asmx"

ServiceMethod="MethodForPopulatingCountriesHere"/>

<asp:CascadingDropDown ID="CDD_City" runat="server"

TargetControlID="ddlCity"

ParentControlID="ddlCountry"

Category="Country"

PromptText="Select a City"

LoadingText="Please wait..."

ServicePath="~/ServiceName.asmx"

ServiceMethod="MethodForPopulatingCitiesHere"/>

//Step04: WEBService That’s Populating Cities and Countries
using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.Services;

using AjaxControlToolkit;

using System.Data.SqlClient;

using System.Configuration;

using System.Data;

using System.Collections.Specialized;

/// <summary>

/// Summary description for Location

/// </summary>

[WebService(Namespace = "http://tempuri.org/")]

[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]

[System.Web.Script.Services.ScriptService()]

// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.

// [System.Web.Script.Services.ScriptService]

public class Location : System.Web.Services.WebService {

public Location () {

//Uncomment the following line if using designed components

//InitializeComponent();

}

[WebMethod]

public string HelloWorld() {

return "Hello World";

}

[WebMethod]

public CascadingDropDownNameValue[] GetCountry(

string knownCategoryValues, string category)

{

string strSql = "SELECT DISTINCT CountryName FROM TableName";

string strError = string.Empty;

SqlConnection cn = new SqlConnection();

cn.ConnectionString = ConfigurationManager.ConnectionStrings["uportal_cnn"].ConnectionString;

cn.Open();

DataSet ds = new DataSet();

SqlDataAdapter sdapt = new SqlDataAdapter(strSql, cn);

sdapt.Fill(ds);

List<CascadingDropDownNameValue> cascadingValues = new List<CascadingDropDownNameValue>();

for (int i = 0; i < ds.Tables[0].Rows.Count; i++)

{

cascadingValues.Add(new CascadingDropDownNameValue()

{

name = ds.Tables[0].Rows[i][0].ToString(),

value = ds.Tables[0].Rows[i][0].ToString()

});

}

return cascadingValues.ToArray();

}

[WebMethod]

public CascadingDropDownNameValue[] GetCities(

string knownCategoryValues, string category)

{

StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);

string country = string.Empty;

if (!kv.ContainsKey("Country"))

{

return null;

}

country = kv["Country"].ToString();

SqlConnection cn = new SqlConnection();

cn.ConnectionString = ConfigurationManager.ConnectionStrings["uportal_cnn"].ConnectionString;

cn.Open();

string strSql = "SELECT CityName FROM Table Name WHERE CountryName = @pm_country ";

SqlCommand command = new SqlCommand(strSql, cn);

command.Parameters.AddWithValue("@pm_country", country);

string strError = string.Empty;

DataSet ds = new DataSet();

SqlDataAdapter sdapt = new SqlDataAdapter(command);

sdapt.Fill(ds);

List<CascadingDropDownNameValue> cascadingValues = new List<CascadingDropDownNameValue>();

for (int i = 0; i < ds.Tables[0].Rows.Count; i++)

{

cascadingValues.Add(new CascadingDropDownNameValue()

{

name = ds.Tables[0].Rows[i][0].ToString(),

value = ds.Tables[0].Rows[i][0].ToString()

});

}

return cascadingValues.ToArray();

}

ASP.Net(Get The Master Page ASP Control Text Value)

2012-06-16T03:08:00.000-07:00

HiddenField mpTextbox;

mpTextbox = (HiddenField)Master.FindControl("ElementName");

if (mpTextbox != null)

{

mpTextbox.Value.ToString();

}

ASP.NET(Write txt log file in daily basis)

2012-06-07T04:53:00.001-07:00

public static void WriteLog(string strError, string MethodName, string parameters, string pageName)

{

string FileName = HttpContext.Current.Server.MapPath("Path/logs_" + DateTime.Now.ToString("yyyyMMdd") + ".txt");

string strText = DateTime.Now.ToString() + "\t" + pageName + "\t\t" + MethodName + "\t" + parameters + "\t" + strError;

if (!File.Exists(FileName))

{

// Create New Text File

FileStream fStream = new FileStream(FileName, FileMode.Create, FileAccess.Write);

StreamWriter sw = new StreamWriter(fStream);

sw.WriteLine(strText);

sw.Close();

fStream.Close();

}

else

{

FileInfo finfo = new FileInfo(FileName);

while (IsFileLocked(finfo))

{

Thread.Sleep(500);

}

finfo = null;

FileStream aFile = new FileStream(FileName, FileMode.Append, FileAccess.Write);

StreamWriter sw = new StreamWriter(aFile);

sw.WriteLine(strText);

sw.Close();

aFile.Close();

}

private static bool IsFileLocked(FileInfo file)

{

FileStream stream = null;

try

{

stream = file.Open(FileMode.Open, FileAccess.ReadWrite, FileShare.None);

}

catch (IOException)

{

//the file is unavailable because it is:

//still being written to

//or being processed by another thread

//or does not exist (has already been processed)

return true;

}

finally

{

if (stream != null)

stream.Close();

}

//file is not locked

return false;

}

PHP(array with shift, unshift, pop, puch functions)

2012-06-06T23:54:00.002-07:00

<?php

$numbers = array(1,2,3,4,5,6);

print_r($numbers);

echo "<br /> <br />";

//shifts first element out of an array

//and returns it.

$a = array_shift($numbers);

echo "a: ". $a. "<br/>";

print_r($numbers);

echo "<br /> <br />";

//prepends an element to an array

//returns the element count.

$b = array_unshift($numbers, 'first');

echo "b: " . $b . "<br />";

print_r($numbers);

echo "<br /> <br />";

echo "<hr/>";

//pops an element out of an array

//and returns it.

$c = array_pop($numbers);

echo "c: " . $c . "<br />";

print_r($numbers);

echo "<br /><br />";

//pushes the element onto the end of an array,

//returns the element count.

$d = array_push($numbers, "last");

echo "d:" . $d ."<br />";

print_r($numbers);

echo "<br /> <br />";

//RESULT ON BROWSER

Array ( [0] => 1 [1] => 2 [2] => 3 [3] => 4 [4] => 5 [5] => 6 )

a: 1
Array ( [0] => 2 [1] => 3 [2] => 4 [3] => 5 [4] => 6 )

b: 6
Array ( [0] => first [1] => 2 [2] => 3 [3] => 4 [4] => 5 [5] => 6 )

c: 6
Array ( [0] => first [1] => 2 [2] => 3 [3] => 4 [4] => 5 )

d:6
Array ( [0] => first [1] => 2 [2] => 3 [3] => 4 [4] => 5 [5] => last )