ASP.NET

ASP.NET RSS

help with datagrid

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: Nov 2009

Posts: 9

Reputation: smd5049 is an unknown quantity at this point

Solved Threads: 0

smd5049

Offline

Newbie Poster

help with datagrid

20 Days Ago

I have a datagrid bound to a sql proc. I have made the last column in the datagrid into text boxes so the items are editable. how do i return the values from these cells? Basically I want to be able to sum the entire column, as well as set the values in each item of the column to 0 upon a button_click. I'm very new to vb.net and if I'm not explaining this correctly please let me know.

the datagrid is built through this funtion:

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
             Dim strConnString As String
            Dim strSQLText As String
            strConnString = ConfigurationManager.ConnectionStrings("SDWConnectionString").ToString
            strSQLText = "SELECT TN_CN_S_Desc, Item, Pack, Location, Lot, Label_Nb from sdw.sdw_user.SAR_DTD_840_copy where Pick_Num = '" & Picklist & "'"
 
            Dim SqlCOnnection As New SqlConnection(strConnString)
            SqlCOnnection.Open()
 
            Dim sqlCmd As New SqlCommand(strSQLText, SqlCOnnection)
 
                     Dim adapter As New SqlClient.SqlDataAdapter(strSQLText, SqlCOnnection)
 
            Dim ds As New DataSet
 
            adapter.Fill(ds, "sdw.sdw_user.SAR_DTD_840_copy")
            Dim dataTable = ds.Tables("sdw.sdw_user.SAR_DTD_840_copy")
 
            Me.DataGrid1.DataSource = dataTable
            Me.DataGrid1.AutoGenerateColumns = False
            Me.DataGrid1.DataBind()
             Dim strConnString As String
            Dim strSQLText As String
            strConnString = ConfigurationManager.ConnectionStrings("SDWConnectionString").ToString
            strSQLText = "SELECT TN_CN_S_Desc, Item, Pack, Location, Lot, Label_Nb from sdw.sdw_user.SAR_DTD_840_copy where Pick_Num = '" & Picklist & "'"

            Dim SqlCOnnection As New SqlConnection(strConnString)
            SqlCOnnection.Open()

            Dim sqlCmd As New SqlCommand(strSQLText, SqlCOnnection)

                     Dim adapter As New SqlClient.SqlDataAdapter(strSQLText, SqlCOnnection)

            Dim ds As New DataSet
         
            adapter.Fill(ds, "sdw.sdw_user.SAR_DTD_840_copy")
            Dim dataTable = ds.Tables("sdw.sdw_user.SAR_DTD_840_copy")

            Me.DataGrid1.DataSource = dataTable
            Me.DataGrid1.AutoGenerateColumns = False
            Me.DataGrid1.DataBind()

the html for the column that I made editable and want to sum/set to zero looks like this:

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
<asp:TemplateColumn HeaderText="# Labels">
                                        <EditItemTemplate>
                                            <asp:TextBox ID="txtlbls" runat="server" Style="text-align: right" Text='<%# DataBinder.Eval(Container.DataItem,"Label_Nb") %>'
                                                    Width="65"></asp:TextBox>
                                        </EditItemTemplate>
                                        <ItemTemplate>
                                            <asp:TextBox ID="txtlbls" runat="server" Style="text-align: right" Text='<%# DataBinder.Eval(Container.DataItem,"Label_Nb") %>'
                                                    Width="65"></asp:TextBox>
                                        </ItemTemplate>
                                    </asp:TemplateColumn>
<asp:TemplateColumn HeaderText="# Labels">
                                        <EditItemTemplate>
                                            <asp:TextBox ID="txtlbls" runat="server" Style="text-align: right" Text='<%# DataBinder.Eval(Container.DataItem,"Label_Nb") %>'
                                                    Width="65"></asp:TextBox>
                                        </EditItemTemplate>
                                        <ItemTemplate>
                                            <asp:TextBox ID="txtlbls" runat="server" Style="text-align: right" Text='<%# DataBinder.Eval(Container.DataItem,"Label_Nb") %>'
                                                    Width="65"></asp:TextBox>
                                        </ItemTemplate>
                                    </asp:TemplateColumn>