Скачать или смотреть Connection String Configuration and Test Connection with SQL Server in ASP.NET C#

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


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

#ChiragTutorial
#ChiragsTutorial
#Chirags
#Chirag
#ChittRanjanMahto
#ChiragMahto
#SQLServer
#ASPNET
#CSharp
#DotNET
#ConnectionString
#SQLServerConnection
#SQLServerTutorial
#DatabaseConnection
#ConnectionTest
#TestSQLConnection
#SQLServerCSharp
#ASPNETTutorial
#CSharpTutorial
#BackendDevelopment
#SQLServerIntegration
#SQLConnection
#ConnectionStringConfig
#SQLConnectionTest
#ASPConnectionString
#SQLDatabase
#DatabaseConnectionTest
#SQLServerSetup
#SQLServerConnectionTest
#SQLServerASP
#SQLServerConnectionString
#ASPNETCore
#ASPNETMVC
#SQLDatabaseConnection
#SQLServerConnectionConfig
#SQLServerTesting
#SQLServerManagement
#DatabaseConfig
#SQLServerCoding
#SQLForBeginners
#SQLConnectionExample
#SQLServerApp
#ConnectionTroubleshooting
#SQLServer2024
#ASPDatabaseConnection
#SQLServerAdmin
#SQLServerDeveloper
#ASPConnectivity
#SQLServerConnectionASP
#ASPNetConnection
#ASPNetSQLConnection
#SQLConfig
#SQLServerTestConnection
#SQLASPNet
#DatabaseIntegration
#SQLServerAuthentication
#SQLServerConnectionTestASP
#SQLServerBestPractices
#ASPDotNetConnection
#SQLServerTutorial2024
#ASPNetCoreSQL
#SQLServerConnectionExample
#SQLServerVideo
#ASPNetDeveloper
#SQLServerAppDev
#SQLServerHowTo
#SQLServerLessons
#ASPDotNetSQLServer
#SQLConnectionHowTo
#DatabaseTesting
#SQLServerConfigTutorial
#ASPNetConnectionSetup
#SQLServerMadeEasy
#SQLServerBackend
#ASPNetSQLTutorial
#SQLServerConnectionCSharp
#SQLServer2025
#ASPNetDatabase
#SQLServerGuide
#ASPNetBeginners
#SQLServerPractical
#SQLServerWithASP
#SQLServerTips
#DatabaseConnectivity
#SQLServerFramework
#SQLServerExampleASP
#SQLServerProject
#SQLServerProgramming
#SQLServerHelp
#SQLServerStepByStep
#ASPNetWithSQLServer
#SQLServerSimpleSteps
#SQLServerConnectionASPNet
#DatabaseConnectionASP
#SQLServerASPNetExample
#SQLServerInASP
#SQLServerTutorialForBeginners
#SQLServerASPNetTutorial
#SQLServerTestingASP
#SQLServerConfigASP