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("se lect name from tablename where rollno="textbox 1.text"",sqlcon ) // here i assumed tht 'textbox1' is ur control where ur gng to enter a rollno.//
da.fill(ds,"tab lename")
str=ds.tables(" tablename").row s(row...

Guys..Can any1 tell me how 2 insert a Hyper-Link inside a Datagrid ??

for example i hav a approver table with fields approver name,approverid .So here after the approver id field i need 2 insert a hyperlink in the preceeding column so whenever i click on the Hyper-link the fields tht are in the same row of the Hyper-link will be displayed in my front-end...How do i the whole of the thing??

Thnx.
Kalyan.