reocrd is not inserted in gridview

What you have done was, you try to execute the "insert" and "select" query in a single SQL statement. But you can't do that (as per your way). Instead i have split it up 2 parts. In the first part i have executed the insert query and in the second part i execute the select query and then fill it in Datatable, which can be bound to Gridview.

hi francis, thank you for responding.

 i understand your code but haven't apply yet.could you please explain what your code exactly says.thank you

hello sir.how are you?
as i mentioned in post that i want to insert data in a database by using executenonquery().
 record(data) is inserted in db but application does not run giving the error i mentioned. i want my application to insert data and display it on runtime.you can have my code in the post.

Try the below Code, It works fine for me, if you have any clarification let me know:

 protected void Page_Load(object sender, EventArgs e)
  {
  string select = "select * from student_table";
  string cs = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString.ToString();
  using (SqlConnection conn = new SqlConnection(cs))
  {
  conn.Open();
  SqlCommand cmd = new SqlCommand("insert into student_table(id,name,age) values(10,'danish qamar',6)" , conn);
  cmd.CommandType = CommandType.Text;
  cmd.ExecuteNonQuery();
  }
  DataTable dt=new DataTable("MyTable");
  //rebind the datagrid
  using (SqlConnection conn = new SqlConnection(cs))
  {
  conn.Open();
  SqlCommand cmd = new SqlCommand(select, conn);
  cmd.CommandType = CommandType.Text;
  SqlDataAdapter da = new SqlDataAdapter(cmd);
  da.Fill(dt);
  }
  GridView1.DataSource = dt;
  GridView1.DataBind();
  }

Hey Umair


 Can you tell me what exzactly  what is your requirment.coz the code is not understanable which exazactly you write and  write .so please elobrate your requirment .and i provide the exzact code .


Hope you understand