[X] My Assistant

[sonia.sardana]

hey frnds, tell me one thing as in VB.Net suppose if we want to connnect to SQL,then in form coding itself.We create the database,Create table ...& insert values...

WE do that cz if we run the project at Client side,even if no database is there our project automatically creates it So that no error is there,Is it also possible in ASP.net...

Is yes,can somebody tell me from where to start...

[eclipsed4utoo]

when communicating between .Net and SQL Server, I normally use the SqlConnection, SqlCommand, and SqlDataReader classes.

The SqlCommand object can run any sql statement. So if you construct a sql statement to create a new database, then the SqlCommand object can run that.

[Karthik_rao]

hi you are using window application or web application.

in window's application is applicable to install the MSDE, but we should have to create as a exe. to install in client system.

hey frnds, tell me one thing as in VB.Net suppose if we want to connnect to SQL,then in form coding itself.We create the database,Create table ...& insert values...

WE do that cz if we run the project at Client side,even if no database is there our project automatically creates it So that no error is there,Is it also possible in ASP.net...

Is yes,can somebody tell me from where to start...