how to load all the data on page load and create a temproary table, a challenge

Question

0.00/5 (No votes)

See more:

Hi all,
Iam having Two drop downs for both the values will be loaded from the database, I need to have an local copy of the tables initially when my page is loading I will load from database, and after if any Dropdown selected event occurs it should search and filter within the local copy of table it should not go to the Database.and is it possible write Stored Procedure to manipulate within the local copy
I doesnt require any coding pls say whats the concept name of retrieving and manipulating within the copied table, if this is possible is it possible to load and keep an local copy of 5 or 6 Table.

Posted 27-Mar-13 0:01am

ashok_89

Add a Solution

Comments

ZurdoDev 27-Mar-13 7:22am

No, you need to use something like Google gears, if it is still around. A stored procedure on your SQL server cannot access information on the client machine. The web is disconnected. I think you need to rethink what you are trying to do.

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)

Member 9927209 · Accepted Answer · 2013-03-27T01:31:00

Solution 1

Quote:
You can go for LINQ and entity framework(EDML Files) in .net
where you can load the tables and run queries on the retrieved table using linq queries

Posted 27-Mar-13 1:31am

Member 9927209

Raje_ · Accepted Answer · 2013-03-27T02:02:00

You can use DataView for that.

First declare a Global DataTable. then store your all database value to that datatable.
Second declare a Global DataView.

Eg:-

C#

static DataTable dtTable;
static DataView dvTable;

On Page Load save your all database value to DataTable.

Now perform your search option in that DataTable.
Eg:-

C#

dvTable = new DataView(dtTable); //pass your datatable object in dataview.
dvTable.RowFilter = "your filter query"; //use RowFilter property to filter your value
//then bind this dataview to your control
dropdown.DataSource = dvTable.ToTable();
dropdown.DataTextField = "your text field";
dropdown.DataValueField = "your value field";
dropdown.DataBind();

Hope you got it.

Happy Holi.