Fetch Value Through UserControl (.ascx file)

//ADC is a user controlName wich we will add in @response directive

//Ex:(Inline Code) %@ Register TagName ="ABC" TagPrefix ="ABC" Src="~/WebUserControl.ascx"%>
after that you can add where u want......
ABC:ABC ID="ADC" runat="server" />

.cs (Code Behind)

WebUserControl we;
we = (WebUserControl)this.FindControl("ADC");
TextBox txtuser = (TextBox)we.FindControl("txtname");
TextBox txtpassword = (TextBox)we.FindControl("txtPassword");

Transaction in .Net(Insert Data through Stored Procedure)

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Master"].ConnectionString);
SqlTransaction tran=null ;
SqlCommand cmd;
SqlDataAdapter adp;
DataSet ds;

try
{
con.Open();
tran=con.BeginTransaction();



cmd = new SqlCommand("InserData", con);

cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("Name", txtName.Text.Trim().Replace("'", "''"));
cmd.Parameters.AddWithValue("dept_id", ddldept.SelectedValue);
cmd.Parameters.AddWithValue("Contact", txtContact.Text.Trim().Replace("'", "''"));
cmd.Transaction = tran;
cmd.ExecuteNonQuery();
tran.Commit();
}
catch
{

tran.Rollback();
con.Close();
}
finally { con.Close(); }

Bind GridView Common Function

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Master"].ConnectionString);
SqlTransaction tran=null ;
SqlCommand cmd;
SqlDataAdapter adp;
DataSet ds;

public void BindGridview(GridView gr, string table, string sorting)
{
adp = new SqlDataAdapter("Select * from " + table + " order by " + sorting ,con );
ds = new DataSet();
adp.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
gr.DataSource = ds.Tables[0];
gr.DataBind();
}
else
{ //Empty grid view
}

}

Bind DropDown Common Function

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Master"].ConnectionString);
SqlTransaction tran=null ;
SqlCommand cmd;
SqlDataAdapter adp;
DataSet ds;
public void filldropdown(DropDownList ddl, string table, string DataTextField, string DataValueField)
{
adp = new SqlDataAdapter("Select " + DataValueField + "," + DataTextField + " from " + table + " order by '" + DataTextField + "' ", con);
DataSet ds = new DataSet();
adp.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ddl.Items.Add(ds.Tables[0].Rows[i][DataTextField].ToString());
ddl.Items[i + 1].Value = ds.Tables[0].Rows[i][DataValueField].ToString();

}
}

}

Sum Amt and Max date of each employer

SELECT tblCustomer.Name, tblCustomer.Address, tblCustomer.Email, TblInvoice.Amt,Dateofpurchase
FROM tblCustomer INNER JOIN
TblInvoice ON tblCustomer.Cid = TblInvoice.Cid
order by TblInvoice.Cid
compute max(TblInvoice.DateOfpurchase),sum(TblInvoice.Amt) by TblInvoice.Cid

Subhash Sharma Album

What is .Net Web Service?

Web service is the way to publish application's function on web that can be accessible to the rest of the world.
Web services are the components that can be used by other applications
ASP.NET offers easy way to develop web services, just precede the functions with a special WebMethod ()> attribute in order them to work as Web Service.
Web services are discovered using UDDI directory services.
Web services are built on XML standard and use SOAP protocol that allows them to communicate across different platforms and programming languages.
Web services easily manage to work across corporate firewalls as they use HTTP protocol which is firewall friendly.
Web services platform elements are
SOAP (Simple Object Access Protocol)
UDDI (Universal Description, Discovery and Integration)
WSDL (Web Services Description Language)
The web services are built on internet standards that are not platform or language specific.
The .Net framework provides in-built classes to build and consume web services.
The components offered by web services are reusable.
The examples of web service components can be shipment tracking, translation utility, weather forecasting, sports scores etc.