private void BindGrid2() { string iSql = "exec [spGetCFSSuite] "; try { GridViewSelectTenant.DataSource = Db.get_list(iSql); GridViewSelectTenant.DataBind(); } catch (SqlException ex) { showMessageModal(eMessage.eError, "BindGrid2- SqlExeption", ex.Message); } catch (Exception ex) { showMessageModal(eMessage.eError, "BindGrid2", ex.Message); } }
private void BindGrid2() { //string iSql = "select id, CID+'-'+CodeLob+'-'+CodePropertyName+'-'+CodeSeqNo+'-'+CodeYear+CodeMonth as CID, name, address, city, phone, PIC1Name from mCFS where status = 1 order by name"; string iSql = "exec[spGetCFS]"; try { GridViewSelectTenant.DataSource = Db.get_list(iSql); GridViewSelectTenant.DataBind(); } catch (SqlException ex) { showMessage(eMessage.eError, "BindGrid2- SqlExeption", ex.Message); } catch (Exception ex) { showMessage(eMessage.eError, "BindGrid2", ex.Message); } }