How to fill a dataset using VB.NET for a website

Question

0.00/5 (No votes)

See more:

Hello everyone!

I try to fill a dataset in order to have datas in a gridview.

The following code works for a WindowsApplication but not for a website.

Can you tell me where i am wrong or what is missing?

Thank you!

VB.NET

Imports System.Data
Imports System.Data.OleDb

Partial Class _Default
    Inherits System.Web.UI.Page

    Protected Sub ButtonSearch_Click(sender As Object, e As EventArgs) Handles ButtonSearch.Click

        Dim cnfd As New OleDbConnection(ConfigurationManager.ConnectionStrings("FoodmartConnectionString").ConnectionString)

        Dim ssql As String = "SELECT [customer_id], [lname], [fname] FROM [Customers] WHERE lname like '" & TextBoxCustomer.Text & "%' ORDER BY [lname]"

        Dim cmdcust As New OleDbCommand(ssql, cnfd)

        Dim ds As New DataSet

        Dim da As New OleDbDataAdapter(cmdcust)

        da.Fill(ds, "C")

        GridViewCustomer.DataSource = ds.Tables("C")

    End Sub
End Class

What I have tried:

I tried the same code for a WindowsApplication and it works.

Posted 22-Jul-16 23:35pm

Member 12649673

Updated 23-Jul-16 2:53am

Add a Solution

Comments

Karthik_Mahalingam 23-Jul-16 5:48am

what is the error you are facing?

Member 12649673 23-Jul-16 6:51am

I have a textbox and a button. When i click on the button i would like to have all the customers (in the gridview) whose lname begins with what i write in the textbox.

The gridview is filled for a Windows Application but not for a website, nothing happens.

Richard MacCutchan 23-Jul-16 5:59am

You need to render the content back to your web page. Web applications are completely different from Windows Forms.

Member 12649673 23-Jul-16 6:24am

Thanks for your answer. I haven't worked on websites lately.
How do you render the content back to the webpage?

Richard MacCutchan 23-Jul-16 6:41am

Well you need to learn all about websites and how to program them. This is not a question that can be answered in a Quick Answers forum.

Member 12649673 23-Jul-16 6:56am

I know how to create a sql datasource linked to a gridview in Visual Studio for websites. But for this particular query with like '" & TextBoxCustomer.Text & "%' i don't know how to change the code in the source page, that's why i wanted to use VB.net knowing this works for windows forms.

Richard MacCutchan 23-Jul-16 8:26am

Websites are totally different from Windows Forms. The basic code to extract the data from the database will be the same, but you need to plug that code into the appropriate place in your web pages.

1 solution

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)

Karthik_Mahalingam · Accepted Answer · 2016-07-23T02:53:00

Solution 1

call DataBind after assigning the datasource

VB

GridViewCustomer.DataSource = ds.Tables("C") 
        GridViewCustomer.DataBind()

Posted 23-Jul-16 2:53am

Karthik_Mahalingam

Comments

Member 12649673 23-Jul-16 13:30pm

Thank you! I added gridviewcustomer.databind() before but at that time my query was not good, i had for the "like" statement * instead of %. So i thought the VB.Net code was wrong.

Everything works!

Karthik_Mahalingam 24-Jul-16 1:49am

cool
by the way you code is vulnerable to SQL injection [^] attacks,
always use Parameterized queries to prevent SQL Injection Attacks in SQL Server[^]

Member 12649673 24-Jul-16 3:45am

Thanks a lot!