Click here to Skip to main content
12,886,531 members (45,146 online)

How to remove white space in VB.NET

Akaglo asked:

Open original thread
In the following code all the subject codes are read by SQLDataReader rd. How do I make the DataReader read the subject code of only the selected subject regardless of whether the subject name contain white space or not such as Biology, English Language, Principles of Cost Accounting, etc?
Dim sql = "Select subjectCode From ProgramDetails.subjects where subjectname like @subname"
       Using con = New SqlConnection("Data Source=EBENEZERAKAGLO\SQLEXPRESS;Initial Catalog=Naass;Integrated Security=True")
           Using cmd = New SqlCommand(sql, con)
               cmd.Parameters.AddWithValue("@subname", String.Format("%{0}%", ""))
               con.Open()
               Using rd = cmd.ExecuteReader()
                   While rd.Read()
                       Dim subjectCode = rd.GetInt32(0)
                       subcode = subjectCode
                       ' ... '
                       MsgBox(subjectCode)
                   End While
               End Using
           End Using
       End Using
Tags: VB, VB.NET, T-SQL

Preview



When answering a question please:
  1. Read the question carefully.
  2. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
  3. If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Let's work to help developers, not make them feel stupid.
Please note that all posts will be submitted under the The Code Project Open License (CPOL).



Advertise | Privacy | Mobile
Web01 | 2.8.170424.1 | Last Updated 26 Mar 2009
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100