Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# ASP.NET Ajax jQuery
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 1:01am
Comments
ryanb31 at 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
good
Please Sign up or sign in to vote.

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
  Permalink  
Rate this: bad
good
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.
 
Eg:-
 
    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:-
 
  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.
  Permalink  

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

  Print Answers RSS
0 George Jonsson 215
1 Kornfeld Eliyahu Peter 169
2 Zoltán Zörgő 139
3 PIEBALDconsult 130
4 OriginalGriff 120
0 OriginalGriff 6,165
1 DamithSL 4,658
2 Maciej Los 4,107
3 Kornfeld Eliyahu Peter 3,649
4 Sergey Alexandrovich Kryukov 3,342


Advertise | Privacy | Mobile
Web02 | 2.8.141220.1 | Last Updated 27 Mar 2013
Copyright © CodeProject, 1999-2014
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