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

*****************************************************************************************
* Connection String Configuration and Test Connection with SQL Server in ASP.NET C# - *
*****************************************************************************************

< connectionStrings>

< 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:
💛Don't forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment

Tutorial Link :

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.