Ad:

ASP.NET Discussion Thread
Unsolved
Views: 860

Nov 6th, 2009

datagrid return value - please help

Expand Post »

will someone please help me with this. It seems simple enough but I'm very new to asp and vb. I have a datagrid and I want to know how to access the values in a specific column. The dg is bound to a sql query. The column returns integer values in sql. I want to be able to sum the column and have a button_click command send the datagrid values to 0. I only want to change the datagrid values NOT the sql values (I currently have an Update/Set sql command in vb for this but as I said I only want the Datagrid values to change). Simply put where, if anywhere are the datagrid values stored? I have the column set as a template column and the items are displayed in the datagrid as textboxes (to allow the cells in this column to be changed). can someone please help or at least tell me if this question makes any sense. thank you

Similar Threads

Same Content Multiple Pages with User Control, tabControl, Gridview? in C#
Help needed... (Search thru datagrid) in Visual Basic 4 / 5 / 6
Event from date in DataGrid in VB.NET
asp.net help needed URGENT in ASP.NET
datagrid delete function not auto update in ASP.NET

smd5049

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

10 posts
since Nov 2009

Permalink

Nov 7th, 2009

Re: datagrid return value - please help

Show us your code work please. You will find some useful information from this MSDN page - http://msdn.microsoft.com/en-us/library/aa479339.aspx

adatapost

Moderator

Reputation Points: 2136

Solved Threads: 1228

Posting Genius

Offline

6,527 posts
since Oct 2008

Permalink

Nov 9th, 2009

Re: datagrid return value - please help

You can access a perticular colum in dataset by
ds.Tables[0].Rows[0]["Columnname"].ToString()

You can access a particular column of gridview in its Rowdatabound event

Hope one of it may help u

Click to Expand / Collapse Quote originally posted by smd5049 ...

will someone please help me with this. It seems simple enough but I'm very new to asp and vb. I have a datagrid and I want to know how to access the values in a specific column. The dg is bound to a sql query. The column returns integer values in sql. I want to be able to sum the column and have a button_click command send the datagrid values to 0. I only want to change the datagrid values NOT the sql values (I currently have an Update/Set sql command in vb for this but as I said I only want the Datagrid values to change). Simply put where, if anywhere are the datagrid values stored? I have the column set as a template column and the items are displayed in the datagrid as textboxes (to allow the cells in this column to be changed). can someone please help or at least tell me if this question makes any sense. thank you

Sals

Reputation Points: 10

Solved Threads: 6

Light Poster

Offline

33 posts
since Jan 2009

Permalink

Nov 9th, 2009

Re: datagrid return value - please help

I am able to return all the values of the datagrid except the last column (item.cells(6).text). The vb looks like this

ASP.NET Syntax (Toggle Plain Text)
 For Each item In DataGrid1.Items
            Label1.Text &= "<br />" & item.Cells(0).Text & _
                        " " & item.Cells(1).Text & _
                        " " & item.Cells(2).Text & _
                        " " & item.Cells(3).Text & _
                        " " & item.Cells(4).Text & _
                        " " & item.Cells(5).Text & _
                        " " & item.Cells(6).Text
 
        Next item
 For Each item In DataGrid1.Items
            Label1.Text &= "<br />" & item.Cells(0).Text & _
                        " " & item.Cells(1).Text & _
                        " " & item.Cells(2).Text & _
                        " " & item.Cells(3).Text & _
                        " " & item.Cells(4).Text & _
                        " " & item.Cells(5).Text & _
                        " " & item.Cells(6).Text

        Next item

The difference with this column in the asp is that the values returned from the sql query are placed into editable text boxes. the asp for the datagrid is here

ASP.NET Syntax (Toggle Plain Text)
                            <asp:DataGrid ID="DataGrid1" runat="server" AutoGenerateColumns="False" BackColor="White"
                                    BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="4" ForeColor="Black" GridLines="Horizontal">
                                <SelectedItemStyle BackColor="#CC3333" Font-Bold="True" ForeColor="White" />
                                <HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left" />
                                <FooterStyle BackColor="#CCCC99" ForeColor="Black" />
                                <Columns>
                                    <asp:BoundColumn DataField="Order_Line" HeaderText="Line"></asp:BoundColumn>
                                    <asp:BoundColumn DataField="TN_CN_S_Desc" HeaderText="Description">
                                        <ItemStyle HorizontalAlign="Left" />
                                    </asp:BoundColumn>
                                    <asp:BoundColumn DataField="Item" HeaderText="Item"></asp:BoundColumn>
                                    <asp:BoundColumn DataField="Pack" HeaderText="Pack"></asp:BoundColumn>
                                    <asp:BoundColumn DataField="Location" HeaderText="Location"></asp:BoundColumn>
                                    <asp:BoundColumn DataField="Lot" HeaderText="Lot"></asp:BoundColumn>
                                    <asp:TemplateColumn HeaderText="# Labels">
 
                                        <ItemTemplate>
                                            <asp:TextBox runat="server" Style="text-align: right" Text='<%# DataBinder.Eval(Container.DataItem,"Label_Nb") %>'
                                                    Width="65"></asp:TextBox>
                                        </ItemTemplate>
                                        <HeaderStyle Font-Bold="True" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                                            Font-Underline="False" HorizontalAlign="Right" />
                                        <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                                            Font-Underline="False" HorizontalAlign="Right" />
                                    </asp:TemplateColumn>
 
                                </Columns>
                                <PagerStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                                    Font-Underline="False" HorizontalAlign="Left" />
                            </asp:DataGrid>
                            <asp:DataGrid ID="DataGrid1" runat="server" AutoGenerateColumns="False" BackColor="White"
                                    BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="4" ForeColor="Black" GridLines="Horizontal">
                                <SelectedItemStyle BackColor="#CC3333" Font-Bold="True" ForeColor="White" />
                                <HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left" />
                                <FooterStyle BackColor="#CCCC99" ForeColor="Black" />
                                <Columns>
                                    <asp:BoundColumn DataField="Order_Line" HeaderText="Line"></asp:BoundColumn>
                                    <asp:BoundColumn DataField="TN_CN_S_Desc" HeaderText="Description">
                                        <ItemStyle HorizontalAlign="Left" />
                                    </asp:BoundColumn>
                                    <asp:BoundColumn DataField="Item" HeaderText="Item"></asp:BoundColumn>
                                    <asp:BoundColumn DataField="Pack" HeaderText="Pack"></asp:BoundColumn>
                                    <asp:BoundColumn DataField="Location" HeaderText="Location"></asp:BoundColumn>
                                    <asp:BoundColumn DataField="Lot" HeaderText="Lot"></asp:BoundColumn>
                                    <asp:TemplateColumn HeaderText="# Labels">

                                        <ItemTemplate>
                                            <asp:TextBox runat="server" Style="text-align: right" Text='<%# DataBinder.Eval(Container.DataItem,"Label_Nb") %>'
                                                    Width="65"></asp:TextBox>
                                        </ItemTemplate>
                                        <HeaderStyle Font-Bold="True" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                                            Font-Underline="False" HorizontalAlign="Right" />
                                        <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                                            Font-Underline="False" HorizontalAlign="Right" />
                                    </asp:TemplateColumn>
                                    
                                </Columns>
                                <PagerStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                                    Font-Underline="False" HorizontalAlign="Left" />
                            </asp:DataGrid>

how am i to display the values from this template column?

smd5049

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

10 posts
since Nov 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP.NET Forum Timeline: Web form like window classic form

Next Thread in ASP.NET Forum Timeline: Editing Registry Keys

DaniWeb Message

Cancel Changes

User Name
Password