How to get specific record from other table during runtime?

[Sanjay Pawar]

I have taken a suppliercode from the user in runtime, now I want to define a SQLdatasource and select a record from supplierInfo with the same code. After that I want to display that record in textbox of the same formview.
I was trying below code, but does not work. Pls help!

Dim rstSupplier As New SqlDataSource
rstSupplier.SelectCommand = "Select * from SupplierInfo where SupplierCode '" & lblSupplierCode.Text & "'"
rstSupplier.DataBind()
 
txtAddressLine1.Text = rstSupplier.SelectParameters("AddressLine1").DefaultValue
txtAddressLine2.Text = rstSupplier.SelectParameters("AddressLine2").DefaultValue

and so on ...........


Pls help, or give some idea to do it runtime.
Thanks in advance

Sanjay

[Liamsacc]

the following will answer these queries
http://forums.asp.net/t/899575.aspx/1
I spent a long time looking to populate labels from SQLDatasource only to be led all over the place to resolve it.
Finally a Microsoft team member posted the answer, If you are using Datasource, you have to use the built in tools for it i.e Details view and trim it down