关于gridview的使用，菜鸟被卡一整天了...

名字都被起了 2015-02-06 09:48:01

我想实现的功能是这样的：

输入工号，点查询就有如图效果，这个已经是实现了的....
但是里面的编辑，选择，删除这三个功能不起效果
我用的数据源是SqlDataSource，启用了自带的编辑，删除（原谅我不太会...）



<asp:SqlDataSource ID="sas_user_search" runat="server" 

                            ConnectionString="<%$ ConnectionStrings:ocl_ddl %>" 

                            ProviderName="<%$ ConnectionStrings:ocl_ddl.ProviderName %>" 

                            SelectCommand="SELECT "USER_ID", "USER_NAME", "PASSWORD", "EMAIL", "CLOSED", "STATUS" FROM "CUS_MIS_USER" WHERE ("USER_ID" = :USER_ID)" 

                            DeleteCommand="DELETE FROM "CUS_MIS_USER" WHERE "USER_ID" = :USER_ID" 

                            InsertCommand="INSERT INTO "CUS_MIS_USER" ("USER_ID", "USER_NAME", "PASSWORD", "EMAIL", "CLOSED", "STATUS") VALUES (:USER_ID, :USER_NAME, :PASSWORD, :EMAIL, :CLOSED, :STATUS)" 

                            UpdateCommand="UPDATE "CUS_MIS_USER" SET "USER_NAME" = :USER_NAME, "PASSWORD" = :PASSWORD, "EMAIL" = :EMAIL, "CLOSED" = :CLOSED, "STATUS" = :STATUS WHERE "USER_ID" = :USER_ID">

                            <DeleteParameters>

                                <asp:Parameter Name="USER_ID" Type="String" />

                            </DeleteParameters>

                            <InsertParameters>

                                <asp:Parameter Name="USER_ID" Type="String" />

                                <asp:Parameter Name="USER_NAME" Type="String" />

                                <asp:Parameter Name="PASSWORD" Type="String" />

                                <asp:Parameter Name="EMAIL" Type="String" />

                                <asp:Parameter Name="CLOSED" Type="String" />

                                <asp:Parameter Name="STATUS" Type="String" />

                            </InsertParameters>

                            <SelectParameters>

                                <asp:ControlParameter ControlID="txb_search_id" Name="USER_ID" 

                                    PropertyName="Text" Type="String" DefaultValue="27021033" />

                            </SelectParameters>

                            <UpdateParameters>

                                <asp:Parameter Name="USER_NAME" Type="String" />

                                <asp:Parameter Name="PASSWORD" Type="String" />

                                <asp:Parameter Name="EMAIL" Type="String" />

                                <asp:Parameter Name="CLOSED" Type="String" />

                                <asp:Parameter Name="STATUS" Type="String" />

                                <asp:Parameter Name="USER_ID" Type="String" />

                            </UpdateParameters>

                        </asp:SqlDataSource>

后台代码是这样的：



        protected void row_edit(object sender, GridViewEditEventArgs e)

        {

            grid_user.EditIndex = e.NewEditIndex;

            //grid_user.UpdateRow(1, true);

            //dtb.Rows[1] = (DataTable))grid_user.Rows[1];

            grid_user.DataBind();

        }

        protected void row_update(object sender, GridViewUpdateEventArgs e)

        {

            grid_user.EditIndex = -1;

            //grid_user.UpdateRow(1, true);

            grid_user.DataBind();

        }

        protected void row_cancel(object sender, GridViewCancelEditEventArgs e)

        {

            grid_user.EditIndex = -1;

            //grid_user.UpdateRow(0, true);

            grid_user.DataBind();

        }

        

        protected void btn_user_search_Click(object sender, EventArgs e)

        {

            //DataSet ds = new DataSet();



            //DataView drv = (DataView)sas_user_search.Select(DataSourceSelectArguments.Empty);

            grid_user.DataSource = sas_user_search;

            grid_user.DataSourceID = string.Empty;

            //txb_user_id.Text = grid_user.DataSourceID;

            //dtb = drv.ToTable();

            //grid_user

            grid_user.DataBind();

        }