protected void LoadTable()
{
BL_Client oBL_Client = new BL_Client();
DataTable dt = oBL_Client.Select(null);
try
{
//display table
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
_str = _str + "<tr>" +
"<td>" + dt.Rows[i]["CLIENT_ID"].ToString() + "</td>" +
"<td>" + dt.Rows[i]["CLIENT_NAME"].ToString() + "</td>" +
"<td>" + dt.Rows[i]["CAR_NAME"].ToString() + "</td>" +
"<td>" + dt.Rows[i]["DATE"].ToString() + "</td>" +
"<td><a href='WebForm1.aspx?uid=" + dt.Rows[i]["CLIENT_ID"].ToString() + "'>edit</a></td>" +
"<td><a href='WebForm1.aspx?Dlt_uid=" + dt.Rows[i]["CLIENT_ID"].ToString() + "'>delete</a></td>" +
"</tr>";
}
}
}
catch (Exception ex)
{
Label1.Text = ex.Message.ToString();
}
}
protected void LoadTable()
{
BL_Client oBL_Client = new BL_Client();
DataTable dt = oBL_Client.Select(null);
try
{
//display table
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
_str = _str + "<tr>" +
"<td>" + dt.Rows[i]["APPOINTMENT_ID"].ToString() + "</td>" +
"<td>" + dt.Rows[i]["APPOINTMENT_NAME"].ToString() + "</td>" +
"<td>" + dt.Rows[i]["PARENT"].ToString() + "</td>" +
"<td>" + dt.Rows[i]["LIMIT_MONTH"].ToString() + "</td>" +
"<td>" + dt.Rows[i]["LIMIT_YEAR"].ToString() + "</td>" +
"<td>" + dt.Rows[i]["STATUS"].ToString() + "</td>" +
"<td>" + dt.Rows[i]["CREATED_BY"].ToString() + "</td>" +
"<td>" + dt.Rows[i]["CREATED_DATE"].ToString() + "</td>" +
"<td>" + dt.Rows[i]["MODIFIED_BY"].ToString() + "</td>" +
"<td>" + dt.Rows[i]["MODIFIED_DATE"].ToString() + "</td>" +
"<td><a href='AppointmentForm.aspx?ap_id=" + dt.Rows[i]["APPOINTMENT_ID"].ToString() + "'>edit</a></td>" +
"<td><a href='AppointmentForm.aspx?dlt_ap_id=" + dt.Rows[i]["APPOINTMENT_ID"].ToString() + "'>delete</a></td>" +
"</tr>";
}
}
}
catch (Exception ex)
{
Label5.Text = ex.Message.ToString();
}
}
