Based on the date want to filter data's from datatable

Pavithra L

In my project I am using report form. here I want to filter data based on from date to Todate.

Am I using two datetimepicker one for fromdate and one for Todate.

Here is my code. This cannot filter the correct date values it can filter whole data's of that table.Kindly give me any suggestion to overcome this problem .

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;

}

9 Replies

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

Pavithra L11y ago
Hai,

Anybody can help my question about how to search data based on the date using c# windows application.
0
Pavithra L11y ago
Hai ,

In my project am I using datetimepicker not a textboxes. How can I do this.
0
Sudheer Kumar11y ago
OracleConnection conn = new OracleConnection(oradb);
OracleCommand cmd = new OracleCommand();
conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.BindByName = true;

OracleParameter transdate1= new OracleParameter();
transdate1.OracleDbType = OracleDbType.Date;
transdate1.Value = TextBox1.Text;
transdate1.ParameterName = "transdate1";
cmd.Parameters.Add(transdate1);

OracleParameter transdate2 = new OracleParameter();
transdate2.OracleDbType = OracleDbType.Date;
transdate2.Value = TextBox2.Text;
transdate2.ParameterName = "transdate2";
cmd.Parameters.Add(transdate2);

cmd.CommandText = "select * from cust_details where transdate between :transdate1 and :transdate2";
OracleDataAdapter od = new OracleDataAdapter(cmd);
DataSet ds = new DataSet();
od.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();

for me for the same criteria it worked just check this once
0

Pavithra L11y ago

From Date:

To Date:

Order ID	Contact	Order Date	Shipping Date	Shipper	Freight	Phone

10248	Matti Karttunen	7/4/1996	7/16/1996	Federal Shipping	32.38	(503) 555-9931
10249	Anabela Domingues	7/5/1996	7/10/1996	Speedy Express	11.61	(503) 555-9831
10250	Mario Pontes	7/8/1996	7/12/1996	United Package	65.83	(503) 555-3199
10251	Mary Saveley	7/8/1996	7/15/1996	Speedy Express	41.34	(503) 555-9831
10252	Pascale Cartrain	7/9/1996	7/11/1996	United Package	51.3	(503) 555-3199
10253	Mario Pontes	7/10/1996	7/16/1996	United Package	58.17	(503) 555-3199
10254	Yang Wang	7/11/1996	7/23/1996	United Package	22.98	(503) 555-3199
10255	Michael Holz	7/12/1996	7/15/1996	Federal Shipping	148.33	(503) 555-9931
10256	Paula Parente	7/15/1996	7/17/1996	United Package	13.97	(503) 555-3199
10257	Carlos Hernández	7/16/1996	7/22/1996	Federal Shipping	81.91	(503) 555-9931
10258	Roland Mendel	7/17/1996	7/23/1996	Speedy Express	140.51	(503) 555-9831
10259	Francisco Chang	7/18/1996	7/25/1996	Federal Shipping	3.25	(503) 555-9931
10260	Rene Phillips	7/19/1996	7/29/1996	Speedy Express	55.09	(503) 555-9831
10261	Bernardo Batista	7/19/1996	7/30/1996	United Package	3.05	(503) 555-3199
10262	Paula Wilson	7/22/1996	7/25/1996	Federal Shipping	48.29	(503) 555-9931
10263	Roland Mendel	7/23/1996	7/31/1996	Federal Shipping	146.06	(503) 555-9931
10264	Maria Larsson	7/24/1996	8/23/1996	Federal Shipping	3.67	(503) 555-9931
10265	Frédérique Citeaux	7/25/1996	8/12/1996	Speedy Express	55.28	(503) 555-9831
10266	Pirkko Koskitalo	7/26/1996	7/31/1996	Federal Shipping	25.73	(503) 555-9931
10267	Peter Franken	7/29/1996	8/6/1996	Speedy Express	208.58	(503) 555-9831

this is an example for my question. How can I do this. It's urgent please reply me quickly.

Manas Mohapatra11y ago
// Search for people above a certain size.
DataRow[] result = dt.Select("Date1 >='02-01-2015' AND Date1 <='02-05-2015'");

foreach (DataRow row in result)
{
Console.WriteLine("{0}, {1}", row[0], row[1]);
}
Make sure that Date1 column is present in your datatable.
0
Pavithra L11y ago
I will tell you an example.
Here I can save data's from 01-01-2015 to 12-12-2015 these date's .Here in datatable I can save around 50 data's . In my report I can filter data's from 02-01-2015 this date to 02-05-2015 this date.
It can show only 20 data's . how can i do this.
0
Manas Mohapatra11y ago
What is your search filter condition so that we can add in select method().
0
Pavithra L11y ago
Hai Manas,

I am using your code but it doesn't filter the correct date data's . It can filter only the single date data's .
0
Manas Mohapatra11y ago
Try below option:

// Search for people above a certain size.
DataRow[] result = dt.Select("Date1 >='12-12-2015'");
foreach (DataRow row in result)
{
Console.WriteLine("{0}, {1}", row[0], row[1]);
}

Note: you need to change Select string as per your requirement.
0