Jun 16, 2008 06:41 AM|cornishcat|LINK
OK, let's suppose I wasn't using MS Access but SQL instead (I can use either)
Would I put something like this in aspx page?
<asp:SqlDataSource ID="SqlData_Prods" runat="server"
ConnectionString="<%$ ConnectionStrings:ProductDatabaseConnectionString2 %>"
Where would I need to put my connection strings & how would I execute the whole lot?
I have the following which doesn't work and is in the Page Load of the VB file
Dim conn As New SqlConnection(_conString)
Dim cmd As New SqlCommand()
IF THEN STUFF
cmd.Connection = conn
cmd.CommandType = CommandType.Text
cmd.CommandText = dblookup