How to remove trial space of dropdownlist in vb.net. My Code is as follows

Question

1.00/5 (1 vote)

See more:

Try
Dim asql As String = ("SELECT groupname FROM tblaccountgroup")
Dim da As New OleDbDataAdapter(asql, cnnOLEDB)
Dim ds As New DataSet
da.Fill(ds)
Cmbogroup.ValueMember = "groupname"
Cmbogroup.DataSource = ds.Tables(0)
Cmbogroup.SelectedIndex = 0
Catch ex As Exception
MsgBox("ERROR : " & ex.Message.ToString)
End Try

Posted 2-Jun-15 23:07pm

Member 10617908

Add a Solution

Comments

Richard Deeming 3-Jun-15 5:18am

What does "remove trial space" mean?

Andy Lanng 3-Jun-15 5:25am

Do you mean "Trailing whitespace"?
Dim asql As String = ("SELECT LTRIM(RTRIM(groupname)) FROM tblaccountgroup")

CHill60 3-Jun-15 5:44am

I believe you're right - but like the question earlier, originating data may be wrong, OP may have a empty groupname in their datasource. I would post this as a solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
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.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Andy Lanng · Answer 1 · 2015-06-02T23:52:00

(Ok Chill ^_^)

Do you mean "Trailing whitespace"?

You should always sanitize your data going into your database. You can use the c# & VB mystring.Trim() to clean white-spaces of your data going into the database.

Failing that, the data is now in the database with leading or trailing white-spaces. Clean the data in the select statement:

VB

Try
  Dim asql As String = ("SELECT LTRIM(RTRIM(groupname)) FROM tblaccountgroup")
  Dim da As New OleDbDataAdapter(asql, cnnOLEDB)
  Dim ds As New DataSet
  da.Fill(ds)
  Cmbogroup.ValueMember = "groupname"
  Cmbogroup.DataSource = ds.Tables(0)
  Cmbogroup.SelectedIndex = 0
Catch ex As Exception
  MsgBox("ERROR : " & ex.Message.ToString)
End Try

Hope that helps ^_^