English 中文(简体)
vb.net datagridview with dataset as datasource
原标题:vb.net datagridview with dataset as datasource

我的问题是,是否有办法对数据集的记录进行过滤,并利用这些记录填写数据网格。 例如,一份数据表(有3栏:,StudentName,>Gender)填满了学生名单。 i 有两个数据网,其形式为:DatagridView1Datagridview2。 F 。

在我目前的解决方案中,我正在使用一种 lo。

For each iStud as datarow in iDataset.Tables(0).Rows
      IF iStud.Item("Gender").ToString = "M" Then
             add this record to DatagridView1
      Else
             add this record to DatagridView2
      End If
Next

是否有办法不使用 lo?

最佳回答

是的。 你们都需要做的是使用<代码>SlectT过滤数据。

例如,

DatagridView1.Datasource = xSet.Tables("StudentList").SELECT("Gender =  M ")
DatagridView2.Datasource = xSet.Tables("StudentList").SELECT("Gender =  F ")

简要解释:

xSet          is the name of the Dataset
StudentList   is the name of the Datatable
Gender        is the name of the Column where you want to filter

<>>>>>

“Screen

问题回答

暂无回答




相关问题
Is Shared ReadOnly lazyloaded?

I was wondering when I write Shared ReadOnly Variable As DataType = New DataType() Or alternatively Shared ReadOnly Variable As New DataType() Is it lazy loaded or as the instance initializes? ...

Entertaining a baby with VB.NET

I would like to write a little application in VB.NET that will detect a baby s cry. How would I get started with such an application?

Choose Enter Rather than Pressing Ok button

I have many fields in the page and the last field is a dropdown with list of values. When I select an item in a dropdown and press Enter, it doesn t do the "Ok". Instead I have to manually click on Ok ...

ALT Key Shortcuts Hidden

I am using VS2008 and creating forms. By default, the underscore of the character in a textbox when using an ampersand is not shown when I run the application. ex. "&Goto Here" is not ...

Set Select command in code

On button Click I want to Set the Select command of a Gridview. I do this and then databind the grid but it doesn t work. What am i doing wrong? protected void bttnView_Click(object sender, ...

Hover tooltip on specific words in rich text box?

I m trying to create something like a tooltip suddenly hoovering over the mouse pointer when specific words in the richt text box is hovered over. How can this be done?

热门标签