//[1]그리드 바인딩 private void DisplayData() { //[1]ds DataSet ds = null; try { using (Is.Notice.Bsl.Notice_NTx nBsl = new Is.Notice.Bsl.Notice_NTx()) { //[2]Fill ds = SqlHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString, "UP_ListSCM_Sales", ""); if (ds.Tables[0].Rows.Count > 0) { //[3]Bind ctlNoticeList.DataSource = ds; ctlNoticeList.DataBind(); } else { lblError.Text = "공지사항이 없습니다"; } } } catch (Exception err) { //[4]Exception Response.Write(err.Source + " : " + err.Message); } }
//[1]그리드 바인딩 private void DisplayData() { //[1] DataSet ds = null; try { using (Is.Notice.Bsl.Notice_NTx bsl = new Is.Notice.Bsl.Notice_NTx()) { //[2]Fill //ds = bsl.ListNotice(); ds = SqlHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString, "UP_ListSCM_Sales", salesman1); if (ds.Tables[0].Rows.Count > 0) { //[3]Bind ctlNoticeList.DataSource = ds; ctlNoticeList.DataBind(); } else { //lblNoticeError.Text = "공지사항이 없습니다"; } } } catch (Exception err) { // } }
//[1]그리드 바인딩 private void DisplayData() { //[1] DataSet ds = null; try { using (Is.Notice.Bsl.Notice_NTx bsl = new Is.Notice.Bsl.Notice_NTx()) { //[2]Fill ds = bsl.ListNotice(); if (ds.Tables[0].Rows.Count > 0) { //[3]Bind ctlNoticeList.DataSource = ds; ctlNoticeList.DataBind(); } else { lblNoticeError.Text = "공지사항이 없습니다"; } } } catch (Exception err) { // } }
//[1]그리드 바인딩 private void DisplayData() { //[1]dataset DataSet ds = null; try { using (Is.Notice.Bsl.Notice_NTx bsl = new Is.Notice.Bsl.Notice_NTx()) { //[2]Fill //ds = bsl.SearchNotice(Request["Field"], Request["Query"]); ds = SqlHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings["ISDB"].ConnectionString, "UP_SearchSCM_Order", Request["Field"], Request["Query"]); if (ds.Tables[0].Rows.Count > 0) { //[3]Bind ctlNoticeList.DataSource = ds; ctlNoticeList.DataBind(); } else { lblError.Text = "검색결과가 없습니다"; } } } catch (Exception err) { //[4]예외 Response.Write(err.Source + " : " + err.Message); } }
//[1] private void DisplayData() { //[1]DataSet DataSet ds = null; //[2]stringbiulder StringBuilder strb = new StringBuilder(); try { using (Is.Notice.Bsl.Notice_NTx bsl = new Is.Notice.Bsl.Notice_NTx()) { //[3]Fill ds = bsl.MainNoticeList(); using (Is.Common.Method.CommonMethod cm = new Is.Common.Method.CommonMethod()) { //[4]데이타 추출 for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { strb.AppendFormat( "<tr><td align='left'>{0}.<a href='Notice/NoticeView.aspx?NoticeID={1}' class='no0'> {2}</a></td><td align='right'>{3}</td><td> </td></tr>", i + 1, Convert.ToInt32(ds.Tables[0].Rows[i]["NoticeID"]), cm.CutString(ds.Tables[0].Rows[i]["Title"].ToString()), FuncNew(Convert.ToDateTime(ds.Tables[0].Rows[i]["PostDate"]))); } } } //[5]바인딩 ltlNoticeList.Text = strb.ToString(); } catch (Exception err) { Response.Write(err.Source + " : " + err.Message); } }