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

Question

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

Raja T · 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 T · Answer

Thanks for your appreciation Pavithra L .

Pavithra L · Answer

Hai Raja, I tried your code, its working. Thanks for your guidance.

Raja T · Answer

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 L · Answer

Hai Raja, Thank you so much for your reply ,I got my answer with your help. I will accept your answer right now.

Pavithra L · Answer

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 L · Answer

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 T · Answer

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];

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

Answers (8)