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

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

Process.Start ()

http://msdn2.microsoft.com/en-us/lib...ess.start.aspx

Is that what you meant?

Ken
Microsoft MVP [ASP.NET]


"Liming" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

Thanks Ken.

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


Really appreicate it.

Liming

Ken Cox [Microsoft MVP] wrote:
> An ASP.NET page can execute a script if it has the proper permissions. Just
> use
>
> Process.Start ()
>
> http://msdn2.microsoft.com/en-us/lib...ess.start.aspx
>
> Is that what you meant?
>
> Ken
> Microsoft MVP [ASP.NET]
>
>
> "Liming" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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
> >