SqlConnection Class ADO.NET | SqlConnection C# | SqlClient SqlConnection

 using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Data;

using System.Data.SqlClient;

using System.Configuration;


namespace SQLConnectionADO

{

    internal class Program

    {

        static void Main(string[] args)

        {

            Program.Connection();

            Console.ReadLine();

        }


        static void Connection()

        {

            string cs = ConfigurationManager.ConnectionStrings["dbcs"].ConnectionString;

            SqlConnection con = null;

            try

            {

                using (con = new SqlConnection(cs))

                {

                    con.Open();

                    if (con.State == ConnectionState.Open)

                    {

                        Console.WriteLine("Connection has been Created Successfully !!");

                    }

                }

            }

            catch (SqlException ex)

            {

                Console.WriteLine(ex.Message);

            }

            finally

            {

                con.Close();

            }

        }



        //static void Connection()

        //{

        //    string cs = "Data Source=HEER\\SQLEXPRESS;Initial Catalog=ado_d;Integrated Security=true;";

        //    SqlConnection con = null;

        //    try

        //    {

        //        using (con = new SqlConnection(cs))

        //        {

        //            con.Open();

        //            if (con.State == ConnectionState.Open)

        //            {

        //                Console.WriteLine("Connection has been Created Successfully !!");

        //            }

        //        }

        //    }

        //    catch (SqlException ex)

        //    {

        //        Console.WriteLine(ex.Message);

        //    }

        //    finally

        //    {

        //        con.Close();

        //    }



        //    //using(SqlConnection con = new SqlConnection(cs))

        //    //{

        //    //    con.Open();

        //    //    if (con.State == ConnectionState.Open)

        //    //    {

        //    //        Console.WriteLine("Connection has been created successfully.");

        //    //    }

        //    //}



        //    //SqlConnection con = new SqlConnection(cs);

        //    //try

        //    //{

        //    //    con.Open();

        //    //    if (con.State == ConnectionState.Open)

        //    //    {

        //    //        Console.WriteLine("Connection has been created successfully.");

        //    //    }

        //    //}

        //    //catch (SqlException ex)

        //    //{

        //    //    Console.WriteLine(ex.Message);

        //    //}

        //    //finally

        //    //{

        //    //    con.Close();

        //    //}

        //}

    }

}

Above File is SQLConnectionADO\Program.cs









<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <startup> 
        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.7.2" />
    </startup>
<connectionStrings>
<add name="dbcs" connectionString="Data Source=HEER\\SQLEXPRESS;Initial Catalog=ado_db;Integrated Security=true;" providerName="System.Data.SqlClient"/>
</connectionStrings>
</configuration>
Above File is SQLConnectionADO\App.config













Comments

Post a Comment

Popular posts from this blog

Create a User Registration Form in ASP.NET using SQL Server, Visual Studio 2022 & Bootstrap

Image
 <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="userreg.aspx.cs" Inherits="Registration_Form.userreg" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server">     <title>User Registration</title>     <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-QWTKZyjpPEjISv5WaRU9OFeRpok6YctnYmDr5pNlyT2bRjXh0JMhjY6hW+ALEwIH" crossorigin="anonymous"/>     <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/js/bootstrap.bundle.min.js" integrity="sha384-YvpcrYf0tY3lHB60NNkmXc5s9fDVZLESaAA55NDzOxhy9GkcIdslK1eN7N6jIeHz" crossorigin="anonymous"></script> </head> <body>     <div class="container">         <form class="row g-3 bg-light" runat="server" meth...
Read more

Create a Simple Login Form in ASP.NET using Visual Studio 2022

Image
 <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="login.aspx.cs" Inherits="LoginFormASP.login" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server">     <title></title> </head> <body>     <h1 align="center">Login Form</h1>     <form id="form1" runat="server">         <table align="center">             <tr>                 <td>Username</td>                 <td>                     <asp:TextBox ID="txtUser" runat="server"></asp:TextBox>                 </td>             </tr>             <tr>       ...
Read more

SqlCommand Class ADO.Net | ExecuteNonQuery | ExecuteReader | ExecuteScalar

Image
 using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Data; using System.Data.SqlClient; using System.Configuration; namespace SQLConnectionADO {     internal class Program     {         static void Main(string[] args)         {             Program.Connection();             Console.ReadLine();         }         static void Connection()         {             string cs = ConfigurationManager.ConnectionStrings["dbcs"].ConnectionString;             SqlConnection con = null;             try             {                 using (con = new SqlConnection(cs))       ...
Read more