Click here to Skip to main content
12,688,944 members (32,454 online)
Rate this:
Please Sign up or sign in to vote.
See more: C# C#4.0
Hi Friends...........

i want to know ,

1. Requirements needed by an application to run on my client's machine, developed on platform 4.0 in C# and database used is

Sql Server Management Studio 2008.

2. How can I protect my database. So that no one can miss use.

3. How can I add all these requirements in my application's setup

Application Type (Windows Application)

Please help......
Posted 19-Dec-12 8:53am
Updated 19-Dec-12 9:26am
Member 9581488 19-Dec-12 14:16pm
If you want to run your application on diff machine. you will need IIS, that will convert your comp to work as server. From another machine you can access your application using ip address.
Google it and you will find multiple solutions.
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

You need .NET and SQL Server.

You can not stop people who have a database locally from accessing it. Nor should it, it's THEIR data. You can password protect it, but they have the data, they can get in.

You can create an installer that installs .NET but SQL Server is a seperate exe, and is licensed. If you use the free one, you still need to write a program that installs that, and then runs your MSI
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

If that is a stand alone application, you can have the database be housed in the application and secure that your rules when passing data into is stable then the only access is that application.

If that is public style application, then you can hard code the connection strings inside the application so only the application can communicate to the database.

Outside of that, would need to know if there are specific risks that need to be address to provide the needed security is in place.

Things to watch for when your communicating to the database is to insure your scripts are managed by the code and sql so injection won't occur.

Some of the best ways are through stored procedures and anytime you have a text field passing in data, make sure you are treating as data and not a function so users can pass through a statement to process by SQL (if that makes sense).

Hope that helps.

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 | Mobile
Web02 | 2.8.170113.4 | Last Updated 19 Dec 2012
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