gridview 删除和更新 有问题:

Question

gridview 删除和更新 有问题:
updatecommend 未申明,sqldatesouice无法执行该语句,detelecommend未声明,无法执行
 <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
                      DataKeyNames="id" DataSourceID="SqlDataSource1"
                      PageSize="15"  CssClass="table1" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" >
                      <PagerSettings FirstPageText="首页" LastPageText="尾页" NextPageText="下一页" PreviousPageText="上一页" />
                      <Columns>
                          <asp:BoundField DataField="id" HeaderText="编号" InsertVisible="False" ReadOnly="True"  SortExpression="id"  >
                              <HeaderStyle CssClass="tdtitle2" />
                              <ItemStyle CssClass="td" />
                          </asp:BoundField>
                          <asp:BoundField DataField="username" HeaderText="用户名" SortExpression="username" >
                              <HeaderStyle CssClass="tdtitle2" />
                              <ItemStyle CssClass="td" />
                          </asp:BoundField>
                          <asp:BoundField DataField="password" HeaderText="密码" SortExpression="password" >
                              <HeaderStyle CssClass="tdtitle2" />
                              <ItemStyle CssClass="td" />
                          </asp:BoundField>
                          <asp:BoundField DataField="managerlevel" HeaderText="用户权限" SortExpression="managerlevel" >
                              <HeaderStyle CssClass="tdtitle2" />
                              <ItemStyle CssClass="td" />
                          </asp:BoundField>
                          <asp:CommandField ButtonType="Button" EditText="修改" HeaderText="操作" ShowDeleteButton="True"
                              ShowEditButton="True" UpdateText="保存">
                              <ControlStyle CssClass="button" />
                              <HeaderStyle CssClass="tdtitle2" />
                              <ItemStyle CssClass="td" Width="150px" />
                          </asp:CommandField>
                      </Columns>
                  </asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:21cnfConnectionString3 %>"
            SelectCommand="SELECT * FROM [AdminUserList]" ></asp:SqlDataSource>
=========================以上为Admin.aspx
=========================以下为Admin.aspx.cs
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {
        string username, password;
        Int32 id, level;
        username = this.GridView1.SelectedRow.Cells[1].Controls[0].ToString();
        password = this.GridView1.SelectedRow.Cells[2].Controls[0].ToString();
        id = Int32.Parse(this.GridView1.SelectedRow.Cells[0].Controls[0].ToString());
        level = Int32.Parse(this.GridView1.SelectedRow.Cells[3].Controls[0].ToString());
        SqlDataSource1.UpdateCommand = "update AdminUserList set username='" + username + "',password='" + password + "',managerlevel=" + level + " where id=" + id;
        Response.Write(username);
    }

Answer 1

SqlDataSource1.UpdateCommand = "update AdminUserList set username='" + username + "',password='" + password + "',managerlevel='" + level + "' where id=" + id; 
        

Answer 2

剛才有拿你的代碼去做實驗﹐是對的﹐你在看看你的哪里出了點問題 protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {
        string lease_bunk, lease_rent;
        lease_rent = this.GridView1.SelectedRow.Cells[1].Controls[0].ToString();
        lease_bunk = this.GridView1.SelectedRow.Cells[0].Controls[0].ToString();
        SqlDataSource1.UpdateCommand = "update lease set lease_bunk='" + lease_bunk + "' where lease_bunk=" + lease_bunk;
        Response.Write(lease_rent);     }

Answer 3

喔﹐可能你前面的SqlDataSource1建立的時候沒有選擇insert/update/delete
建立SqlDataSource1 時候有 WHERE ;ORDER BY... ; ADVANCED ...
選擇ADCENCED 看是否選擇了INSERET/DELETE/UPDATE .....

Answer 4

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString=" <%$ ConnectionStrings:21cnfConnectionString3 %>" 
            SelectCommand="SELECT * FROM [AdminUserList]" > </asp:SqlDataSource> 
楼上的大哥,我sqldatasource的语句如上,可是只是select.不需要insert/update/delete 
请问怎么改

Answer 5

1楼的，我的level是整形的，不是那个的问题

Answer 6

我怎么感觉好象是你在设置SqlDataSource的问题,应该设置成insert吧