能显示表QA_AnswerCollection 中的数据，但是不能插入，也没报错，这是怎么回事啊？

[玖兰枢]

string strCon = "Data Source=HXL-PC;Initial Catalog=QuestionAnswerDB;Integrated Security=True";
SqlConnection myConnection = new SqlConnection(strCon);
myConnection.Open();

SqlDataAdapter adapter = new SqlDataAdapter();
DataSet myds = new DataSet();

//string addstr = "insert into QA_AnswerCollection values('"+uid+"','"+qid+"')";
string addstr = "INSERT INTO QA_AnswerCollection(UserId, QuestionId) VALUES ('"+uid+"','"+qid+"')";
SqlCommand myCommand = new SqlCommand(addstr,myConnection);
adapter.SelectCommand = myCommand;

string str = "select * from QA_AnswerCollection";
SqlCommand com = new SqlCommand(str,myConnection);
adapter.SelectCommand = com;

adapter.Fill(myds);
GridView1.DataSource = myds;
GridView1.DataBind();

[bdmh]

你没有执行 SqlCommand 的ExecuteNonQuery

[玖兰枢]

引用 1 楼 bdmh 的回复:

你没有执行 SqlCommand 的ExecuteNonQuery

就是这个问题，太感谢了