manipulating SQL data using VB code but without binding to a datag

[Guest]

I am new to VB .NET: I can configure a SQL adapter and access data via the
datagrid. But how do you access and manipulate data if you do not require the
data to show up on a form. I simply want to audit a SQL table's data using
code to cycle through all records. The user doesn' t need to see the table
data.
Any help appreciated.

 

[Chris Calzaretta]

use can use a dataset to do updates.. or
you can use a regular update statement

 

[Guest]

I didn't explain myself well enough... sorry~ I guess what I am missing is
how to access the data without using a datagrid. Is a data reader the answer?
(I have only just started reading about those) or is there a dataset command
that allows me to access each field in a row from SQL?

 

[Bernie Yaeger]

Hi,

You can use code like this (where I open and loop through a dataset's
datatable):

Dim oconn As New SqlConnection("data source=d5z0071;initial
catalog=tennis;integrated security=sspi;")

Dim oda As New SqlDataAdapter("select * from league_t order by league",
oconn)

Dim ods As New DataSet()

oconn.Open()

oda.Fill(ods, "leagues")

Dim irow As DataRow

For Each irow In ods.Tables(0).Rows

messagebox.show(irow("league"))

Next

oconn.Close()

HTH,

Bernie Yaeger