C#

using(SqlConnection connection = new SqlConnection(connectionString)) {
    connection.Open();
    using (SqlCommand command = new SqlCommand("your sql statement", connection)) {
        using(SqlDataReader reader = command.ExecuteReader()){
            while(reader.Read()){
                list.Add((Int32)reader[0]);
            }
        }
    }
}

<br />
command.ExecuteReader(CommandBehavior.CloseConnection);<br />

Ennis Ray Lynch, Jr. wrote:

In my younger career I used to use stored procedures exclusively. I have now
moved to embedding the SQL statments in the source files for easier version
control.

shubham salwan wrote:

please send me the code of save button.(c#)

Bastard Programmer from Hell
if you can't read my code, try converting it here[^]

protected void btnSave_Click(object sender, EventArgs e)

{
   string connString = "Data Source=ServerName;Initial Catalog=DbName;Integrated Security=True"; SqlConnection conn = new    SqlConnection(connString);
   conn.Open();
     String sql = "INSERT INTO CustomerInfo(FirstName, LastName, Address, Order, Quantity) values ('Sai', 'Prasad',    'Hyderabad', 1, 100)";
SqlCommand cmd = new SqlCommand(sql,conn);
     cmd.ExecuteNonQuery();

   conn.Close();

}

using System.Data.SqlClient;

shubham salwan wrote:

i am not able o make connection con

private void button1_Click(object sender, EventArgs e)
        {
            string connString = "Data Source=shubhi-PC;Initial Catalog=employee;uid=sa;pass=abc;Integrated Security=True"; SqlConnection conn = new SqlConnection(connString);
            conn.Open();
            String sql = "INSERT INTO emp_detail(empid,empname,empadd,empsal) values ('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "')";
            
            cmd.ExecuteNonQuery();

            conn.Close();
            textBox1.Text="";