Re: integrating sql with my software application: a little urgent, please

  • From: sameer manohtra <sameermanohtra@xxxxxxxxx>
  • To: programmingblind@xxxxxxxxxxxxx
  • Date: Sat, 23 Oct 2010 07:11:15 +0530

hi,
thanks for the response.
I’m glad to know that these many ways exist, but should I tell you
frankly, I have no idea  which one to use, and how.

About the third option, though that sounds easy, but still the
question is, how will the MDF file work if user doesn’t have the SQL
installed on the computer.

The first and second ways sounds interesting too, but again, I haven’t
used it, so no idea on how will it be done.

Just a humble request, could you please  be more specific on what
should I do here?

The problem is that I am asked to deliver it quick, so I just don’t
have much time to investigate this in depth.

@black, if you say that you use the first option frequently, please,
could you explain me how do you do it, and how can I make it work
quick?

Its just a very simple application as I said, which has a c# form
which takes the inputs from the user, stores it in the sql database,
and retrieves the values back when requested.

Please, help me doing this, will really appreciate.

Regards,
Sameer!



On 10/22/10, black ares <matematicianu2003@xxxxxxxxxxx> wrote:
> you have two or three solutions to investigate.
> 1. The setup and deployment feature has a nice thing.
> You can write custom actions and custom class installers, which can even
> have ui elements.
> So you must create an window and an installer class, get from the user the
> data necesary to connect to sql server and create all the database and
> populate the database.
> For this you simply need a script which you can generate using your sql
> server management studio.\
> 2. When you develop such an application, you can use an database project.
> This project then has the create and update scripts for your database and
> when you make a setup
> you will include the output of this ile on your setup and it will populate
> your database.
> 3. You can use an attached database.
> So the mdf file will be in your project and when you will get from the user
> necesary data to build the connection string, you can attach the database to
> the client server.
>
> Personally I've used irst version, but if you can quickly investigate, the
> third seems to be the quickest.
>
> ----- Original Message -----
> From: "sameer manohtra" <sameermanohtra@xxxxxxxxx>
> To: "programmingblind" <programmingblind@xxxxxxxxxxxxx>
> Sent: Friday, October 22, 2010 6:38 PM
> Subject: integrating sql with my software application: a little urgent,
> please
>
>
> Hi guys,
> i am in need of a help urgently, please help me as quick as you can,
> I’ll be very thankful.
>
> I have developed an application using c# as front end and sql server
> 2005 as backend.
>
> Its working perfect and everything done now.
> Now I need to give the application to a client for who this windows
> based application has been developed.
>
> The problem is, that I’m not able to find how can I add the database
> in my application installer?
>
> I am aware of setup and deployment feature of vs.net and have used it
> once, but that was an application without database, so had no problem
> in doing it.
>
> Its as simple as it:
> My application simply stores some inputs given by users and displays
> it when needed.
> The database therefore is extensively needed, which is located in sql
> server at present.
>
> Obviously I won’t install the full sql server package to client’s
> computer, so how should I do it then?
> Also, my connection strings are of those specified according to my
> computer, how can I assure it to work on client’s  computer?
>
> All that I’m looking for is a setup that can install my application
> with sql, which can assure the program to work successfully.
> Please, it’s a little urgent, as I need to supply the application right away
> Hoping for a quick help, sorry for the troubles.
>
> Regards,
> Sameer!
> __________
> View the list's information and change your settings at
> //www.freelists.org/list/programmingblind
>
> __________
> View the list's information and change your settings at
> //www.freelists.org/list/programmingblind
>
>
__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind

Other related posts:

  1. Home
  2. programmingblind
  3. Archive
  4. 10-2010