I want to fill data when I insert the id in id text box here is my code but when I insert id dept nothing shows ?

Question

0.00/5 (No votes)

See more:

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=sa;Password=likebefore")
        Using (con)

            Dim dt As New DataTable
            Dim sqlCom As New SqlCommand()
            Dim sqlDA As New SqlDataAdapter()

            sqlCom.Connection = con
            sqlCom.CommandText = "insert_dept"
            sqlCom.CommandType = CommandType.StoredProcedure
            sqlCom.Parameters.AddWithValue("dept_id", Val(dept_num.Text))
            sqlDA = New SqlDataAdapter(sqlCom)
            sqlDA.Fill(dt)

            If dt.Rows.Count Then
                dept_name.Text = dt.Rows(0).Item("debt_name")
                emp_num.Text = dt.Rows(0).Item("debt_emp")
            End If

        End Using

What I have tried:

i want to fill data when i insert the id in id text box Here is my code but when i insert id dept nothing shows ???

Posted 12-Feb-18 20:02pm

Shaddow>dark

Updated 12-Feb-18 20:31pm

Add a Solution

Comments

Animesh Datta 13-Feb-18 2:34am

put your store procedure in the question.

Shaddow>dark 13-Feb-18 3:26am

ALTER PROCEDURE [dbo].[insert_dept]

@dept_id INT = NULL,
@debt_name NVARCHAR(50) = NULL,
@debt_emp NUMERIC(18) = NULL

AS
BEGIN

IF NOT EXISTS(SELECT 1 FROM Department WHERE dept_id = @dept_id)
BEGIN
INSERT INTO dbo.Department (dept_id ,debt_name ,debt_emp )
VALUES (@dept_id ,@debt_name ,@debt_emp )
END
ELSE
BEGIN

UPDATE dbo.Department
SET debt_name=@debt_name ,debt_emp=@debt_emp
WHERE dept_id=@dept_id

END

END

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)

OriginalGriff · Accepted Answer · 2018-02-12T20:31:00

Just as with your last question, we still can't read your SP, we can't tell what your tables look line, we can't access your data, we can;t tell what you are passing.

All all of that is essential to solve this problem.
So, it's going to be up to you.
Fortunately, you have a tool available to you which will help you find out what is going on: the debugger. How you use it depends on your compiler system, but a quick Google for the name of your IDE and "debugger" should give you the info you need.

Put a breakpoint on the first line in the function, and run your code through the debugger. Then look at your code, and at your data and work out what should happen manually. Then single step each line checking that what you expected to happen is exactly what did. When it isn't, that's when you have a problem, and you can back-track (or run it again and look more closely) to find out why.
Look at exactly what is in dept_num.Text, use SSMS to SELECT all matchign rows (after you look at the SP to find out exactly what it does) and see what is going to be returned. Then follow your code through as see what is returned.

Sorry, but we can't do that for you - time for you to learn a new (and very, very useful) skill: debugging!