新人求助，关于Gridview控件增删改查

  protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
          string pbid = ((GridView1.Rows[e.RowIndex].Cells[1].Controls[0]) as TextBox).Text.ToString().Trim();//说未将对象应用设置到对象的实例
       string puser = ((GridView1.Rows[e.RowIndex].Cells[2].Controls[0]) as TextBox).Text.ToString().Trim();
        string pid1 = ((GridView1.Rows[e.RowIndex].Cells[3].Controls[0]) as TextBox).Text.ToString().Trim();
       string pname1 = ((GridView1.Rows[e.RowIndex].Cells[4].Controls[0]) as TextBox).Text.ToString().Trim();
       string pnum1 = ((GridView1.Rows[e.RowIndex].Cells[5].Controls[0]) as TextBox).Text.ToString().Trim();
       string punit1 = ((GridView1.Rows[e.RowIndex].Cells[6].Controls[0]) as TextBox).Text.ToString().Trim();
       string ptotal1 = ((GridView1.Rows[e.RowIndex].Cells[7].Controls[0]) as TextBox).Text.ToString().Trim();
       
        string sqlstr = "update  Usermaggess  set pbillon='"
           + pbid + "',pusername='"
            + puser + "',pid='"
          + pid1 + "',pname='"
          + pname1  + "',punm='"
         + pnum1 + "',punit='"
          + punit1 + "',ptotal='"
            + ptotal1 + "', where pbillon='"
           + pbid + "'";
       
        sqlcon = new SqlConnection(strCon);
        sqlcom = new SqlCommand(sqlstr, sqlcon);
        sqlcon.Open();
        sqlcom.ExecuteNonQuery();
        sqlcon.Close();
        GridView1.EditIndex = -1;
        bind();
    }请给我帮忙看看，本人菜鸟，刚刚学习

解决方案 »

  1.   

    帮你顶下吧   我也不知道哦                                               http://www.56deppon.com
      

  2.   


    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" PageSize="10"                         Width="542px" AllowPaging="True" AllowSorting="True"                         DataKeyNames="DB31_1,DB31_2" OnRowCancelingEdit="GridView1_RowCancelingEdit" OnRowDeleting="GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating" OnPageIndexChanging="GridView1_PageIndexChanging" OnRowDataBound="GridView1_RowDataBound" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" OnSorting="GridView1_Sorting" >                        <Columns>                            <asp:TemplateField HeaderText="序号">                                <ItemTemplate>                                <%# this.GridView1.PageIndex * this.GridView1.PageSize + this.GridView1.Rows.Count + 1%>                                </ItemTemplate>                            </asp:TemplateField>                            <asp:TemplateField HeaderText="学历代码" SortExpression="DB1_1">                                <EditItemTemplate>                                    <%--<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("DB1_1") %>'></asp:TextBox>--%>                               <asp:DropDownList ID ="ddlXL" runat="server"  DataValueField='<%# Bind("DB1_1") %>'></asp:DropDownList>                                </EditItemTemplate>                                <ItemTemplate>                                    <asp:Label ID="Label1" runat="server" Text='<%# Bind("xueliText") %>'></asp:Label>                                </ItemTemplate>                            </asp:TemplateField>                            <asp:TemplateField HeaderText="学历名称" SortExpression="DB1_2">                                <EditItemTemplate>                                    <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("DB1_2") %>'></asp:TextBox>                                </EditItemTemplate>                                <ItemTemplate>                                    <asp:Label ID="Label2" runat="server" Text='<%# Bind("DB1_2") %>'></asp:Label>                                </ItemTemplate>                            </asp:TemplateField>                                                  <asp:TemplateField HeaderText="操作" ShowHeader="False">                        <EditItemTemplate>                            <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="True" CommandName="Update"                                 Text="更新"></asp:LinkButton>                            <asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" CommandName="Cancel"                                Text="取消"></asp:LinkButton>                        </EditItemTemplate>                        <ItemTemplate>                            <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Edit"                                Text="编辑" OnClientClick="return confirm('确认要编辑吗？');"></asp:LinkButton>                                                    <asp:LinkButton ID="LinkButton3" runat="server" CausesValidation="False" CommandName="Delete"                                Text="删除" OnClientClick="return confirm('确认要删除吗？');"></asp:LinkButton>                            <asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" CommandName="Select"                                Text="选择"></asp:LinkButton>                        </ItemTemplate>                        </asp:TemplateField>                       </Columns>                       <AlternatingRowStyle BackColor="Aquamarine" />                    </asp:GridView> /// <summary>    /// 绑定数据到GridView    /// </summary>    private void GridViewBind()    {        检索数据库        string strSql = "SELECT * FROM DB1";        得到数据集        this.GridView1.DataSource=conn.GetDs(strSql).Tables[0].DefaultView;        this.GridView1.DataBind();       }    /// <summary>    /// 编辑当前行    /// </summary>    /// <param name="sender"></param>    /// <param name="e"></param>    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)    {        GridView1.EditIndex = e.NewEditIndex;        //当前编辑行背景色高亮        this.GridView1.EditRowStyle.BackColor = Color.FromName("#F7CE90");        GridViewBind();    }    /// <summary>    /// 取消编辑状态    /// </summary>    /// <param name="sender"></param>    /// <param name="e"></param>    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)    {        GridView1.EditIndex = -1;        GridViewBind();    }    /// <summary>    /// 删除记录过程    /// </summary>    /// <param name="sender"></param>    /// <param name="e"></param>    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)    {        //得到单位编号        string rowToDelete = GridView1.DataKeys[e.RowIndex].Values[0].ToString();        //转换为整数        //int ID=Convert.ToInt32(rowToDelete);        //从数据库中删除        string str = "DELETE FROM DB1 where DB1_1=" + "'" + rowToDelete + "'" + "";               try        {        conn.RunSql(str);        //重新绑定数据        GridViewBind();        }        catch (Exception ex)        {        Response.Write("数据库错误，错误原因：" + ex.Message);        Response.End();        }    }    /// <summary>    /// 更新记录过程    /// </summary>    /// <param name="sender"></param>    /// <param name="e"></param>    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)    {        string ID = GridView1.DataKeys[e.RowIndex].Values[0].ToString();        string DB1_1 = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox1")).Text;        //string DB1_2 = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox2")).Text;        string DB1_2 = (((DropDownList))GridView1.Rows[e.RowIndex].FindControl("ddlXL")).SelectedItem.Text;            //判断表单项是否有空并给出提示信息        if (DB1_1 == "" || DB1_2 == "")        {            conn.Alert("请输入完整信息！", Page);            return;        }                    try       {        conn.BuilderEdit("select * from DB1 where DB1_1 ='" + ID + "'");        conn.dr["DB1_1"] = DB1_1;        conn.dr["DB1_2"] = DB1_2;        conn.BuilderEditClose();       }       catch (OracleException err)       {            if (err.Code.ToString() == "1")                conn.Alert("错误：已存在具有相同主键的记录", Page);            else                conn.Alert("错误：未能添加记录", Page);        }        Response.Write("<script language='javascript'>alert('数据已被保存!');</script>");        //返回浏览状态        GridView1.EditIndex = -1;        GridViewBind();    }    /// <summary>    /// 分页事件    /// </summary>    /// <param name="sender"></param>    /// <param name="e"></param>    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)    {        GridView1.PageIndex = e.NewPageIndex;        GridViewBind();    }    /// <summary>    /// 加入鼠标效果及为DropDownList绑定值    /// </summary>    /// <param name="sender"></param>    /// <param name="e"></param>    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)    {        //为DropDownList绑定值        if (((DropDownList)e.Row.FindControl("ddlXL")) != null)        {            DropDownList ddlXL = (DropDownList)e.Row.FindControl("ddlXL");            ddlXL.Items.Clear();            ddlXL.Items.Add(new ListItem("博士", "1"));            ddlXL.Items.Add(new ListItem("硕士", "2"));            ddlXL.Items.Add(new ListItem("学士", "3"));        }        //加入鼠标滑过的高亮效果        if (e.Row.RowType == DataControlRowType.DataRow)//判定当前的行是否属于datarow类型的行        {            //当鼠标放上去的时候 先保存当前行的背景颜色 并给附一颜色            e.Row.Attributes.Add("onmouseover", "currentcolor=this.style.backgroundColor;this.style.backgroundColor='yellow',this.style.fontWeight='';");            //当鼠标离开的时候 将背景颜色还原的以前的颜色            e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=currentcolor,this.style.fontWeight='';");        }        //单击行改变行背景颜色        if (e.Row.RowType == DataControlRowType.DataRow)        {            e.Row.Attributes.Add("onclick", "this.style.backgroundColor='#99cc00'; this.style.color='buttontext';this.style.cursor='default';");        }     }
      

  3.   

    按照楼上那么写更新的话，会提示数据不能转换成textbox
      

  4.   

    做的太麻烦，直接改成：  string pbid = (GridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
      

  5.   

    http://blog.csdn.net/21aspnet/article/details/1540301 看来这篇你绝对会了