inserting data into a sqlserverdatabase

Question

how to insert dynamic data from a asp.net page in sqlserver database

Answer 1

you have a multiple way to insert dynamic data in sqldatabase server.

  string sqlinsert="insert into [table name] values (column1,column2....)";
    //instanite connection object

    sqlconnection conn =new sqlconnection("connection string");

    //intantiate command object

    sqlcommand cmd = new sqlcommand(sqlinsert,conn);

       parameter.addwithvalue("column1" ,"textbox.1");

     try
      { 
      conn.open();
      cmd.Executenonquery();
      }
      catch(Exception,err)
      {
      //put error message at any level
      }
      finally
       {
      conn.close();
     }