View database table data , date is the main source to filter

Pavithra L

11y914.NET

How to view database table data based on the date. Here am I using date is the main source to filter all the data's from database table in c# windows application

8 Replies

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

Raja T11y ago
Accepted answer
Hi,

Try this

SqlDataAdapter da = new SqlDataAdapter("select V_No,Date1,Employee,Reference,Purpose,S_No,Machine,Job_No,Item,Qty,UOM,T1,Prepared_By,Remarks from In_House_Issues where Date1 between '" +dateTimePicker1.Value.ToString("yyyy-MM-dd") + "' AND '" + dateTimePicker2.Value.ToString("yyyy-MM-dd") + "' ", con);
Raja T11y ago
Thanks for your appreciation Pavithra L.
Pavithra L11y ago
Hai Raja,

I tried your code, its working. Thanks for your guidance.
Raja T11y ago
Hello Pavithra, Are you tried my code ?

else if (comboBox1.Text == "Date Range")
{
SqlDataAdapter da = new SqlDataAdapter("select V_No,Date1,Employee,Reference,Purpose,S_No,Machine,Job_No,Item,Qty,UOM,T1,Prepared_By,Remarks from In_House_Issues where Date1 between '" + dateTimePicker1.Value.ToString("yyyy-MM-dd")+ "' AND '" +dateTimePicker2.Value.ToString("yyyy-MM-dd")+ "' ", con);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
if (centeredContentOnpageToolStripMenuItem.Checked == true)
{
dataGridView1.Columns[12].Visible = false;
dataGridView1.Columns[13].Visible = false;
dataGridView1.Columns[14].Visible = false;
}
else
{
dataGridView1.Columns[12].Visible = true;
dataGridView1.Columns[13].Visible = true;
dataGridView1.Columns[14].Visible = true;
}
}
Pavithra L11y ago
Hai Raja,

Thank you so much for your reply ,I got my answer with your help. I will accept your answer right now.
Pavithra L11y ago
Hello ,
anybody can help my question, is there any possible to get an output for this.
It's urgent , please tell me the correct answer.
Thanks for your help in advance.
Pavithra L11y ago
Here is my code,
else if (comboBox1.Text == "Date Range")
{

SqlDataAdapter da = new SqlDataAdapter("select V_No,Date1,Employee,Reference,Purpose,S_No,Machine,Job_No,Item,Qty,UOM,T1,Prepared_By,Remarks from In_House_Issues where Date1 between '" + dateTimePicker1.Text + "' AND '" + dateTimePicker2.Text + "' ", con);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;

if (centeredContentOnpageToolStripMenuItem.Checked == true)
{
dataGridView1.Columns[12].Visible = false;
dataGridView1.Columns[13].Visible = false;
dataGridView1.Columns[14].Visible = false;
}
else
{
dataGridView1.Columns[12].Visible = true;
dataGridView1.Columns[13].Visible = true;
dataGridView1.Columns[14].Visible = true;
}
}
How can solve this problem.
Raja T11y ago
Hi, Try like

string seldate = dateTimePicker1.Value.ToString("yyyy-MM-dd");
string selectQuery = "select * from tbl_Test where selectedDate like '%" + seldate + "%'";
SqlConnection con = new SqlConnection(constr);
con.Open();
DataSet dst = new DataSet();
SqlDataAdapter dap = new SqlDataAdapter(selectQuery, con);
dap.Fill(dst, "DataSetName");
dataGridView1.DataSource = dst.Tables[0];