reocrd is not inserted in gridview

Question

i am having an issue in inserting record in gridview and show it when application runs. i am using executenonquery() method .my code is below.
protected void Page_Load(object sender, EventArgs e)
{
string select = "select * from student_table";
string cs = ConfigurationManager.ConnectionStrings["Database1ConnectionString1"].ConnectionString.ToString();
SqlConnection conn = new SqlConnection(cs);
conn.Open();
SqlCommand cmd = new SqlCommand("insert into student_table (id,name,class) values(1,'danish qamar',6)"+select ,conn);
cmd.CommandType = CommandType.Text;

GridView1.DataSource = cmd.ExecuteNonQuery();
GridView1.DataBind();
conn.Close();

}

by using above code record is inserting in the database but not displaying when application run
i got following error:
Data source is an invalid type. It must be either an IListSource, IEnumerable, or IDataSource.
help me to solve it please.

Francis · Answer

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.

umair mohsin · Answer

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

umair mohsin · Answer

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.

Francis · Answer

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(idnameage) 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(); }

Abhijit Patil · Answer

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