select stmt

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In asp.net ,in command button script ,
How can i select and assign a value into a variable from a table.like
select ref into @var1 from table1 where id='1';
 
Shif,

The way your qeustion is made, gives often many misunderstandings, what kind
of table do you mean?

In the way you show it is it a DataBase table and by intance not a
datatable.

Cor
 
HI
Its a database table,
Dim comd As New SqlCommand()
comd.CommandText = "select barcode,ref from prod where supp_ref='" &
refBox.Text & "'"
this is an example which i am getting datainto a datatable and here records
are more,its working fine. now i want to get barcode,ref from the same table
and want to assign the values to two variables and only one record will fetch
at a time.
 
Back
Top