2 datasources for gridview

Question

0.00/5 (No votes)

See more:

Hi,
I have a grid view and it shows the data from a table on page load.now there is a search button which when clicked shows textboxes and one can enter text by which they want to search the data . when you click go ,the same grid view must show the search results.So i wrote ado.net code on the buton click making the data source for gridview as dt(data table) but when i run it i get an error saying that both datasource n datasourceid are given n to remove 1. the datasourceid is the database table from which the data comes on pageload. how can i supply 2 data sources for the same grid view in order to achieve this?

Posted 23-Mar-11 5:46am

Laksh112

Add a Solution

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

Vijay Ankit · Accepted Answer · 2011-03-23T16:07:00

Is it because you use first datasourceid to bind your gridview and then on button click you bind the gridview with DataSource?

1. One easy option is to set datasourceid to null on button click. Something like below:
GridView1.DataSourceID = null;
2. Other option can be to bind your gridview to datasource from codebehind in both the cases. Store the data in the ViewState (or session) in page load and bind your gridview, later when you click on button, fetch the data from viewstate/ session filtering it based on your search criteria.

Wendelius · Accepted Answer · 2011-03-23T05:54:00

Solution 1

You cannot have 2 data sources at the same time. Why not use a LINQ query on your datatables and from that query extract a new collection or data table which you then use as a data source to the gridview.

Posted 23-Mar-11 5:54am

Wendelius

Comments

Laksh112 23-Mar-11 13:26pm

ok will try doing that.... thnx 4 ur reply

Wendelius 23-Mar-11 13:32pm

No problem :)

Laksh112 23-Mar-11 14:10pm

ok i tried linq but i am new to it(actually am quiet new to .net) and am not able to get it right....can you send me a sample?

Wendelius 23-Mar-11 14:34pm

I'm sure there are lots of articles etc in CP and elsewhere. Quickly found one simple for you which uses datatables: http://www.codeproject.com/KB/windows/DatasetsAndLINQ.aspx