get by colom name

  • Thread starter Thread starter Sadun Sevingen
  • Start date Start date
S

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"
 
Hi,

Try:

DataSet.Tables[0].Rows[0]["NAME"]


Item is the indexer.

Cheers,
 
that worked thanks...


Ignacio Machin ( .NET/ C# MVP ) said:
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 said:
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"
Click to expand...
Click to expand...
 
Back
Top