Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C#
Hello Friends,
 
I have developed 1 software that can access only one database(i.e: All clients software access the admin database).
 
Software are created into two phase:
1 For admin PC
2 for Client PC
 
Software are installed into:
1. Admin-PC (have a database: Sql server 2008)
2. Clients-PC (in 3 computer's without database)
 
This software installed into 3 different computers connected with LAN to access database.
 
My problem is that How clients software access the database from the Admin-PC ?
 
My Idea:
Create run-time database connection to (Admin & Clients) software.
So that anytime that can be configure.
 
Configuration on:
1.App.conf
2.DataSet (for Crystal report)
 
Can anyone suggest me to solve this problem
Posted 30-Nov-12 3:04am
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

1. I would do it with WCF
 
2. I would make my program n-tier UI, business logic and DAL
 
3. I'd make sure that my business logic interacts with the DAL using a consistent data type like datasets or array to minimize the endpoints exposed by my web service
 
My endpoints with pass a list, dataset, JSON , XML or some data structure that can be easily used by my DAL as long as its consistent to avoid changing the structure of the program too much.
 
In the client machines you can use a delegate or a small function to call the webservice and translate the data so that you only have to install the UI and the business logic layer on the client machine.
 
http://msdn.microsoft.com/en-us/library/bb386386.aspx[^]
  Permalink  
v3
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

Hi,
 
Your idea is correct.
At first enable the remote connection of SQL Server after that create app.config file which contains the connection string to connect your Admin PC.
At finally, assign the dataset value to crystal report
 
--SJ
  Permalink  

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 686
1 OriginalGriff 385
2 CPallini 240
3 PIEBALDconsult 150
4 Magic Wonder 131
0 OriginalGriff 5,795
1 Sergey Alexandrovich Kryukov 5,158
2 CPallini 4,740
3 George Jonsson 3,167
4 Gihan Liyanage 2,450


Advertise | Privacy | Mobile
Web04 | 2.8.140916.1 | Last Updated 30 Nov 2012
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