Minds Drawn a blank

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

Guest

VS2005 ( vb.net ) & Sql 2005

my minds drawn a blank ..
how can i read the data in field 1 ?

Dim SelectCommand As String = "SELECT * FROM [ClientAdmin] ORDER BY
[Licence]"
Dim Sql_DataAdapter As SqlDataAdapter = New
SqlDataAdapter(SelectCommand, SQL_Conn)
Sql_DataAdapter.Fill(objDataSet, "ClientAdmin")




Sql_DataAdapter.Dispose()
SQL_Conn.Close()
 
Peter Newman said:
VS2005 ( vb.net ) & Sql 2005

my minds drawn a blank ..
how can i read the data in field 1 ?

Dim SelectCommand As String = "SELECT * FROM [ClientAdmin] ORDER BY
[Licence]"
Dim Sql_DataAdapter As SqlDataAdapter = New
SqlDataAdapter(SelectCommand, SQL_Conn)
Sql_DataAdapter.Fill(objDataSet, "ClientAdmin")




Sql_DataAdapter.Dispose()
SQL_Conn.Close()
Click to expand...
As you have your data in a DataTable within a DataSet, you may be looking
for this:

http://msdn2.microsoft.com/en-us/library/system.data.datacolumn.aspx
 
Back
Top