DB copy to dev server and UPdate db after updating

Question

 Hi, 

I would like to copy required tables to server and I will do modifications in the tables. after modification I will  Update the tables in Server. Am Making modifications in the copy of production db. Don't want to perform huge operations directly to the db as it impacts 

 

as of now I am using caching. storing table objects in caching and modifying it and updating it to database.

 

Problem with this technique is I need  latest data every time. so I have to clear and load cache again and again whenever I need to run the application (it takes time). and in dev environment, if multiple users working in same machine, one user clears cache of others while working.

 

Any ideas pls.  (asp.net sql)

Answer 1

Can any one could solve this problem, if yes plz help me to solve it.

Answer 2

hai Sanjay Kumar,

Thanks for your valuable reply, Actually what iam trying to implement is to make a repeater user control that can generate dynamic columns , that is if i use that repeater in a web form with 3 columns  i must be able to use that repeater control in the next web form for more than or less than 3 columns , so the problem is i need to bind that data with out using source code, that is "Eval" method can only add one data from a particular table only, i need to generalize that part and need to made that part data binding in general, so can i bind data to a repeater without source code by using only code behind.

Please pardon me if there is any confusions, ask me for more clarifications to my idea.

Answer 3

Hi

try this

http://www.c-sharpcorner.com/UploadFile/47548d/twitter-bootstrap-and-repeater-control-in-Asp-Net/