Here is a simple example of connectivity :
Note : Make the tables in SQL Server Management Studio.
protected void btnsubmit_Click(object sender, EventArgs e)
{
SqlConnection CON;
SqlCommand COM;
CON = new SqlConnection(ConfigurationManager.ConnectionStrings["Database_Name"].ConnectionString);
COM = new SqlCommand("INSERT INTO TableName (ID, Name, Address) VALUES (@ID, @Name, @Address)", CON);
COM.Parameters.Add("@ID", System.Data.SqlDbType.NChar,10);
COM.Parameters["@ID"].Value = txtid.Text;
COM.Parameters.Add("@Name", System.Data.SqlDbType.NChar,50);
COM.Parameters["@Name"].Value = txtname.Text;
COM.Parameters.Add("@Address", System.Data.SqlDbType.NChar,100);
COM.Parameters["@Address"].Value = txtaddress.Text;
CON.Open();
COM.ExecuteNonQuery();
Response.Redirect("Default.aspx");
}
protected void btnupdate_Click(object sender, EventArgs e)
{
SqlConnection CON;
SqlCommand COM;
CON = new SqlConnection(ConfigurationManager.ConnectionStrings["Database_Name"].ConnectionString);
COM = new SqlCommand("Update <b>TableName</b>set Name=@Name,Address=@Address where ID=@Id",CON);
COM.Parameters.Add("@ID", System.Data.SqlDbType.NChar, 10);
COM.Parameters["@ID"].Value = txtid.Text;
COM.Parameters.Add("@Name", System.Data.SqlDbType.NChar, 50);
COM.Parameters["@Name"].Value = txtname.Text;
COM.Parameters.Add("@Address", System.Data.SqlDbType.NChar, 100);
COM.Parameters["@Address"].Value = txtaddress.Text;
CON.Open();
COM.ExecuteNonQuery();
Response.Redirect("Default.aspx");
CON.Close();
}
protected void btndelete_Click(object sender, EventArgs e)
{
SqlConnection CON;
SqlCommand COM;
CON = new SqlConnection(ConfigurationManager.ConnectionStrings["DataBaseName"].ConnectionString);
COM = new SqlCommand("Delete from TableName where ID=@ID",CON);
COM.Parameters.Add("@ID", System.Data.SqlDbType.NChar, 10);
COM.Parameters["@ID"].Value = txtid.Text;
COM.Parameters.Add("@Name", System.Data.SqlDbType.NChar, 50);
COM.Parameters["@Name"].Value = txtname.Text;
COM.Parameters.Add("@Address", System.Data.SqlDbType.NChar, 100);
COM.Parameters["@Address"].Value = txtaddress.Text;
CON.Open();
COM.ExecuteNonQuery();
Response.Redirect("Default.aspx");
CON.Close();
}
Add a connection String in Web.Config
<connectionStrings>
<add name="DataBaseName" connectionString="Server=ADMIN-PC;Database=DataBaseName;Integrated Security=True" providerName="System.Data.SqlClient"/>
</connectionStrings>