horizontal scroll bar in c# windows forms with sql server 2008

[vishal anand]

Hi my name is vishal. I am converting my vb6 project(vb6,ado db with ms access) to c# with sql server 2008. I have a horizontal scroll bar in a form with some fields(labels,t extboxes,combob ox and datetime picker) such as first name, last name,sex,dob. what i expect from horizontal scroll bar is that when i scroll/move with horizontal scroll bar i want to see the datas that been in database(tables ) in the c# windows form.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Configuration;
 
namespace DRRS_in_Csharp
{
    public partial class Technician : Form
    {
        long pUserID;
        public Technician()
        {
            InitializeComponent();
        }
 
        private void Technician_Load(object sender, EventArgs e)
        {
            dtDOB.MaxDate = dtDOB.Value;
            SqlConnection conn = new SqlConnection("Data Source=NPD-4\\SQLEXPRESS;Initial Catalog=Tuscan16;Integrated Security=true");
            if (conn.State != ConnectionState.Open)
            {
                conn.Open();
            }
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandType = CommandType.Text;
            DataTable dt = new DataTable();
            string s1 = ("Select td.technician_first_name,td.technican_middle_name,td.technician_last_name,t.technician_dob,t.technician_sex,td.technician_type from TECHNICIANDETAIL td,TECHNICIAN t where td.technician_id=t.technician_id");
            cmd = new SqlCommand(s1, conn);
            if (dt.Rows.Count == -1)
            {
                scrRec.Visible = true;
                long i = 0;
                do
                {
                    i = (i + 1);
                } while (dt.Rows.Count == -1);
                scrRec.Maximum = Convert.ToInt32(i - 1);
                lblRecPos.Text = "Record Pos(1/" + i + ")";
                txtFname.Enabled = false;
                txtMname.Enabled = false;
                txtLname.Enabled = false;
                dtDOB.Enabled = false;
                cboSex.Enabled = false;
                txtFname.Text = cmd.Parameters.AddWithValue("technician_first_name", SqlDbType.VarChar).Value.ToString();
                txtMname.Text = cmd.Parameters.AddWithValue("technician_middle_name", SqlDbType.VarChar).Value.ToString();
                txtLname.Text = cmd.Parameters.AddWithValue("technician_last_name", SqlDbType.VarChar).Value.ToString();
                dtDOB.Value = Convert.ToDateTime(cmd.Parameters.AddWithValue("technician_dob", SqlDbType.Date).Value);
                if ((cmd.Parameters.AddWithValue("technician_type", SqlDbType.Int).Value is DBNull) && (Convert.ToBoolean(cmd.Parameters.AddWithValue("technician_type", SqlDbType.Int).Value == false.GetType())))
                {
                    cmd.Parameters.AddWithValue("technician_type", cboTechType.SelectedIndex);
                }
                else
                {
                    cboTechType.SelectedIndex = 0;
                }
                if (cmd.Parameters.AddWithValue("technician_sex", SqlDbType.VarChar).Value == "M")
                {
                    cboSex.SelectedIndex = 0;
                }
                else
                {
                    cboSex.SelectedIndex = 1;
                }
            }
            else
            {
                scrRec.Visible = true;
                button1.Text = "Create";
            }
            conn.Close();
        }
 
        private void button1_Click(object sender, EventArgs e)
        {
            if (button1.Text == "New")
            {
                txtFname.Enabled = true;
                txtMname.Enabled = true;
                txtLname.Enabled = true;
                cboSex.Enabled = true;
                dtDOB.Enabled = true;
 
                txtFname.Text = "";
                txtMname.Text = "";
                txtLname.Text = "";
                cboSex.SelectedIndex = -1;
                txtFname.Focus();
                button1.Text = "Create";
            }
            string dFieldName = "";
            if (txtFname.Text.ToString().Trim() == "")
            {
                dFieldName = "Please enter the technician first name";
            }
            else if (cboSex.SelectedIndex == -1)
            {
                dFieldName = "Please select gender for technician";
            }
            else if (cboTechType.SelectedIndex == -1)
            {
                dFieldName = "Please select technician type";
            }
            if (dFieldName.ToString().Trim() != "")
            {
                MessageBox.Show(dFieldName);
            }
            SqlConnection conn = new SqlConnection("Data Source=NPD-4\\SQLEXPRESS;Initial Catalog=Tuscan16;Integrated Security=true");
            if (conn.State != ConnectionState.Open)
            {
                conn.Open();
            }
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandType = CommandType.Text;
            cmd = new SqlCommand("insert into TECHNICIAN(technician_dob,technician_sex,row_upd_date,user_id)" + "Values(@technician_dob,@technician_sex,GetDate(),@user_id)", conn);
            if (cboSex.SelectedIndex == 0)
            {
                cmd.Parameters.AddWithValue("@technician_sex", SqlDbType.VarChar).Value = "M";
            }
            else
            {
                cmd.Parameters.AddWithValue("@technician_sex", SqlDbType.VarChar).Value = "F";
            }
            cmd.Parameters.AddWithValue("@technician_dob", dtDOB.Value);
            cmd.Parameters.AddWithValue("@user_id", pUserID);
            cmd.ExecuteNonQuery();
 
            cmd = new SqlCommand("Insert into TECHNICIANDETAIL(technician_first_name,technician_middle_name,technician_last_name,row_upd_date,status,user_id,technician_type)" + "Values(@technician_first_name,@technician_middle_name,@technician_last_name,GetDate(),@status,@user_id,@technician_type)", conn);
            cmd.Parameters.AddWithValue("@technician_first_name", txtFname.Text);
            cmd.Parameters.AddWithValue("@technician_middle_name", txtMname.Text);
            cmd.Parameters.AddWithValue("@technician_last_name", txtLname.Text);
            cmd.Parameters.AddWithValue("@technician_type", cboTechType.SelectedIndex);
            cmd.Parameters.AddWithValue("@status", true);
            cmd.Parameters.AddWithValue("@user_id", pUserID);
            cmd.ExecuteNonQuery();
            ((MDIParent5)this.MdiParent).updateUserActivities(pUserID, 3, txtFname.Text + "technician detail was added successfully");
            MessageBox.Show("Technician detail  was added successfully", "DRRS", MessageBoxButtons.OK, MessageBoxIcon.Information);
            conn.Close();
 
 
        }
 
        private void button2_Click(object sender, EventArgs e)
        {
            this.Close();
        }
 
        private void scrRec_Scroll(object sender, ScrollEventArgs e)
        {
 
            SqlConnection conn = new SqlConnection("Data Source=NPD-4\\SQLEXPRESS;Initial Catalog=Tuscan16;Integrated Security=true");
            if (conn.State != ConnectionState.Open)
            {
                conn.Open();
            }
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandType = CommandType.Text;
            DataTable dt = new DataTable();
 
            lblRecPos.Text = "Record Pos(" + scrRec.Value + 1 + "/" + scrRec.Maximum + 1 + ")";
            if (dt.Rows.Count == -1)
            {
                txtFname.Enabled = false;
                txtMname.Enabled = false;
                txtLname.Enabled = false;
                dtDOB.Enabled = false;
                cboSex.Enabled = false;
                txtFname.Text = cmd.Parameters.AddWithValue("technician_first_name", SqlDbType.VarChar).Value.ToString();
                txtMname.Text = cmd.Parameters.AddWithValue("technician_middle_name", SqlDbType.VarChar).Value.ToString();
                txtLname.Text = cmd.Parameters.AddWithValue("technician_last_name", SqlDbType.VarChar).Value.ToString();
                dtDOB.Value = Convert.ToDateTime(cmd.Parameters.AddWithValue("technician_dob", SqlDbType.Date).Value);
                if ((cmd.Parameters.AddWithValue("technician_type", SqlDbType.Int).Value is DBNull) && (Convert.ToBoolean(cmd.Parameters.AddWithValue("technician_type", SqlDbType.Int).Value == false.GetType())))
                {
                    cmd.Parameters.AddWithValue("technician_type", cboTechType.SelectedIndex);
                }
                else
                {
                    cboTechType.SelectedIndex = 0;
                }
                if (cmd.Parameters.AddWithValue("technician_sex", SqlDbType.VarChar).Value == "M")
                {
                    cboSex.SelectedIndex = 0;
                }
                else
                {
                    cboSex.SelectedIndex = 1;
                }
                conn.Close();
            }
 
 

i have tried coding for horizontal scroll bar but nothing seems to work. Can anyone help me please!