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.OleDbComm and
Dim da as oldb.oldbDataAd apter
Dim con as new Oldb.OledbConne ction

'Open a connection
constr=""Provid er=SQLOLEDB.1;P ersist Security Info=False;.... ............."
con.connections tring=constr
con.open constr

'Fill Dataset
sql="select * from........... .........."
da=new oledb.OledbData Adapter(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.OleDbComm and
Dim da as oldb.oldbDataAd apter
Dim con as new Oldb.OledbConne ction

'Open a connection
constr=""Provid er=SQLOLEDB.1;P ersist Security Info=False;.... ............."
con.connections tring=constr
con.open constr

'Fill Dataset
sql="select * from........... .........."
da=new oledb.OledbData Adapter(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