DataSets (C#)

[C]

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"]...).

"C" <[e-mail]> wrote in message
news:9A**********************************@microsof t.com...

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.

[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

"C" <[e-mail]> wrote in message
news:9A**********************************@microsof t.com...

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]

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

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!)
"C" <[e-mail]> wrote in message
news:9A**********************************@microsof t.com...

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!)
"Peter Rilling" <pe***@nospam.rilling.net> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

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

"C" <[e-mail]> wrote in message
news:9A**********************************@microsof t.com...

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]

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

"Peter Rilling" <pe***@nospam.rilling.net> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

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

"C" <[e-mail]> wrote in message
news:9A**********************************@microsof t.com...

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!
*************************************************
"C" <[e-mail]> wrote in message
news:9A**********************************@microsof t.com...

Hi,

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

I retrieve some values using the Index in my DataSets.

For example etc etc

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

Thanks,
Clive.