string connectionString = ConfigurationManager.ConnectionStrings["payroll_conn"].ConnectionString;
        using (SqlConnection sqlconn = new SqlConnection(connectionString))
        {
            sqlconn.Open();
            using (SqlCommand com = new SqlCommand("SELECT * FROM employee WHERE fname=@fname and designation=@designation", sqlconn))
            {
                com.Parameters.AddWithValue("@fname", en1.Text);
                com.Parameters.AddWithValue("@designation", e1.Text);

                using (SqlDataAdapter sda = new SqlDataAdapter(com))
                {

                    ds1 = new DataSet();
                    sda.Fill(ds1);
                }
                try
                {
                    label39.Text = ds1.Tables[0].Rows[i]["id"].ToString();

                    dateTimePicker1.Text = ds1.Tables[0].Rows[i]["enddate"].ToString();


                }
                catch (Exception ex)
                {

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