How load data items in Combobox condition on datetimepickers

NAGARAJU TAMADA

Hi all I have a query like how to load dataitems in combobox from database checking condition between two datetime pickersvalues in c# window forms

Select * from participant_details where Datefrm>='" + Datefrm1 + "' and DateTo<='" + DateTo1 + "' ", vCon);

da.Fill(dt);

here Datefrm1 and DateTo1 are Datetimepickers values

i didn't get correct result when I use the above code

please solve my problem

Reagards
NagaRaju

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sanjeeb Lenka13y ago
hi try like this

string Sql = "Select * from participant_details where Datefrm>=@Datefrm and DateTo<=@DateTo";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@Datefrm",SqlDbType.DateTime).Value= Datefrm1;
cmd.Parameters.AddWithValue("@DateTo",SqlDbType.DateTime).Value= DateTo1;
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
Iftikar Hussain13y ago
Hi,
Try like this

DataTable dt = new DataTable();
using (SqlConnection conn = new SqlConnection(@"Data Source=SQLEXPRESS;Initial Catalog=MyDb;Persist Security Info=True;User ID=MyUsrId;Password=MyPasswrd"))
{
if (conn.State == ConnectionState.Closed)
conn.Open();
string sql = "Select * from participant_details where Datefrm>=@Datefrm and DateTo<=@DateTo";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@Datefrm", dateTimePicker1.Value);
cmd.Parameters.AddWithValue("@DateTo", dateTimePicker2.Value);
SqlDataAdapter dap = new SqlDataAdapter(cmd);
dap.Fill(dt);
if (conn.State == ConnectionState.Open)
conn.Close();
conn.Dispose();
}

Regards,
Iftikar