search between two dates .....

Question

plz write csharp query ..

seach between two dates

in acess db have date field like "03/04/2015 1:38:52 PM"

04/05/2015 1:38:52 PM

how to retrive data between two dates .................

below query is not search the records ................

SELECT * from tablename where coloum_name between #" + dtpInvoiceDateFrom.Text + "# And #" + dtpInvoiceDateTo.Text + "#

Pankaj Kumar Choudhary · Answer

hello @Vinay you can sue this code: protected void Button1_Click(object sender EventArgs e) { Label2.Text = ; SqlConnection con = new SqlConnection(DataBase.connect); SqlDataAdapter da = new SqlDataAdapter(select * from Stud_Info where Entry_Date Between ' + dateTimePicker1.Value.ToString() + ' and ' + dateTimePicker2.Value.ToString()+ ' con); SqlCommandBuilder cm = new SqlCommandBuilder(da); DataSet ds = new DataSet(); da.Fill(ds Stud_Info); if (ds.Tables[Stud_Info].Rows.Count > 0) { Label3.Text = Student Informations; GridView1.DataSource = ds.Tables[Stud_Info]; GridView1.DataBind(); } else Label2.Text = Record Not found ; }

g s · Answer

Date Assign To Label dbcon(); OleDbCommand cmd = new OleDbCommand(select * from student where studentdate between  + (label7.Text) +  and  + (label4.Text) +  con); OleDbDataAdapter adp = new OleDbDataAdapter(cmd); DataTable dt = new DataTable(); adp.Fill(dt); OleDbDataReader rd = cmd.ExecuteReader(); if (rd.Read()) { dataGridView1.Visible = true; dataGridView1.DataSource = dt; }

VINAY KUMAR · Answer

ur code not working for ms acess database its woking only sql database Thanks for replay ... i am using not textbox using datetimepicker ...........Maacess database

Ankur Jain · Answer

using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class entrydate : System.Web.UI.Page { protected void Page_Load(object sender EventArgs e) { } protected void Button1_Click(object sender EventArgs e) { Label2.Text = ; SqlConnection con = new SqlConnection(DataBase.connect); SqlDataAdapter da = new SqlDataAdapter(select * from Stud_Info where Entry_Date Between ' + TextBox1.Text + ' and ' + TextBox2.Text + ' con); SqlCommandBuilder cm = new SqlCommandBuilder(da); DataSet ds = new DataSet(); da.Fill(ds Stud_Info); if (ds.Tables[Stud_Info].Rows.Count > 0) { Label3.Text = Student Informations; GridView1.DataSource = ds.Tables[Stud_Info]; GridView1.DataBind(); } else Label2.Text = Record Not found ; } protected void GridView1_SelectedIndexChanged(object sender EventArgs e) { } }

Rajeesh Menoth · Answer

Check this.. 1) http://stackoverflow.com/questions/22976492/how-to-select-data-between-two-date-ranges-using-datepicker-c-sharp 2) http://www.codeproject.com/Questions/700097/Show-data-between-two-dates