Add new record in to sql database

          Here i am writing the code for add new record.(By using asp.net with C#.net)

               1) u should create table name like (student) in database or u can create from front end
                                itself     and create some fields like sno and sname   ok..........
               2) u should take fields like student number, student name   and u take button name
                             like ADD or INSERT      ok................
               3)double click ADD or INSERT button and then
               4)go to the coding part and type following statement in namespaces
                                      using System.Data.SqlClient;
               5) Button1_click
                      {
                         try
                        {
                         sqlconnection  con= new sqlconnection 
                               (userid=..;password=................;server=............;database=............. ");
                          
                          sqlcommand cmd=new sqlcommand();
                          con.open();
                          cmd.commandtext="insert into student values
                                                            ("+textbox1.text+",'"+textbox2.text+"')";
                          cmd.connection=con;
                          cmd.ExecuteNonQuery();
                          con.close();
                          Response.Write("Records Are Insertd");
                       }
                       catch(SqlException e)
                          {
                              Response.write(E.Message());
                           }
 
                       }//Button1
                       

There are various ways to do this. I personally, would call a stored procedure to insert a record in my table.

Here's a link to get you started:

This example constructs an insert query.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1738271&SiteID=1