Completely stumped on getting a value from a datag

andyVW · Apr 28, 2012

I tried this message on another forum to no avail. I see there are more messages here--I hope someone can help. I would have thought it would be simple to read values from cells on datagrids but I guess not. I got some things to try on another forum but nothing worked, someone please tell me there's a way to read from cells on datagrids from any sub. I want to access values when I'm in the OnSelectedIndexChanged sub which doesn't support datagrid item event args but there must be way to access cell values from datagrids anyway is there? I've read through tons of sample ASP.NET code and cannot find a sample where it's done when without using Datatables and Datarows. In my sample below I have a sub where I would like to accecs the value of the "master_id" in the daMaster datagrid and have a sample of code that doestn't work but you should be able to tell from it what I'm attempting to accomplish. The grids are displaying fine on the form and I know there must be a way I can access the values from the cells. Dim myDataSet As New DataSet Dim daMaster As SQLDataAdapter Dim daDetail As SQLDataAdapter Dim conSQL As String conSQL ="server=local;database=myDatabase;uid=sa" daMaster = New SQLDataAdapter("Select * From master", conSQL) daMaster.fill(dsChambers, "chamber_area") dgMaster.DataSource = myDataSet.Tables("master") daDetail = New SQLDataAdapter("Select * From detail", conSQL) daDetail.fill(myDataSet, "detail") dgDetail.DataSource = myDataSet.Tables("detail") dgMaster.DataBind() dgDetail.DataBind() Sub Master_Index_Change(Source As Object,E AS EventArgs) 'This doesn't work but it is what I would like to be able to do myID = dgMaster.Tables("master").Row(SelectedRow).Column("master_id").Text() End SubThere's an example of how to do this at: ms-help://MS.VSCC/MS.MSDNVS/cpref/html/frlrfsystemwebuiwebcontrolsdatagridclassoneditcomm andtopic.htm (assuming you have the help docs installed locally). The code is as follows, with the important parts highlighted: <%@ Import Namespace="System.Data" %> <html> <script language="VB" runat="server"> Dim Cart As New DataTable() Dim CartView As DataView Sub Page_Load(sender As Object, e As EventArgs) Dim dr As DataRow If Session("ShoppingCart") Is Nothing Then Cart.Columns.Add(New DataColumn("Qty", GetType(String))) Cart.Columns.Add(New DataColumn("Item", GetType(String))) Cart.Columns.Add(New DataColumn("Price", GetType(String))) Session("ShoppingCart") = Cart ' Create some rows and insert some sample data. Dim i As Integer For i = 1 To 4 dr = Cart.NewRow() If i Mod 2 <> 0 Then dr(0) = "2" Else dr(0) = "1" End If dr(1) = "Item " + i.ToString() dr(2) =(1.23 *(i + 1)).ToString() Cart.Rows.Add(dr) Next i Else Cart = CType(Session("ShoppingCart"), DataTable) End If CartView = New DataView(Cart) CartView.Sort = "Item" If Not IsPostBack Then BindGrid() End If End Sub 'Page_Load Sub MyDataGrid_Edit(sender As Object, e As DataGridCommandEventArgs) MyDataGrid.EditItemIndex = e.Item.ItemIndex BindGrid() End Sub 'MyDataGrid_Edit Sub MyDataGrid_Cancel(sender As Object, e As DataGridCommandEventArgs) MyDataGrid.EditItemIndex = - 1 BindGrid() End Sub 'MyDataGrid_Cancel Sub MyDataGrid_Update(sender As Object, e As DataGridCommandEventArgs) ' For bound columns, the edited value is stored in a TextBox. ' The TextBox is the 0th element in the column's cell. Dim qtyText As TextBox = CType(e.Item.Cells(2).Controls(0), TextBox) Dim priceText As TextBox = CType(e.Item.Cells(3).Controls(0), TextBox) Dim item As String = e.Item.Cells(1).Text Dim qty As String = qtyText.Text Dim price As String = priceText.Text Dim dr As DataRow ' With a database, use an update command to update the data. Because ' the data source in this example is an in-memory DataTable, delete the ' old row and replace it with a new one. ' Remove old entry. CartView.RowFilter = "Item='" & item & "'" If CartView.Count > 0 Then CartView.Delete(0) End If CartView.RowFilter = "" ' Add new entry. dr = Cart.NewRow() dr(0) = qty dr(1) = item dr(2) = price Cart.Rows.Add(dr) MyDataGrid.EditItemIndex = - 1 BindGrid() End Sub 'MyDataGrid_Update Sub BindGrid() MyDataGrid.DataSource = CartView MyDataGrid.DataBind() End Sub 'BindGrid </script> <body> <form runat="server"> <h3>DataGrid Editing Example</h3> <asp

ataGrid id="MyDataGrid" runat="server" BorderColor="black" BorderWidth="1" CellPadding="3" Font-Name="Verdana" Font-Size="8pt" OnEditCommand="MyDataGrid_Edit" OnCancelCommand="MyDataGrid_Cancel" OnUpdateCommand="MyDataGrid_Update" AutoGenerateColumns="false"> <HeaderStyle BackColor="#aaaadd"> </HeaderStyle> <Columns> <asp:EditCommandColumn EditText="Edit" CancelText="Cancel" UpdateText="Update" HeaderText="Edit Command Column"> <ItemStyle Wrap="false"> </ItemStyle> <HeaderStyle Wrap="false"> </HeaderStyle> </asp:EditCommandColumn> <asp:BoundColumn HeaderText="Item" ReadOnly="true" DataField="Item"/> <asp:BoundColumn HeaderText="Quantity" DataField="Qty"/> <asp:BoundColumn HeaderText="Price" DataField="Price"/> </Columns> </asp

ataGrid> </form> </body> </html>The example I'm replying to shows how to get the column values for a particular DataGrid control row when the row is selected via the EditIndex property and the user has selected to Update the changes. If you just have a regular DataGrid, you can interrogate the DataGrid's Items property and do the same thing, essentially. See: ms-help://MS.VSCC/MS.MSDNVS/cpref/html/frlrfsystemwebuiwebcontrolsdatagridclassitemstopic .htm Sub Button_Click(sender As Object, e As EventArgs) Dim item As DataGridItem For Each item In ItemsGrid.Items Label1.Text &= " " & item.Cells(0).Text & _ " " & item.Cells(1).Text & _ " " & item.Cells(2).Text Next item End Sub 'Button_Click The Cells is a zero-indexed collection of the columns in a DataGrid's row. hthThanks for responding Scott though that was not quite what I was looking for either but it was close. I finally found what I was looking for on MSDN though. It's is as simple as this to access cell values from a Sub that doesn't have the Item passed in : MyDataGrid.SelectedItem.Cells(1).Text

Completely stumped on getting a value from a datag

andyVW

New Member