David Emerson
newsgrps at dalyn.co.nz
Wed Jun 6 20:58:35 CDT 2007
Group,
I am trying to learn how to retrieve data in VB.Net from a couple of
fields from an SQL database. Here is the code I have so far. It is
a combination of several different sources and playing with the auto
completion feature of VB.Net. I think :
Dim conn As New SqlConnection
conn.ConnectionString = "data source=DALYN;initial
catalog=MLV;integrated security=SSPI;persist security info=False"
Dim Cmd = New SqlClient.SqlCommand("SELECT ReportName,
ParType from tblReports where ReportID = @ReportID", conn)
Cmd.CommandType = CommandType.Text
Cmd.Parameters.Add("@ReportID", intReport)
conn.Open()
Where do I go from here? I would like to put the values of
ReportName, and ParType into variables strReportName and intParType
Regards
David Emerson
Dalyn Software Ltd
Wellington, New Zealand