Can not find table in vb.net

Question

0.00/5 (No votes)

See more:

when i was click on button then message box show message "cannot find table0."
what does it means ???how can i solve this problem ????

VB

Private Sub butsea_Click(sender As Object, e As EventArgs) Handles butsea.Click

        Dim dset As New DataSet
        Dim da As SqlDataAdapter
        Dim myCmd As New SqlCommand

        Try
       myConn.ConnectionString = "Data Source=THEONE\PARTH;Initial Catalog=testdatabase;Integrated Security=True;"
            myConn.Open()

            Dim avalue As String = (InputBox("Input Student Id", "Search Student")).ToString
            txt_id.Text = avalue
            da = New SqlDataAdapter("SELECT * FROM studentdetails where student_id= '" & txt_id.Text & "", myConn)
            If dset.Tables(0).Rows.Count > 0 Then
                MsgBox("Record Found")
            Else
                MsgBox("No Record Found")
            End If
           
        Catch ex As Exception
            MsgBox(ex.Message)
        Finally
            myConn.Close()
        End Try

    End Sub

Posted 24-Aug-13 5:34am

Parth Akbari

Add a Solution

Comments

abbaspirmoradi 24-Aug-13 12:20pm

you must fill dataset with SqlDataAdapter

2 solutions

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 · 2013-08-24T06:23:00

Solution 1

You declare a DataSet at the top of your method, but you don't actually connect it with the database via the DataAdapter! Try adding the middle line:

SQL

da = New SqlDataAdapter("SELECT * FROM studentdetails where student_id= '" & txt_id.Text & "", myConn)
da.Fill(dset)
If dset.Tables(0).Rows.Count > 0 Then

Posted 24-Aug-13 6:23am

OriginalGriff

Comments

Parth Akbari 24-Aug-13 12:42pm

thx,
now i want to extract every single value from database and display value (single value)in textbox ,
use above same code method....

OriginalGriff 24-Aug-13 12:45pm

And?
Your difficulty doing this is? :laugh:
Post it as a new question - it isn't directly related to the original question, so it needs a new one - with rather better information than a single sentence!

abbaspirmoradi · Accepted Answer · 2013-08-24T06:25:00

C#

Private Sub butsea_Click(sender As Object, e As EventArgs) Handles butsea.Click
 
        Dim dset As New DataSet
        Dim da As SqlDataAdapter
        Dim myCmd As New SqlCommand
 
        Try
       myConn.ConnectionString = "Data Source=THEONE\PARTH;Initial Catalog=testdatabase;Integrated Security=True;"
            myConn.Open()
 
            Dim avalue As String = (InputBox("Input Student Id", "Search Student")).ToString
            txt_id.Text = avalue
            da = New SqlDataAdapter("SELECT * FROM studentdetails where student_id= '" & txt_id.Text & "", myConn)
            da.Fill(dset)
            If dset.Tables(0).Rows.Count > 0 Then
                MsgBox("Record Found")
            Else
                MsgBox("No Record Found")
            End If
           
        Catch ex As Exception
            MsgBox(ex.Message)
        Finally
            myConn.Close()
        End Try
 
    End Sub