class dbConn
    {
        public SqlConnection myConn = new SqlConnection();
        public SqlDataAdapter da;
        public SqlDataAdapter da2;
        public SqlDataAdapter da3;
        SqlCommand Command;
        SqlCommand aCommand;
        SqlCommand rdrCommand;
        SqlDataReader rdr;
        SqlCommandBuilder cmdBld;
        public DataTable dt = new DataTable();
        public DataTable dt2 = new DataTable();
        public DataTable dt3 = new DataTable();
        public DataTable dTable = new DataTable();
        public DataSet ds = new DataSet();
        public DataSet ds2 = new DataSet();
        public DataSet ds3 = new DataSet();
        int check;
        int iRowIndex = 0;
        List<string> strArray = new List<string>();

public void OpenConnect()
        {
            myConn = new SqlConnection(@"Data Source =.\sqlexpress; integrated security = true; Initial Catalog = mmdaserver;");
        }

        public void DisplayInfo()
        {
            OpenConnect();
            Command = new SqlCommand("DisplayRecords", myConn);
            Command.CommandType = CommandType.StoredProcedure;
            aCommand = new SqlCommand("AlarmList", myConn);
            aCommand.CommandType = CommandType.StoredProcedure;

            da = new SqlDataAdapter(Command);
            da.Fill(ds, "Records");
            da = new SqlDataAdapter(aCommand);
            da.Fill(ds2, "Records");

            da2 = new SqlDataAdapter("SELECT * FROM DriverInfo", myConn);
            da3 = new SqlDataAdapter("SELECT * FROM Violations", myConn);
            da2.Fill(dt);
            da2.Fill(ds, "DriverInfo");
            da3.Fill(dt);
            da3.Fill(ds, "Violations");
            myConn.Close();
        }
}

dbConn dbc = new dbConn();
        BindingSource bSrc = new BindingSource();
        Login thisFirst = new Login();
        
        public Form1()
        {
            InitializeComponent();
            dbc.DisplayInfo();
            dataGridRecords.AllowUserToDeleteRows = true;
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            timer1.Start();
            groupBox1.Enabled = false;
            groupBox2.Enabled = false;
            groupBox3.Enabled = false;
            dataGridRecords.DataSource = null;
            dataGridAlarm.DataSource = null;
            dataGridViolations.DataSource = null;
            dataGridDriverInf.DataSource = null;
            thisFirst.ShowDialog();

            groupBox1.Enabled = true;
            groupBox2.Enabled = true;
            groupBox3.Enabled = true;
            RefreshGrid();
        }

        public void RefreshGrid()
        {
            dbc.ds.Clear();
            dbc.ds2.Clear();
            dbc.da.Update(dbc.dTable);
            dbc.DisplayInfo();
            dataGridRecords.DataSource = dbc.ds.Tables["Records"];
            dataGridAlarm.DataSource = dbc.ds2.Tables["Records"];
            dataGridViolations.DataSource = dbc.ds.Tables["Violations"];
            dataGridDriverInf.DataSource = dbc.ds.Tables["DriverInfo"];
        }