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(); } }