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_NoDate1EmployeeReferencePurposeS_NoMachineJob_NoItemQtyUOMT1Prepared_ByRemarks 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_NoDate1EmployeeReferencePurposeS_NoMachineJob_NoItemQtyUOMT1Prepared_ByRemarks 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_NoDate1EmployeeReferencePurposeS_NoMachineJob_NoItemQtyUOMT1Prepared_ByRemarks 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