protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
//get fuel types
FuelTypeBLL fuelTypeBll = new FuelTypeBLL();
DataTable dt = new DataTable();
dt = fuelTypeBll.GetFuelTypes();
//assign to the ddl
ddlFuelTypes.DataSource = dt;
ddlFuelTypes.DataTextField = "FuelTypeName";
ddlFuelTypes.DataValueField = "FuelTypeID";
ddlFuelTypes.DataBind();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
}
}
}
private void LoadList()
{
FuelTypeBLL fuelTypeBLL = new FuelTypeBLL();
// alt 1
gvTable.DataSource = fuelTypeBLL.GetFuelTypes();
gvTable.DataBind();
//alt 2
DataTable dt = fuelTypeBLL.GetFuelTypes();
string table = "<table id ='data-table'><tr><th>SN</th><th>Name</th><th></th></tr>";
int sn = 0;
foreach (DataRow dr in dt.Rows)
{
sn++;
table += "<tr><td>" + sn + "</td>" +
"<td><strong>" + dr["FuelTypeName"] + "</strong></td>" +
"<td><a href='FuleType.aspx?act=edit&id=" + dr["FuelTypeID"].ToString() + "'>Edit</a></td>" +
"<td><a href='FuleType.aspx?act=del&id=" + dr["FuelTypeID"].ToString() + "' onclick=\"return confirm('Do you want to delete?')\">Delete</a></td>" +
"</tr>";
}
table += "</table>";
lblTable.Text = table;
}
