arameters["@method"].Value = txtMethod.Text.Trim();
conn.Open();
comm1.ExecuteNonQuery();//执行更新命令
conn.Close();
Response.Write("<script>alert(''''插入数据成功!'''');</script>");
BindData();//再次绑定数据
}
}
}
private void dgTree_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
string connString = ConfigurationSettings.AppSettings["connStr1"].ToString();//连接数据库
SqlConnection conn = new SqlConnection(connString);
string delString = "delete from treeview where biaoshi_id=@biaoshi_id";//删除语句
SqlCommand comm = new SqlCommand(delString,conn);
comm.Parameters.Add(new SqlParameter("@biaoshi_id",SqlDbType.Int));//添加参数并且给参数赋值
comm.Parameters["@biaoshi_id"].Value = dgTree.DataKeys[e.Item.ItemIndex];//把单击删除按钮这行的主键值给参数赋值
conn.Open();
comm.ExecuteReader();//执行删除命令
conn.Close();
BindData();//重新绑定数据
}
private void dgTree_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
//更新数据
string connString = ConfigurationSettings.AppSettings["connStr1"].ToString();//连接数据库
SqlConnection conn = new SqlConnection(connString);
//先看是不是有ID重复的节点
string selString = "select Count(*) from treeview where ID=@ID";
SqlCommand comm = new SqlCommand(selString,conn);
comm.Parameters.Add(new SqlParameter("@ID",SqlDbType.Int));//添加参数并且给参数赋值
comm.Parameters["@ID"].Value = Convert.ToInt32((e.Item.Cells[2].Controls[0] as TextBox).Text.Trim());//把单击更新按钮这行的ID值给参数赋值
conn.Open();
int i = (int)comm.ExecuteScalar();
conn.Close();
if(i>0)//如果存在相同的节点值
{
Page.RegisterStartupScript("","<script>alert(''''已经存在相同ID值的节点,请重新输入!'''');document.getElementById(''''TianJia'''').style.display='''''''';</script>");
return;
}
else
{
string updateString = "update treeview set ID=@ID,parentId=@parentId,text=@text,hint=@hint,icon=@icon,data=@data,url=@url,target=@target,method=@method where biaoshi_id=@biaoshi_id";
//更新数据库命令
SqlCommand comm1 = new SqlCommand(updateString,conn);
comm1.Parameters.Add(new SqlParameter("@biaoshi_id",SqlDbType.Int));//添加参数并且给参数赋值
comm1.Parameters["@biaoshi_id"].Value = dgTree.DataKeys[e.Item.ItemIndex];//把单击删除按钮这行的主键值给参数赋值
comm1.Parameters.Add(new SqlParameter("@ID",SqlDbType.Int));
comm1.Parameters.Add(new SqlParameter("@parentId",SqlDbType.Int));
comm1.Parameters.Add(new SqlParameter("@text",SqlDbType.VarChar,255));
comm1.Parameters.Add(new SqlParameter("@hint",SqlDbType.VarChar,255));
comm1.Parameters.Add(new SqlParameter("@icon",SqlDbType.VarChar,50));
comm1.Parameters.Add(new SqlParameter("@data",SqlDbType.VarChar,255));
comm1.Parameters.Add(new SqlParameter("@url",SqlDbType.VarChar,255));
comm1.Parameters.Add(new SqlParameter("@target",SqlDbType.VarChar,50));
comm1.Parameters.Add(new SqlParameter("@method",SqlDbType.VarChar,255));
//上面都是添加参数,下面是给参数赋值
comm1.Parameters["@ID"].Value = Convert.ToInt32((e.Item.Cells[2].Controls[0] as TextBox).Text.Trim());
comm1.Parameters["@parentId"].Value = Convert.ToInt32((e.Item.Cells[3].Controls[0] as TextBox).Text.Trim());
comm1.Parameters["@text"].Value = (e.Item.Cells[4].Controls[0] as TextBox).Text.Trim();
comm1.Parameters["@hint"].Value = (e.Item.Cells[5].Controls[0] as TextBox).Text.Trim();
comm1.Parameters["@icon"].Value = (e.Item.Cells[6].Controls[0] as TextBox).Text.Trim();
comm1.Parameters["@data"].Value = (e.Item.Cells[7].Controls[0] as TextBox).Text.Trim();
comm1.Parameters["@url"].Value = (e.Item.Cells[8].Controls[0] as TextBox).Text.Trim();
comm1.Parameters["@target"].Value = (e.Item.Cells[9].Controls[0] as TextBox).Text.Trim();
comm1.Parameters["@method"].Value = (e.Item.Cells[10].Controls[0] as TextBox).Text.Trim();
conn.Open();
comm1.ExecuteNonQuery();//执行更新命令
conn.Close();
Response.Write("<script>alert(''''更新数据成功!'''');</script>");
dgTree.EditItemIndex = -1;//让编辑状态取消
BindData();//再次绑定数据
}
}
}
}
我在数据表中添加了一个字段biaoshi_id,他是标识列,自动递增.
上一页 [1] [2] [3] |
