Click here to Skip to main content
13,091,145 members (51,665 online)
Rate this:
Please Sign up or sign in to vote.
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
ryanb31 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.
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

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
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

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.


static DataTable dtTable;
static DataView dvTable;

On Page Load save your all database value to DataTable.

Now perform your search option in that DataTable.

  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";

Hope you got it.

Happy Holi.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web02 | 2.8.170813.1 | Last Updated 27 Mar 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100