Writing in database by setup

Question

0.00/5 (No votes)

See more:

Hi,
Is there any possibility to write something in my database when setup runs.
I want to put the date and time at which setup runs.

Thanks

Posted 23-Dec-11 1:23am

Furqan Sehgal

Add a Solution

Comments

Wendelius 23-Dec-11 7:39am

What setup? Setup of the database, setup of your application..? Also what kind of setup mechanism are you using?

Furqan Sehgal 24-Dec-11 0:46am

Setup of application,,,,,,,,, I am using VS setup mechanism

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

OriginalGriff · Answer 1 · 2011-12-23T01:38:00

Solution 1

Yes - all you have to do is connect as usual, and insert a new row to your table.

Why is this giving you problems?

Posted 23-Dec-11 1:38am

OriginalGriff

LaxmikantYadav · Answer 2 · 2011-12-23T01:50:00

You can do it in several ways, One way is to create .sql file and write all the sql statement which you want to execute at setup time. once you completed with sql statement into file. Make one small application that will take .sql file as parameter. and will execute on required database. Call that application while setup when you done with your .sql file writting.
Following article will help you to call exeternal application while setup. In your case external application will be the that application which will execute sql statement inside .sql on database.
Extending Visual Studio Setup Project[^]