application set up project

[Liming]

Hi,

We have a web application and we want to create a few setup .aspx pages
for users to configure setup parameters and then we would take cares of
updating web.config connection string, setup database/tables/store
procedures.

I'm wondering what is the best way to do this?

I know for the default .NET 2.0 features likes membership, profiles and
what not, I can use Management.SqlServices to do create the databases
programmetically. What about my own databases, tables and store
procedures. Is there any easy way to use .net to execute a few .sql
scripts programmetically and have everything setup?

Thanks a lot

 

[Ken Cox [Microsoft MVP]]

An ASP.NET page can execute a script if it has the proper permissions. Just
use

Process.Start ()

http://msdn2.microsoft.com/en-us/library/system.diagnostics.process.start.aspx

Is that what you meant?

Ken
Microsoft MVP [ASP.NET]

 

[Liming]

Thanks Ken.

After some researching on Process.Start() I think that's what I needed.


Really appreicate it.

Liming

An ASP.NET page can execute a script if it has the proper permissions. Just
use

Process.Start ()

http://msdn2.microsoft.com/en-us/library/system.diagnostics.process.start.aspx

Is that what you meant?

Ken
Microsoft MVP [ASP.NET]

Hi,

We have a web application and we want to create a few setup .aspx pages
for users to configure setup parameters and then we would take cares of
updating web.config connection string, setup database/tables/store
procedures.

I'm wondering what is the best way to do this?

I know for the default .NET 2.0 features likes membership, profiles and
what not, I can use Management.SqlServices to do create the databases
programmetically. What about my own databases, tables and store
procedures. Is there any easy way to use .net to execute a few .sql
scripts programmetically and have everything setup?

Thanks a lot