Sample

  SqlConnection con = new SqlConnection(@"Data Source=.\sqlexpress;Initial Catalog=dbLMS;Integrated Security=True");

        private void dtpPOTA_ValueChanged(object sender, EventArgs e)
        {
            con.Open();
            SqlCommand cmd = new SqlCommand("SELECT PaymentType, Amount, LoanNo FROM tblDates where PayableDates ='"+dtpPOTA.Value.ToShortDateString()+"'", con);
            SqlDataReader read = cmd.ExecuteReader();

            while(read.Read())
            {
                string Payment = read.GetString(0);
                string Amount = read.GetValue(1).ToString();
                string loanId = read.GetString(2);

                txtLoanNo.Text = loanId.ToString();
                txtAmount.Text = Amount.ToString();
                txtPayableType.Text = Payment.ToString();
            }
            con.Close();
        }