protected void DetailsView1_ItemInserting(object sender, DetailsViewInsertEventArgs e)
{
string insert = "insert into movies (title)"+"values (@title)";
SqlConnection conn = new SqlConnection(constr);
SqlCommand mycom = new SqlCommand(insert,conn);
mycom.Parameters.Add = (new SqlParameter("@title", SqlDbType.NVarChar, 10));
mycom.Parameters["@title"].Value = ((TextBox)this.DetailsView1.Rows[1].Cells[1].Controls[0]).Text.ToString();
//mycom.Parameters.AddWithValue("@title", ((TextBox)this.DetailsView1.Rows[1].Cells[1].Controls[0]).Text.ToString());
conn.Open();
mycom.ExecuteNonQuery();
conn.Close();
DetailsBind();
}红字处说是
“Add”是一个“方法组”,无法为它赋值
还有,怎么在detailview里取到数据并插入到数据库内?
{
string insert = "insert into movies (title)"+"values (@title)";
SqlConnection conn = new SqlConnection(constr);
SqlCommand mycom = new SqlCommand(insert,conn);
mycom.Parameters.Add = (new SqlParameter("@title", SqlDbType.NVarChar, 10));
mycom.Parameters["@title"].Value = ((TextBox)this.DetailsView1.Rows[1].Cells[1].Controls[0]).Text.ToString();
//mycom.Parameters.AddWithValue("@title", ((TextBox)this.DetailsView1.Rows[1].Cells[1].Controls[0]).Text.ToString());
conn.Open();
mycom.ExecuteNonQuery();
conn.Close();
DetailsBind();
}红字处说是
“Add”是一个“方法组”,无法为它赋值
还有,怎么在detailview里取到数据并插入到数据库内?
哥。。吧等号去掉行不!!