How to insert and retrieve data from sql to c# window

Please check the following link:

http://dotnetperls.com/datatable[^]

Please check the following tutorial:
http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson03.aspx[^]

Another guide for beginners:
http://www.codeproject.com/KB/database/sql_in_csharp.aspx

On Page load event write this code


private void page_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(@"Server=NGENIOUS-WSSDEV\SQLEXPRESS;Database=MIC;Trusted_Connection= True");
// SqlCommand cmd = new SqlCommand("select * from measurementunit",conn);
SqlDataAdapter da = new SqlDataAdapter("select * from measurementunit",conn);
conn.Open();
DataSet ds = new DataSet();

da.Fill(ds, "measurementunit");
conn.Close();
}


then on click of button



private void btninsert_Click(object sender, EventArgs e)
{
SqlConnection cnn = new SqlConnection(@"Server=NGENIOUS-WSSDEV\SQLEXPRESS;Database=MIC;Trusted_Connection= True");

// cnn.ConnectionString = ;
cnn.Open();

// cmd.Connection = cnn;
//cmd.CommandType = CommandType.Text;

SqlParameter p1 = new SqlParameter("@measurment", txtmu.Text);
SqlParameter p2 = new SqlParameter("@mucode", txtmucode.Text);
string query = "insert into measurementunit values('" + p1.Value + "','" + p2.Value + "')";
SqlCommand cmd = new SqlCommand(query,cnn);
// cmd.CommandText = "insert into measurementunit('"+ p1.Value+"','"+p2.Value+"')";
//cmd.CommandType = CommandType.Text;
//SqlDataReader dr = cmd.ExecuteReader();

cmd.ExecuteNonQuery();
cnn.Close();


MessageBox.Show("Your information have Submited");
}



First code will help you to do connection of code and button click will help you to insert data in sql server db :laugh: :thumbsup::rose: