开发者

Unable to display SQL database data on Visual basic form

开发者 https://www.devze.com 2023-04-07 18:42 出处:网络
I am facing a problem displaying the records of my table on the visual basic form I have created. This is my code :

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 开发者_JAVA百科basic form that I have created ?


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)
0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号