我们的程序代码是这样的,为什么我们点了更新后数据库没有改变呢?
private void BindUserData()
{
//创建数据库的连接和访问的SQL语句,同时构造控件的数据源
SqlConnection myConnection = new SqlConnection(ConnectionString);
string cmdText = "select Users.UserName,Users.Password,Users.Email,Role.RoleName from Users,Role where Users.RoleID=Role.RoleID";
SqlDataAdapter da=new SqlDataAdapter(cmdText,myConnection);
myConnection.Open();
DataSet ds=new DataSet();
da.Fill(ds);
UserData.DataSource=ds;
UserData.DataBind();
myConnection.Close();
}private void UserData_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
UserData.EditItemIndex=e.Item.ItemIndex;
BindUserData();
} private void UserData_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
UserData.EditItemIndex=-1;
BindUserData();
} private void UserData_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
UserData.EditItemIndex=-1;
BindUserData();
}
private void BindUserData()
{
//创建数据库的连接和访问的SQL语句,同时构造控件的数据源
SqlConnection myConnection = new SqlConnection(ConnectionString);
string cmdText = "select Users.UserName,Users.Password,Users.Email,Role.RoleName from Users,Role where Users.RoleID=Role.RoleID";
SqlDataAdapter da=new SqlDataAdapter(cmdText,myConnection);
myConnection.Open();
DataSet ds=new DataSet();
da.Fill(ds);
UserData.DataSource=ds;
UserData.DataBind();
myConnection.Close();
}private void UserData_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
UserData.EditItemIndex=e.Item.ItemIndex;
BindUserData();
} private void UserData_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
UserData.EditItemIndex=-1;
BindUserData();
} private void UserData_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
UserData.EditItemIndex=-1;
BindUserData();
}
Width="606px" AutoGenerateColumns="False">
<AlternatingItemStyle BackColor="#CCCCCC"></AlternatingItemStyle>
<Columns>
<asp:BoundColumn DataField="UserID" HeaderText="用户ID"></asp:BoundColumn>
<asp:BoundColumn DataField="UserName" HeaderText="用户名"></asp:BoundColumn>
<asp:BoundColumn DataField="Password" HeaderText="用户密码"></asp:BoundColumn>
<asp:BoundColumn DataField="Email" HeaderText="用户Email"></asp:BoundColumn>
<asp:BoundColumn DataField="RoleName" HeaderText="用户角色"></asp:BoundColumn>
<asp:TemplateColumn HeaderText="删除用户">
<HeaderStyle HorizontalAlign="Left"></HeaderStyle>
<ItemStyle HorizontalAlign="Left" Width="20%"></ItemStyle>
<ItemTemplate>
<asp:LinkButton ID="Mydelete" Runat="server" CommandName="delete">删除此用户</asp:LinkButton>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:datagrid>我想取出UserID怎么取的出来啊