public void loaddata() { try { SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["Str"].ToString()); DataSet ds = new DataSet(); DataTable dt = new DataTable(); conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; SqlDataAdapter adp = new SqlDataAdapter(cmd); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_FMSReports_FuelVariance]"; conn.Close(); //ImageButton1.Enabled = true; cmd.Parameters.AddWithValue("@DistrictID", ddldistrict.SelectedItem.Value); cmd.Parameters.AddWithValue("@VehicleID", ddlvehicle.SelectedItem.Value); cmd.Parameters.AddWithValue("@From", txtfrmDate.Text + " 00:00:00"); cmd.Parameters.AddWithValue("@To", txttodate.Text + " 23:59:59"); cmd.Parameters.AddWithValue("@Bunk", txttodate.Text); adp.Fill(ds); dt = ds.Tables[0]; if (dt.Rows.Count > 0) { Grddetails.DataSource = dt; Grddetails.DataBind(); } else { Grddetails.DataSource = null; Grddetails.DataBind(); } } catch (Exception ex) { } }
public void loaddata() { try { SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["Str"].ToString()); DataSet ds = new DataSet(); DataTable dt = new DataTable(); conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; SqlDataAdapter adp = new SqlDataAdapter(cmd); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Report_VehicleHistoryReport]"; conn.Close(); //ImageButton1.Enabled = true; cmd.Parameters.AddWithValue("@district_id", ddldistrict.SelectedItem.Value); cmd.Parameters.AddWithValue("@VehID", ddlvehicle.SelectedItem.Value); cmd.Parameters.AddWithValue("@Month", ddlmonth.Text); cmd.Parameters.AddWithValue("@Year", ddlyear.Text); adp.Fill(ds); dt = ds.Tables[0]; if (dt.Rows.Count > 0) { Grddetails.DataSource = dt; Grddetails.DataBind(); } else { Grddetails.DataSource = null; Grddetails.DataBind(); } } catch (Exception ex) { } }