Unable to display SQL database data on Visual basic form

Question

I am facing a problem displaying the records of my table on the visual basic form I have created.

This is my code :

    Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As    System.EventArgs) Handles Button2.Click
    myconnection = New SqlConnection("server=HOME-PC\SQLEXPRESS;uid=sa;pwd=123;database=college")

    myconnection.Open()
    mycommand = New SqlCommand("SELECT * from demo3)", myconnection)
    Dim mySqlDataAdapter As New SqlDataAdapter(mycommand)
    Dim mydsStudent As New DataSet()

    mySqlDataAdapter.Fill(mydsStudent, "Student")

    ra = mycommand.ExecuteNonQuery()
    MessageBox.Show("Data Displayed" & ra)

    myconnection.Close()
 End Sub
End Class

Note: my database name is "college" , table name is "demo3" . Table contains 2 columns namely name and roll no. How to display the data in those columns on the visual basic form that I have created ?

Anuraj · Accepted Answer · 2011-09-26 05:23:48Z

2

You don't need to call execute non query. You can bind the dataset to a DataGridView. Like this

Dim DataGridView1 as new DataGridView()
DataGridView1.DataSource = mydsStudent
'Your table goes here, not sure about the exact propety name, hope it works.
DataGridView1.DisplayMember = "demo3" 
Me.Controls.Add(DataGridView1)

edited Sep 26, 2011 at 5:23

answered Sep 26, 2011 at 4:34

Anuraj

19.6k7 gold badges61 silver badges84 bronze badges

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

8 Comments

Parth Doshi Over a year ago

is it DisplayMemeber or DisplayMember ?

Parth Doshi Over a year ago

Anuraj : I am getting an error saying DataGridView1 not declared ...how to solve this error ?

Anuraj Over a year ago

@Parth_90 You need to drag and drop DataGridview in the Form. Or you do like try my answer, I modified it.

Parth Doshi Over a year ago

when i drag and drop datagridview on my form ..do i have to include "me.control.add(datagridview1)" line ?

Parth Doshi Over a year ago

I m getting error in this line: DataGridView1.DisplayMember = "demo3" ..it says DisplayMember is not a member of DataGridView

|

Collectives™ on Stack Overflow

Unable to display SQL database data on Visual basic form

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related