insert method using database

string constring ="Server=LAB02-19\SQLEXPRESS;Database=insert";

// Write parameters into your sql with a @
string Sql="Insert into info (stname, rollnuminsert) values (@stname , @rollnuminsert)";

// Put the connection string in the SqlConnection
SqlConnection conn = new SqlConnection(constring);

// Give the command the connection and sql statement
SqlCommand cmd = new SqlCommand(Sql, conn);

// Get your data
string stname = TextBox1.Text; // just example
int rollnuminsert = Int32.Parse(TextBox2.Text); // just example

// You have to give the command parameters that are in your sql statement
cmd.Parameters.Add("@stname", SqlDbType.VarChar).Value = stname;
cmd.Parameters.Add("@rollnuminsert", SqlDbType.Int).Value = rollnuminsert;

// Make a data adapter
SqlDataAdapter daMain = new SqlDataAdapter();
daMain.InsertCommand = cmd;

// Open the connection
conn.Open();

// Execute the command
int a = daMain.InsertCommand.ExecuteNonQuery();

// Close the connection
conn.Close();
------------------------


Here is another example.

SqlConnection sc = new SqlConnection(Properties.Settings.Default.PSRConnectionString);
String strSql = "Insert Into clientTimes (ClientID, TimeIn, TimeOut) " +
  "VALUES(@ClientID,@Time1, @Time2)";
SqlCommand cmdInsert = new SqlCommand(strSql, sc);
cmdInsert.Parameters.Add("@ClientID", SqlDbType.Int).Value = clid;
cmdInsert.Parameters.Add("@Time1", SqlDbType.DateTime).Value = time1;
cmdInsert.Parameters.Add("@Time2", SqlDbType.DateTime).Value = time2;
daMain.InsertCommand = cmdInsert;
sc.Open();
daMain.InsertCommand.ExecuteNonQuery();
sc.Close();

I'm new to this to but the above seem like the standard steps(if not using TableAdapters)
Hope this helps.

no its not working

write your query like this
string Sql="Insert Into Info(Stname,rollnum)values('ali',1);