Sql Connection in WindowsForm

Hello Ramco,

You can create sington database connection class and use it,

public class SomeForm : Form
{
    public SomeForm()
    {
        InitializeComponent();

        SqlConnection cn = DatabaseConnection.GetInstance();
        // Use the connection as needed
    }
}

use this connection in your all form like below,

using System.Data.SqlClient;

public sealed class DatabaseConnection
{
    private static SqlConnection _instance = null;
    private static readonly object _lock = new object();

    // Private constructor to prevent instantiation
    private DatabaseConnection() { }

    // Public method to get the single instance of SqlConnection
    public static SqlConnection GetInstance()
    {
        if (_instance == null)
        {
            lock (_lock)
            {
                if (_instance == null)
                {
                    _instance = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=H:\Website\RegistrationAndLogin\Database.mdf;Integrated Security=True");
                    _instance.Open();
                }
            }
        }
        return _instance;
    }
}