Filling tableadapter with dataset in asp.net

Question

0.00/5 (No votes)

See more:

I have added a dataset and connected with my table (Add New Item >> DataSet) Then I am trying to use the following code to fill Tableadapter with my dataset. But it is showing an error. Could anybody help me please?

VB

Dim dAdt As New SqlDataAdapter()
    dAdt.Fill(dsArticles, "tblArticles")

Please also note I have put a parameter on my dataset as well (where ProductID=@PID) Thanks

Posted 22-Feb-12 23:22pm

Furqan Sehgal

Add a Solution

Comments

Varun Sareen 23-Feb-12 5:25am

what error? Please post

Furqan Sehgal 23-Feb-12 5:27am

It says on dsArticles "dsArticles is a type and can not be used as an expression"

Varun Sareen 23-Feb-12 5:35am

Please post some more code.

Herman<T>.Instance 23-Feb-12 5:32am

please show more code, command, connection and declaration of dsArticles

Furqan Sehgal 23-Feb-12 7:34am

I have not declared dsArticles, I just created it by adding New Item

Varun Sareen 23-Feb-12 7:57am

then declare it as a dataset in order to make it fill :)

3 solutions

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)

Varun Sareen · Answer 1 · 2012-02-23T02:13:00

Solution 1

this link will prove to be of much help for your question:-

http://msdn.microsoft.com/en-us/library/bh8kx08z.aspx[^]

Don't forget to mark this as your answer if it helps you out.

Thanks

Posted 23-Feb-12 2:13am

Varun Sareen

to.areeb · Answer 2 · 2012-02-23T07:06:00

Solution 2

Please add connection and SQL query in Data Adapter like

Dim dAdt As New SqlDataAdapter("select * from table",con)
dAdt.Fill(dsArticles, "tblArticles")

con = your connection to database
("select * from table" = please insert your query

Posted 23-Feb-12 7:06am

to.areeb

Updated 23-Feb-12 7:07am

v2

Comments

Furqan Sehgal 24-Feb-12 9:53am

I really do not want to do this........ I want to write as little code as possible. Found something on http://rhondatipton.net/2006/07/03/typed-datasets-in-c/
going to test.........

Furqan Sehgal · Answer 3 · 2012-02-24T05:14:00

Add dataset using Add New >> Dataset and configure it.
Then in the namespace of the forms, add reference as
Imports DemoApplication.dsArticlesTableAdapters

Demoapplication is the name of your application and dsArticles is the name of added DataSet.

Then in the button, where you want to access the dataset and table, add code:

VB

' Access Table Adapter
       Dim ta As New tblArticlesTableAdapter()
       ' Access Dataset
       Dim dt As dsArticles.tblArticlesDataTable = ta.GetData(txtArtNo.Text)
       MsgBox(dt.Rows.Count)