Hi guys!
Get accurate multiple tables and attributes to the dataset datable one at a time?
Dim con As New OleDbConnection("Minha conexão".ToString)
Dim SQL As String
SQL = "Select Name, Prc, Qtd, Foto1 From table1 Where Cod=" + Request.QueryString("Cod").ToString()
Try
con.Open()
Dim cmd As OleDbCommand = New OleDbCommand(SQL, con)
Dim dr As OleDbDataReader = cmd.ExecuteReader()
dr.Read()
Dim dt As DataTable = GetDataSet().Tables(0)
Dim row As DataRow = dt.Rows.Find(Request.QueryString("Cod"))
If row Is Nothing Then
row = dt.NewRow()
row("Cod") = Request.QueryString("Cod")
row("Name") = dr("Name")
row("Qtd") = quant
...
Go to the complete details ...