Loading

sql query - right or wrong?

sudharsan s

Can u pls tell me is this query is right or wrong for

serach data between two dates:

from and to date is select by date pickers:

sql = "SELECT * FROM dheelabs_remedies.logs where calltime
between '" + FromDate.Text + "' and '" + ToDate.Text + "' and remarks='" + drop_filter.SelectedItem + "' order by id desc";

Help me

1 Reply

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

Satyapriya Nayak14y ago
Hi Sudharsan,

Try

sql = "SELECT * FROM dheelabs_remedies.logs where calltime
between '" + FromDate.Value.Date.ToString()+ "' and '" + ToDate.Value.Date.ToString() + "' and remarks='" + drop_filter.SelectedItem + "' order by id desc";

Thanks