how can we retrieve data from database in ASP.NET using VB as language?

Question

i need the complete code for retreiving the data from a database.. i m coding in visual web developer and using VB as coding language. I m using SQL SERVER as database handler.

there are many examples on the web: google.co.nz/…. Maybe you have a slightly more specific example of what you're trying to achieve. — Preet Sangha
– Preet Sangha, Commented Oct 6, 2009 at 9:36

maxy · Accepted Answer · 2009-10-06 10:41:15Z

2

 Shared Dim con As SqlConnection

Shared Sub Main()
    con = New SqlConnection("Server=(local)\SQLEXPRESS;Initial Catalog=MyDatabase;Integrated Security=SSPI") 

    ' Create the command object
    Dim str As String = "SELECT ID, FirstName, LastName FROM Employee"
    Dim cmd As New SqlCommand(str, con)

    Dim da As New SqlDataAdapter(cmd)

    Dim ds As New DataSet()

    da.Fill(ds, "Employee")

    gridview1.datasource=ds;//
     gridview1.databind();// to bind the data to gridview

its will be help to u..

edited Oct 6, 2009 at 10:41

answered Oct 6, 2009 at 9:44

maxy

4383 gold badges10 silver badges20 bronze badges

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

Comments

jerjer · Accepted Answer · 2009-10-06 09:44:39Z

0

Samples here might work for you

answered Oct 6, 2009 at 9:44

jerjer

8,77634 silver badges36 bronze badges

Collectives™ on Stack Overflow

how can we retrieve data from database in ASP.NET using VB as language?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related