My error says like this (conversion from string "dept_id" to type 'boolean' is not valid) any solutions please

Question

1.00/5 (1 vote)

See more:

VB

Private Sub dept_num_TextChanged_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles dept_num.TextChanged
        Dim con As SqlConnection = New SqlConnection("Data Source=S-MHAMEED\SQL2008RTWO;Initial Catalog=comp.task;User ID=...;Password=....")
        Using (con)
            Dim sqlCom As New SqlCommand()
            sqlCom.Connection = con
            sqlCom.CommandText = "Sel_dept"
            sqlCom.CommandType = CommandType.StoredProcedure
            Dim Dept_id As Boolean

            con.Open()
            Integer.TryParse(dept_num.Text, Dept_id)
            sqlCom.Parameters.AddWithValue("Dept_Id", Integer.Parse(dept_num.Text))

            'Dept_id = Convert.ToInt32(sqlCom.ExecuteScalar)
            If ("Dept_id") = False Then
                MessageBox.Show("your new record")
            End If
        End Using
    End Sub
End Class

What I have tried:

i just don't know please help
Conversion from string "Dept_id" to type 'Boolean' is not valid

Posted 10-Feb-18 23:50pm

Shaddow>dark

Updated 11-Feb-18 0:30am

Wendelius

v2

Add a Solution

Comments

Richard MacCutchan 11-Feb-18 7:22am

You cannot compare a string of characters to a boolean value, it makes no sense. It is like saying if an apple = four o'clock.

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)

Wendelius · Accepted Answer · 2018-02-11T00:29:00

Solution 1

The comparison here

VB

If ("Dept_id") = False Then

Looks odd. You're trying to compare text with a boolean value.

Based on the commented code you're trying to find out if the execution has succeeded. Does the procedure return the new department value. If so, store it in a variable and using error handling (try...catch) ensure that the execution succeeds.

I believe that going through this tutorial might help you: Properly executing database operations[^]

Posted 11-Feb-18 0:29am

Wendelius

Updated 11-Feb-18 0:34am

v2

Comments

Shaddow>dark 11-Feb-18 7:09am

TY can u replay the correct solution for this ill be thankful

Wendelius 11-Feb-18 7:23am

What are you trying to compare in your code?

Shaddow>dark 11-Feb-18 7:39am

???

Shaddow>dark 11-Feb-18 7:29am

in that code i have 3 text boxes and i have button with a grid view and i activated the max number for department text box what im gonna say know that what i want i want when i insert number of the department i want it to give all details about it in the other text boxes and i want to I also want to prevent repetition in
department id ?>>>??>> that's it

Shaddow>dark 11-Feb-18 7:32am

1 _ i wanna make it give me the details when i insert the department id give me all details in the other text boxes >>>>>>>

2 _ i wanna prevent the duplicate in department id when i insert the department id got it ???

Wendelius 11-Feb-18 7:48am

In order to prevent duplicates, do not try to do that in your code, instead use constraints in your database. In this case use a unique constraint: Create Unique Constraints | Microsoft Docs[^].

What comes to the return value, if the procedure returns an integer your code could look something like

Dim Dept_id As Integer
....
Dept_id = Convert.ToInt32(sqlCom.ExecuteScalar)
...

The error handling (try catch) should take care of errors, for example if you run into a duplicate and if the procedure is successfully executed, you can just use the value returned from the procedure.