get by colom name

[Sadun Sevingen]

hi;

i fill my dataset from sql server by adaptor automatically...

i want to retrive any element in my data row by colom name...

let say i have a datatable like

ID NAME SURNAME
1 sadun sevingen
2 cem sevingen

this code is not valid but lets say i want to take first row.. then i want
to do it like someting below...

DataSet.Tables[0].Rows[0].Item["NAME"] // which is "sadun"

[Sijin Joseph]

What is wrong with the line of code you have written. Look OK to me.

Sijin Joseph
http://www.indiangeek.net
http://weblogs.asp.net/sjoseph
Sadun Sevingen wrote:

hi;

i fill my dataset from sql server by adaptor automatically...

i want to retrive any element in my data row by colom name...

let say i have a datatable like

ID NAME SURNAME
1 sadun sevingen
2 cem sevingen

this code is not valid but lets say i want to take first row.. then i want
to do it like someting below...

DataSet.Tables[0].Rows[0].Item["NAME"] // which is "sadun"

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

Try:

DataSet.Tables[0].Rows[0]["NAME"]
Item is the indexer.

Cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Sadun Sevingen" <b-saduns@ms> wrote in message
news:eU*************@TK2MSFTNGP12.phx.gbl...

hi;

i fill my dataset from sql server by adaptor automatically...

i want to retrive any element in my data row by colom name...

let say i have a datatable like

ID NAME SURNAME
1 sadun sevingen
2 cem sevingen

this code is not valid but lets say i want to take first row.. then i want
to do it like someting below...

DataSet.Tables[0].Rows[0].Item["NAME"] // which is "sadun"

[Sadun Sevingen]

that worked thanks...
"Ignacio Machin ( .NET/ C# MVP )" <ignacio.machin AT dot.state.fl.us> wrote
in message news:%2****************@TK2MSFTNGP10.phx.gbl...

Hi,

Try:

DataSet.Tables[0].Rows[0]["NAME"]
Item is the indexer.

Cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Sadun Sevingen" <b-saduns@ms> wrote in message
news:eU*************@TK2MSFTNGP12.phx.gbl...

hi;

i fill my dataset from sql server by adaptor automatically...

i want to retrive any element in my data row by colom name...

let say i have a datatable like

ID NAME SURNAME
1 sadun sevingen
2 cem sevingen

this code is not valid but lets say i want to take first row.. then i
want
to do it like someting below...

DataSet.Tables[0].Rows[0].Item["NAME"] // which is "sadun"