Dataset help

[Shanaj]

Please help me how to retrieve data from dataset to a textbox

[shweta123]

Hi,

Dim constr as string
Dim ds as new dataset
Dim comm as oledb.OleDbCommand
Dim da as oldb.oldbDataAdapter
Dim con as new Oldb.OledbConnection

'Open a connection
constr=""Provider=SQLOLEDB.1;Persist Security Info=False;................."
con.connectionstring=constr
con.open constr

'Fill Dataset
sql="select * from....................."
da=new oledb.OledbDataAdapter(sql,con)
da.Fill(ds)

'Open dataset
'e.g first row first column
Textbox.text=ds.Tables(0).Rows(0).Item(0)

Hope this helps
Shweta

[Shanaj]

Hi,

Dim constr as string
Dim ds as new dataset
Dim comm as oledb.OleDbCommand
Dim da as oldb.oldbDataAdapter
Dim con as new Oldb.OledbConnection

'Open a connection
constr=""Provider=SQLOLEDB.1;Persist Security Info=False;................."
con.connectionstring=constr
con.open constr

'Fill Dataset
sql="select * from....................."
da=new oledb.OledbDataAdapter(sql,con)
da.Fill(ds)

'Open dataset
'e.g first row first column
Textbox.text=ds.Tables(0).Rows(0).Item(0)

Hope this helps
Shweta

Thanks for Replay