I am developing a program in VB.Net and ASP.Net to allow a user to type in a code in a textbox and when they click search, a list of records with a code matching the code typed in are retrieved from an SQL Server Express database.
At the moment, I type in a code and click search, and my listbox then gets populated with 3 lines, each one saying:
I was wondering if anybody would be able to explain this to me at all?
My code is as follows:
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click Dim sqlConn As New SqlConnection Dim sqlCmd As New SqlClient.SqlCommand Dim sqlReader As SqlDataReader If TextBox1.Text = "" Then MsgBox("A centre code needs to be provided...") End If If TextBox1.Text <> "" Then 'Telling the system the location of the database. sqlConn.ConnectionString = "server=server;Initial Catalog=dbname;Trusted_Connection=yes" 'Here we are opening the connection to the database. sqlConn.Open() 'This is to say that sqlCmd is a stored procedure. sqlCmd.CommandType = System.Data.CommandType.StoredProcedure 'This is creating the command to execute the stored procedure based on the information given in the connection string. sqlCmd = sqlConn.CreateCommand 'The command is triggered to execute the stored procedure which grabs all information for the specific centre. sqlCmd.CommandText = "exec GetAllInformation '" & TextBox1.Text & "' " sqlReader = sqlCmd.ExecuteReader() 'This grabs the details for the specific centre from the database using the data reader. ListBox1.DataSource = sqlReader ListBox1.DataBind() 'This is closing the connection to the database once we have finished with it. sqlConn.Close() End If End Sub
If anyone can advise, it would be greatly appreciated.