Asp.net C# Tutorial 4 - Connection String Configuration and Test Connection with SQL Server

[email protected] Chirag's Asp.net C# Tutorial https://www.chirags.in
*****************************************************************************************
* Connection String Configuration and Test Connection with SQL Server in ASP.NET C# - *
* Coding in Web.config file using Visual Studio *
*****************************************************************************************

1. Connection Strings in Web.config file.
﹤ connectionStrings﹥
﹤ add name="conString" connectionString="Data Source=localhost;Initial Catalog=gyans;user id=sa; password=admin@123" providerName="System.Data.SqlClient" /﹥

﹤ add name="conStringInegratedSecuritySSPI" connectionString="data source=localhost; initial catalog=gyans;persist security info=True; Integrated Security=SSPI;" providerName="System.Data.SqlClient" /﹥

﹤ add name="conStringInegratedSecurityTrue" connectionString="data source=localhost; initial catalog=gyans;persist security info=True; Integrated Security=true;" providerName="System.Data.SqlClient" /﹥

﹤ add name="conStringInegratedSecurity" connectionString="data source=CHIRAG-LAPPY; Initial Catalog=gyans;Integrated Security=SSPI;" providerName="System.Data.SqlClient" /﹥
﹤ /connectionStrings﹥

2. Write sql connection in C# page
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conString"].ConnectionString);

3. Write the code for test the database connection.

con.Open();
if ((con.State & ConnectionState.Open) ﹥ 0)
{
Response.Write("Connection OK!");
con.Close();
} else {
Response.Write("No Connection!");
con.Close();
}

Note : Flow the Process shown in video.

?Subscribe and like for more videos:
https://www.youtube.com/channel/UCLdaO4-i_gxQMi87JwjKOwA
?Don't forget to, ?Follow, ?Like, ?Share ?&, Comment

Tutorial Link :
https://www.chirags.in/asp-dot-net-c-sharp-programming

Thanks & Regards,
Chitt Ranjan Mahto "Chirag"
_________________________________________________________________________________________
Note: All scripts used in this demo will be avilable in our website.
Link will be available in description.