Question

ExecuteNonQuery 要求已打开且可用的连接。连接的当前状态为已关闭

string strS = "insert 个(歌曲)values('" + TextBox2.Text + "')";
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = strS;
//SqlDataAdapter da = new SqlDataAdapter(strS,conn );
//DataSet ds = new DataSet();
//da.Fill(ds, "t1");
//GridView1.DataSource = ds.Tables["t1"].DefaultView;
cmd.ExecuteNonQuery();
conn.Close();
GridView1.DataBind();

Answer 1

在cmd.executeNonQuery();
之前加上
conn.open();