protected void filter_ServerClick(object sender, EventArgs e) { DateTime startdate = Convert.ToDateTime(TextBox1.Text); DateTime enddate = Convert.ToDateTime(TextBox2.Text); Jobhistory dates = new Jobhistory(); dates = dates.selectbydate(startdate, enddate); string names = dates.TOURNAME; }
public Jobhistory RetrieveBookingdetailsbyDate(DateTime startdate, DateTime enddate) { string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString; SqlConnection myConn = new SqlConnection(DBConnect); //Step 2 - Create a DataAdapter to retrieve data from the database table string sqlStmt = "Select * from BookingHistory where TourDate BETWEEN @parastart AND @paraend"; SqlDataAdapter da = new SqlDataAdapter(sqlStmt, myConn); da.SelectCommand.Parameters.AddWithValue("@parastart", startdate); da.SelectCommand.Parameters.AddWithValue("@paraend", enddate); //Step 3 - Create a DataSet to store the data to be retrieved DataSet ds = new DataSet(); //Step 4 - Use the DataAdapter to fill the DataSet with data retrieved da.Fill(ds); //Step 5 - Read data from DataSet to List Jobhistory T = null; int rec_cnt = ds.Tables[0].Rows.Count; if (rec_cnt == 1) { DataRow row = ds.Tables[0].Rows[0]; string Tourname = row["TourName"].ToString(); DateTime Tourdate = Convert.ToDateTime(row["TourDate"]); DateTime Starttime = Convert.ToDateTime(row["StartTime"]); DateTime Endtime = Convert.ToDateTime(row["EndTime"]); string Custname = row["CustName"].ToString(); T = new Jobhistory(Tourname, Tourdate, Starttime, Endtime, Custname); } else { T = null; } return(T); }