How to use not operator in SQL using vb.net

Question

My problem now is about how to use "not equal" in SQL. Here is my code:

Dim cmd As New SqlClient.SqlCommand
    With cmd
        .CommandText = "SELECT [Position],[Partylist],[Fullname],[Lvl],[Votes] FROM tbl_cands WHERE [Department] = '" & elem & "'AND [PositionID]=" & pres & ""
        .CommandType = CommandType.Text
        .CommandTimeout = 30
        .Connection = conn
    End With
    Dim dt As New DataTable
    dt.Load(cmd.ExecuteReader)

I need not to display fullname that is not equivalent to None.

This code looks like it could open you to SQL injection hacks. Consider using parameterized techniques instead. — Polynomial
– Polynomial, Commented Nov 6, 2013 at 7:00
Do you mean just adding AND [Fullname] <> 'None' to your query? — Szymon
– Szymon, Commented Nov 6, 2013 at 7:09

Community · Accepted Answer · 2017-05-23 11:45:31Z

1

If you are checking for NULL then the code is:

AND [Fullname] IS NOT NULL

If you want to check the value isn't a zero length string:

AND [Fullname] <> ''

If you want to check it isn't a specific value that denotes no data:

AND [Fullname] <> 'None'

But in any case, I strongly recommend you read the following link and learn how to use parameterization for your SqlCommand object. If you don't escape strings correctly you leave yourself vulnerable to injection hacks:

How to use parameters "@" in an SQL command in VB

edited May 23, 2017 at 11:45

CommunityBot

11 silver badge

answered Nov 6, 2013 at 7:57

Polynomial

3,70427 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Szymon · Accepted Answer · 2013-11-06 07:29:36Z

1

All you have to do is to add that to your query:

AND [Fullname] <> 'None'

answered Nov 6, 2013 at 7:29

Szymon

43k16 gold badges99 silver badges115 bronze badges

Collectives™ on Stack Overflow

How to use not operator in SQL using vb.net

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related