Click here to Skip to main content
15,867,966 members
Please Sign up or sign in to vote.
2.00/5 (1 vote)
See more:
I have one web application and one windows application

What i want to do is
There are two tables which are same in web and windows both application
I have one export button in my website
Where all the insert queries are generated which later will be inserted to my windows application and then i just have to paste that queries to my windows application and execute it

All seems to be working my question is

1. Is this right idea to do?

2. Both database have one datatype image* so in that case query hangs up and when query generated its about 600pages which obviously killing my sql server what to do now
Posted
Updated 21-Nov-13 20:12pm
v2
Comments
Dholakiya Ankit 22-Nov-13 2:13am    
@downvoter please put reason here
Maciej Los 22-Nov-13 2:31am    
What you mean: "the insert queries are generated which later will be inserted to my windows application"?
Does your applications (web and windows) share one database on one sql server?
Dholakiya Ankit 22-Nov-13 2:37am    
thanks maciej los but i have got some hints that from remote database i can do that but i am stuck at only image part now
Bernhard Hiller 22-Nov-13 3:27am    
Why do the web appliaciotn and desktop application not share the database? I.e. both connect to the same database?
Dholakiya Ankit 22-Nov-13 3:56am    
No its different but i just followed below steps and it works

1 solution

I solved it by this one

-Make a connection to your remote DB
-Look for the records you want in this remote db
-Step through them, and add those records to your local app's db
 
Share this answer
 
v2

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900