Newbie SQL query question

[Jim Campau]

What do I put at the arrow to get the results of my query / (Command)?

What am I doing wrong?

Thanks in advance



Public Sub btnRun_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btnRun.Click

ChangeOverDataSet1.Clear()

OdbcDataAdapter1.Fill(ChangeOverDataSet1)

Dim Connection As Odbc.OdbcConnection = New Odbc.OdbcConnection

Dim Command As Odbc.OdbcCommand = New Odbc.OdbcCommand("SELECT" &
ChangeOverDataSet1.tblPkgDT_rev2.Rows.Count & " FROM tblPkgDT_rev2 WHERE
[Code Number] = 2", OdbcConnection1)

----> txtResult.Text = Command.ToString

End Sub

 

[Armin Zingler]

What do I put at the arrow to get the results of my query /
(Command)?

What am I doing wrong?

Thanks in advance



Public Sub btnRun_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btnRun.Click

ChangeOverDataSet1.Clear()

OdbcDataAdapter1.Fill(ChangeOverDataSet1)

Dim Connection As Odbc.OdbcConnection = New Odbc.OdbcConnection

Dim Command As Odbc.OdbcCommand = New Odbc.OdbcCommand("SELECT" &
ChangeOverDataSet1.tblPkgDT_rev2.Rows.Count & " FROM tblPkgDT_rev2
WHERE [Code Number] = 2", OdbcConnection1)

----> txtResult.Text = Command.ToString

End Sub

http://msdn.microsoft.com/library/en-us/cpguide/html/cpconadonetcommands.asp

http://msdn.microsoft.com/library/en-us/cpguide/html/cpcontheadonetdatareader.asp

(same available via <F1>)


BTW, there's an ADO.Net group for language unrelated questions:
microsoft.public.dotnet.framework.adonet


Armin