Tally Rows in a DataSet that Match a Condition

Tally Rows in a DataSet that Match a Condition | ASP NET Hosting

Tally Rows in a DataSet that Match a Condition | ASP NET Hosting — Tue, 28 Apr 2009 05:43:54 GMT

PingBack from http://asp-net-hosting.simplynetdev.com/tally-rows-in-a-dataset-that-match-a-condition/

re: Tally Rows in a DataSet that Match a Condition

Jimmy Ye Htut — Tue, 28 Apr 2009 06:29:09 GMT

Hi,

I have a question. How do you get these snippet? Are those your own?

re: Tally Rows in a DataSet that Match a Condition

Beth Massi — Tue, 28 Apr 2009 19:37:05 GMT

Hi Jimmy,

Snippets are included in VS2005 and VS2008. I'm showing the VS2008 version. You can also edit and create your own snippets with the Code Snippet Editor: http://msdn.microsoft.com/en-us/vbasic/bb973770.aspx

HTH,

-B

re: Tally Rows in a DataSet that Match a Condition

EL — Fri, 29 May 2009 07:42:48 GMT

Hai, Beth.

I Have a question. How is the code if I don't use typed dataset? In other words, I don't use drag and drop, since I have difficulty if there is a problem rising with typed dataset.

I know You always use drag and drop in creating and manipulating database application in article or video. However, perhaps you may use purely code in stating the current row with bindindsource.

Thanks in advanced.

re: Tally Rows in a DataSet that Match a Condition

EL — Fri, 29 May 2009 07:46:15 GMT

Hai, Beth.

I Have a question. How is the code if I don't use typed dataset? In other words, I don't use drag and drop, since I have difficulty if there is a problem rising with typed dataset.

I know You always use drag and drop in creating and manipulating database application in article or video. However, perhaps you may use purely code in stating the current row with bindindsource.

Thanks in advanced.

re: Tally Rows in a DataSet that Match a Condition

Beth Massi — Tue, 02 Jun 2009 18:50:33 GMT

Hi El,

You still can grab the position from the BindingSource if you are binding to an untyped DataSet/DataTable as well. You just have to deal with converting the values in the rows because you don't have a schema. If your UI is purely dynamic you can end up in this situation, but if you have known properties it's much easier to work with typed datasets and objects. Designer support for data-binding is just one benefit.

Dim dt As New DataTable

' create columns and fill rows ...

Me.BindingSource1.DataSource = dt

'....

Private Sub BindingSource1_PositionChanged() Handles BindingSource1.PositionChanged

'Get the current row

Dim row As DataRow

row = CType(CType(Me.BindingSource1.Current, DataRowView).Row, DataRow)

MsgBox(row("Column1").ToString())

End Sub

HTH,

-B

re: Tally Rows in a DataSet that Match a Condition

Joe — Tue, 02 Jun 2009 22:47:52 GMT

Hi beth

I want to be able to use linq to get a certain recordset from an xml file and then put those results into a datagridview. my code looks like this

Dim myPlayer = XDocument.Load(strPath & "\08Stats.xml")

Dim xmlPlayer = <Player>

<%= From Player In myPlayer...<row> _

Where Player.<PlID>.Value = intPlayerID _

Select Player %>

</Player>

Me.dgvPlayerStats.DataSource = xmlPlayer

Me.dgvPlayerStats.DataBind()

obviously this doesnt work. I want to be able to query an xml doc and put the results of that query in a datagridview.

Thanks for your time.

Joe

re: Tally Rows in a DataSet that Match a Condition

Beth Massi — Wed, 03 Jun 2009 02:58:15 GMT

Hi Joe,

Try creating a list of objects from your query instead. You're creating an XElement here and you can't bind this control to that. Try something like this:

Dim resultPlayers = _

From Player In myPlayer...<row> _

Where Player.<PlID>.Value = intPlayerID _

Select Player.<PID>.Value, _

Player.<Property1>.Value, ...rest of columns

Me.dgvPlayerStats.DataSOurce = resultPlayers.ToList()

HTH,

-B