How to load data from table and display in datagrid in VB.NET?

Question

How to load data from database table and display in datagrid in VB.NET? I know how it is in C#. I am not familiar with vb.net. Any help will be appreciated.

if you know C# then link try this

joshua
– joshua

2012-02-02 10:09:33 +00:00
Commented Feb 2, 2012 at 10:09 — joshua
– joshua, Commented Feb 2, 2012 at 10:09
MSDN shows you also in VB.NET how it works.

Tim Schmelter
– Tim Schmelter

2012-02-02 10:15:21 +00:00
Commented Feb 2, 2012 at 10:15 — Tim Schmelter
– Tim Schmelter, Commented Feb 2, 2012 at 10:15
datagrid is what? ASP.NET, WinForm or WPF Control?

Oybek
– Oybek

2012-02-02 12:00:21 +00:00
Commented Feb 2, 2012 at 12:00 — Oybek
– Oybek, Commented Feb 2, 2012 at 12:00

Sukanya · Accepted Answer · 2012-02-02 12:09:10Z

3

Try the following:-

    Imports System.Data.SqlClient

In your event, write:-

    Dim con As SqlConnection

    Dim ada As New SqlDataAdapter()
    Dim ds As New DataSet

    con = New SqlConnection("server=localhost;uid=sa;pwd=;database=databasename")
    con.Open()


    ada = New SqlDataAdapter("Select * from tablename", con)
    ada.Fill(ds)
    DataGridView1.DataSource = ds.Tables(0)

I think this will solve your problem.

answered Feb 2, 2012 at 12:09

Sukanya

1,0618 gold badges21 silver badges40 bronze badges

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

1 Comment

Sukanya Over a year ago

@Sun if my solution helps you to solve your problem, please accept it as your answer by clicking the check sign.

Collectives™ on Stack Overflow

How to load data from table and display in datagrid in VB.NET?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related