C#

<br />
Convert.ToInt32(affiche_titre["libelle_titre"].ToString());<br />

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

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;