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)
{
}
}
