我在GridView里面用了sqlDatasource,然后又用了一个按钮添加新的数据,但是能添加记录而且能在GridView中看到,可是看数据库的表里面时却没有更新,怎么回事?
这是我增加的按钮的代码
protected void DB_btnAdd_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
SqlConnection conn = new SqlConnection();
conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Insert into MO_DB (DB_Data,DB_State,DB_Level,DB_Item) ";
cmd.CommandText += "Values ('" + DB_txtData.Text + "','";
// cmd.CommandText += DB_txtData.Text + "','";
cmd.CommandText += DropDownList1.SelectedValue + "','";
cmd.CommandText += DropDownList2.SelectedValue + "','";
cmd.CommandText += DB_txtItem.Text + "')";
// cmd.CommandText += " where
cmd.Connection = conn;
conn.Open();
cmd.ExecuteNonQuery(); conn.Close(); Response.Redirect("DB_Manage.aspx");
}
这是我增加的按钮的代码
protected void DB_btnAdd_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
SqlConnection conn = new SqlConnection();
conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Insert into MO_DB (DB_Data,DB_State,DB_Level,DB_Item) ";
cmd.CommandText += "Values ('" + DB_txtData.Text + "','";
// cmd.CommandText += DB_txtData.Text + "','";
cmd.CommandText += DropDownList1.SelectedValue + "','";
cmd.CommandText += DropDownList2.SelectedValue + "','";
cmd.CommandText += DB_txtItem.Text + "')";
// cmd.CommandText += " where
cmd.Connection = conn;
conn.Open();
cmd.ExecuteNonQuery(); conn.Close(); Response.Redirect("DB_Manage.aspx");
}
一看便知 。
会返回一个int值 。表示的受影响行数 。