regarding datasets

[Supreet]

Hi..i am new to this forum..i have a doubt regarding datasets..

i have a query say..

str=select name from student where rollno=1
and i have populated the result of this query into a dataset by
sqladapter.fill(ds) //where ds is the dataset..

if rollno is a primary key thn there will be only one name corresp to it..

can i read that name into a string variable..
can i read the value from the dataset into a variable and how??

is there a fn?? any recommended link will also be useful..

[jharikrishna]

Ok,Frnd

first to store a query in string variable
after then
to read that string into sqldataadapter witn conn string
bind that dataset into any datagrid controls.

[chitra raman]

Hi..i am new to this forum..i have a doubt regarding datasets..

i have a query say..

str=select name from student where rollno=1
and i have populated the result of this query into a dataset by
sqladapter.fill(ds) //where ds is the dataset..

if rollno is a primary key thn there will be only one name corresp to it..

can i read that name into a string variable..
can i read the value from the dataset into a variable and how??

is there a fn?? any recommended link will also be useful..

hi Supreet

i hope my answer would benefit u

dim strName as string
strName = ds.Tables(0).Rows(0).Item("name")

[nmsreddi]

hi

i didnt get ur problem correctly but u can read data from dataset in to any format depending on the requirement .to which control actually u r going to bind the data .

[kalyanchelluri]

Buddy..i didnt get ur Qn tht perfectly ,but if inserting the name corresponding tht rollno=1 is wat u wanted..just try da below code..might help..


Dim ds as new dataset
Dim da as new sql dataadapter("select name from tablename where rollno="textbox1.text"",sqlcon) // here i assumed tht 'textbox1' is ur control where ur gng to enter a rollno.//
da.fill(ds,"tablename")
str=ds.tables("tablename").rows(row position).item(column position)
msgbox(str)



Result: in msgbx u'll get da name corresponding to the rollno.

bro..if this is not wat u wanted then just lemme know..