linking login page with sql server

There are steps to do that:

1)setup web.config file.

"myConnectionString" connectionString="server=localhost;database=xyz;uid=myUser;password=myPass;" />

If you do not have userid and password then do not write uid and password. Use this instead:

"myConnectionString" connectionString="server=localhost;InitialCatalog=xyz; Integrated Security=True;" />

2)Now access this on your page(in code behind) like this:

string connStr = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;

3)After perform your operation in your page which can be insert to table or updation, deletion etc.

Also visit this:http://www.c-sharpcorner.com/UploadFile/4aae29/complete-crud-operations-in-Asp-Net/

Hope it helps.

Thanks.

1 Reply