Yes I'm a newbie learning but I' developing a web app using Visual Studio 2010 where it gives the user three items to pick from and base on what they pick it returns the sub-category information which is in a SQL table. The three name below are ListItems
(below is the return information, the liskt of books that author wrote)
Would the code behind my Submitbutton(Default.aspx) be as follow:
Protect sub button1_click () handles button1_click
Dim connectionString as String = "server='localhost'; user id = ''; password = ''; database = ''"
Dim sqlConnection As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection(connectionString)
Dim queryString As String = "Select titlebooks * from bookTBL"
Dim sqlCommand As system.data.SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand(queryString, sqlConnection)
Dim dataReader As System.Data.SqlClient.SqlDataReader = sqlCommand.executeReader(System.data.CommandBehavior.CloseConnection)
View Complete Post