DataSets (C#)

[Guest]

Hi,

I am using DataSets to populate some controls on my ASPX.

I retrieve some values using the Index in my DataSets.

For example dsTest.Tables[0].Rows[0].ItemArray[0] etc etc

How can I retrieve the value using the Column name /alias used in my SQL
rather than my Index.

Thanks,
Clive.

 

[Peter Rilling]

Just replace the index with the column name (i.e. ...Rows["SomeCol"]...).

 

[Mark Fitzpatrick]

Use:
dsTest.Tables[0].Rows[0]["columnname"]
or
dsTest.Tables[0].Rows[0].Item["columnname"]

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage

 

[Karl Seguin]

dsTest.Tables[0].Rows[0]["FirstName"]

Karl

 

[Peter Rilling]

Actaully, it should be something like ...Rows[0]["SomeCol"]...

Just replace the index with the column name (i.e. ...Rows["SomeCol"]...).

Hi,

I am using DataSets to populate some controls on my ASPX.

I retrieve some values using the Index in my DataSets.

For example dsTest.Tables[0].Rows[0].ItemArray[0] etc etc

How can I retrieve the value using the Column name /alias used in my SQL
rather than my Index.

Thanks,
Clive.

 

[Karl Seguin]

You still need the row index in there

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/ - New and Improved (yes, the popup is annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)

Just replace the index with the column name (i.e. ...Rows["SomeCol"]...).

Hi,

I am using DataSets to populate some controls on my ASPX.

I retrieve some values using the Index in my DataSets.

For example dsTest.Tables[0].Rows[0].ItemArray[0] etc etc

How can I retrieve the value using the Column name /alias used in my SQL
rather than my Index.

Thanks,
Clive.

 

[Cowboy \(Gregory A. Beamer\)]

dsTest.Tables[0].Rows[0]["ColumnName"]

--
Gregory A. Beamer
MVP; MCP: +I, SD, SE, DBA

*************************************************
Think outside the box!
*************************************************