Tengo un codigo Mas simple
Cita: Sub Button1_Click(sender As Object, e As EventArgs)
Dim DS As DataSet
Dim MyConnection As SqlConnection
Dim MyCommand As SqlDataAdapter
MyConnection = New SqlConnection("server=(local);database=Compras;Tru sted_Connection=yes")
MyCommand = New SqlDataAdapter("select * from compra", myConnection)
DS = new DataSet()
MyCommand.Fill(DS, "compra")
Dim myTable As DataTable = DS.Tables("compra")
TextBox1.Text = DS.Tables[0].Rows[0][0].ToString();
End Sub
Value of type 'System.Data.DataTableCollection' cannot be converted to 'String'.
Ese Resultado me arroja.