Hi,
Im Having requirement tht during installation of application,I have to create tables and populate data in the tables.I am having script file which contains creation of tables and Innsert command.How to execute these files as batch.
Plz help me .
With Regards, Mahender
Mahender | | Mahender Monday, December 22, 2008 8:58 AM | I would think you could write a small application that would create your tables, etc., and deploy it as a prerequisite to your installation. Or have the application itself create the tables if they don't exist.
RobinS.
GoldMail.com - Marked As Answer byKira QianMSFT, ModeratorFriday, December 26, 2008 2:47 AM
-
| | RobinDotNet Monday, December 22, 2008 6:06 PM |
Hi Mahender,
You can take this article for your reference.
http://msdn.microsoft.com/en-us/library/49b92ztk.aspx
In this example, it creates the installer class and execute DB command in this class. Database, tables, stored procedure can be created in that class.
If you have any question, please feel free to tell me.
Sincerely,
Kira Qian
Please mark the replies as answers if they help and unmark if they don't. - Marked As Answer byKira QianMSFT, ModeratorFriday, December 26, 2008 2:47 AM
-
| | Kira Qian Tuesday, December 23, 2008 9:42 AM | I would think you could write a small application that would create your tables, etc., and deploy it as a prerequisite to your installation. Or have the application itself create the tables if they don't exist.
RobinS.
GoldMail.com - Marked As Answer byKira QianMSFT, ModeratorFriday, December 26, 2008 2:47 AM
-
| | RobinDotNet Monday, December 22, 2008 6:06 PM |
Hi Mahender,
You can take this article for your reference.
http://msdn.microsoft.com/en-us/library/49b92ztk.aspx
In this example, it creates the installer class and execute DB command in this class. Database, tables, stored procedure can be created in that class.
If you have any question, please feel free to tell me.
Sincerely,
Kira Qian
Please mark the replies as answers if they help and unmark if they don't. - Marked As Answer byKira QianMSFT, ModeratorFriday, December 26, 2008 2:47 AM
-
| | Kira Qian Tuesday, December 23, 2008 9:42 AM |
|
index > ClickOnce and Setup & Deployment Projects > How create tables and populate with data in table during installation