public bool DeleteData(MAS_TEMPLATECOLNAME data) { Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US"); bool bRet = false; try { string strQuery = "DELETE FROM [dbo].[tb_mas_TemplateColName] WHERE TemplateNo = @TemplateNo "; SqlCommand command = new SqlCommand(strQuery, _conn); command.Parameters.AddWithValue("@TemplateNo", data.TemplateNo); command.ExecuteNonQuery(); bRet = true; } catch (SqlException sqlEx) { logger.Error(sqlEx); } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } return(bRet); }
private void GetItemTemplateNSetGridview(string TemplateNo) { MAS_TEMPLATECOLNAME value = new MAS_TEMPLATECOLNAME(); try { Int64 pkItemCol = Int64.Parse(TemplateNo); Mas_TemplateColName_Manage manage = new Mas_TemplateColName_Manage(); MAS_TEMPLATECOLNAME para = new MAS_TEMPLATECOLNAME(); para.TemplateNo = pkItemCol; value = manage.GetMasTemplateColNameByKey(para); ViewState["ColNameByPk"] = value; if (value != null && !string.IsNullOrWhiteSpace(value.TemplateNo.ToString())) { BindItemProjectData(value); } } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } }
public List <MAS_TEMPLATECOLNAME> ListTemplateName() { Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US"); List <MAS_TEMPLATECOLNAME> lRet = new List <MAS_TEMPLATECOLNAME>(); try { string strQuery = "SELECT DISTINCT TemplateNo,TemplateName FROM tb_mas_TemplateColName "; SqlCommand command = new SqlCommand(strQuery, _conn); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { MAS_TEMPLATECOLNAME data = new MAS_TEMPLATECOLNAME(); if (!DBNull.Value.Equals(reader["TemplateNo"])) { data.TemplateNo = (Int64)reader["TemplateNo"]; } if (!DBNull.Value.Equals(reader["TemplateName"])) { data.TemplateName = (string)reader["TemplateName"]; } lRet.Add(data); } } } catch (SqlException sqlEx) { logger.Error(sqlEx); } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } return(lRet); }
protected void gvListTemplate_RowDeleting(object sender, GridViewDeleteEventArgs e) { string pk = gvListTemplate.DataKeys[e.RowIndex].Value.ToString().Trim(); MAS_TEMPLATECOLNAME data = new MAS_TEMPLATECOLNAME(); data.TemplateNo = Int64.Parse(pk); Mas_TemplateColName_Manage manage = new Mas_TemplateColName_Manage(); bool bDel = manage.DeleteMasTemplateColName(data); if (bDel) { InitialControl(); } else { MessageUtil util = new MessageUtil(); util.MsgBox("ไม่สามารถลบข้อมูลได้!", this.Page, this); } }
public bool DeleteMasTemplateColName(MAS_TEMPLATECOLNAME data) { IDbConnection conn = null; bool ret = false; try { //SET CONNECTION conn = ConnectionFactory.GetConnection(); conn.ConnectionString = ConfigurationManager.GetConfiguration().DbConnectionString; //OPEN CONNECTION conn.Open(); Mas_TemplateColNameBL bl = new Mas_TemplateColNameBL(conn); ret = bl.DeleteData(data); } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } finally { if (conn != null) { if (conn.State == ConnectionState.Open) { conn.Close(); } conn.Dispose(); } } return(ret); }
public MAS_TEMPLATECOLNAME GetDataByKey(MAS_TEMPLATECOLNAME data) { Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US"); MAS_TEMPLATECOLNAME retData = new MAS_TEMPLATECOLNAME(); try { string strQuery = "SELECT * FROM [dbo].[tb_mas_TemplateColName] WHERE [TemplateNo] = @TemplateNo "; SqlCommand command = new SqlCommand(strQuery, _conn); command.Parameters.AddWithValue("@TemplateNo", data.TemplateNo); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { if (!DBNull.Value.Equals(reader["TemplateNo"])) { retData.TemplateNo = (Int64)reader["TemplateNo"]; } if (!DBNull.Value.Equals(reader["TemplateName"])) { retData.TemplateName = (string)reader["TemplateName"]; } if (!DBNull.Value.Equals(reader["ColumnName1"])) { retData.ColumnName1 = (string)reader["ColumnName1"]; } if (!DBNull.Value.Equals(reader["ColumnName2"])) { retData.ColumnName2 = (string)reader["ColumnName2"]; } if (!DBNull.Value.Equals(reader["ColumnName3"])) { retData.ColumnName3 = (string)reader["ColumnName3"]; } if (!DBNull.Value.Equals(reader["ColumnName4"])) { retData.ColumnName4 = (string)reader["ColumnName4"]; } if (!DBNull.Value.Equals(reader["ColumnName5"])) { retData.ColumnName5 = (string)reader["ColumnName5"]; } if (!DBNull.Value.Equals(reader["ColumnName6"])) { retData.ColumnName6 = (string)reader["ColumnName6"]; } if (!DBNull.Value.Equals(reader["ColumnName7"])) { retData.ColumnName7 = (string)reader["ColumnName7"]; } if (!DBNull.Value.Equals(reader["ColumnName8"])) { retData.ColumnName8 = (string)reader["ColumnName8"]; } } } } catch (SqlException sqlEx) { logger.Error(sqlEx); } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } return(retData); }
public bool InsertData(MAS_TEMPLATECOLNAME data) { Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US"); bool bRet = false; try { string strQuery = "INSERT INTO [dbo].[tb_mas_TemplateColName] " + "([TemplateName] " + ",[ColumnName1] " + ",[ColumnName2] " + ",[ColumnName3] " + ",[ColumnName4] " + ",[ColumnName5] " + ",[ColumnName6] " + ",[ColumnName7] " + ",[ColumnName8] " + ",[CreatedBy] " + ",[CreatedDate] " + ",[UpdatedBy] " + ",[UpdatedDate]) " + "VALUES " + "(@TemplateName " + ",@ColumnName1 " + ",@ColumnName2 " + ",@ColumnName3 " + ",@ColumnName4 " + ",@ColumnName5 " + ",@ColumnName6 " + ",@ColumnName7 " + ",@ColumnName8 " + ",@CreatedBy " + ",@CreatedDate " + ",@UpdatedBy " + ",@UpdatedDate)"; SqlCommand command = new SqlCommand(strQuery, _conn); command.Parameters.AddWithValue("@TemplateName", (string.IsNullOrWhiteSpace(data.TemplateName) ? "" : data.TemplateName)); command.Parameters.AddWithValue("@ColumnName1", (string.IsNullOrWhiteSpace(data.ColumnName1) ? "" : data.ColumnName1)); command.Parameters.AddWithValue("@ColumnName2", (string.IsNullOrWhiteSpace(data.ColumnName2) ? "" : data.ColumnName2)); command.Parameters.AddWithValue("@ColumnName3", (string.IsNullOrWhiteSpace(data.ColumnName3) ? "" : data.ColumnName3)); command.Parameters.AddWithValue("@ColumnName4", (string.IsNullOrWhiteSpace(data.ColumnName4) ? "" : data.ColumnName4)); command.Parameters.AddWithValue("@ColumnName5", (string.IsNullOrWhiteSpace(data.ColumnName5) ? "" : data.ColumnName5)); command.Parameters.AddWithValue("@ColumnName6", (string.IsNullOrWhiteSpace(data.ColumnName6) ? "" : data.ColumnName6)); command.Parameters.AddWithValue("@ColumnName7", (string.IsNullOrWhiteSpace(data.ColumnName7) ? "" : data.ColumnName7)); command.Parameters.AddWithValue("@ColumnName8", (string.IsNullOrWhiteSpace(data.ColumnName8) ? "" : data.ColumnName8)); command.Parameters.AddWithValue("@CreatedBy", (string.IsNullOrWhiteSpace(data.CreatedBy) ? "" : data.CreatedBy)); if (!string.IsNullOrEmpty(data.CreatedDate.ToString())) { DateTime dtNew = (DateTime)data.CreatedDate; string dateString = dtNew.ToString("MM/dd/yyyy HH:mm:ss"); command.Parameters.AddWithValue("@CreatedDate", dateString); } else { command.Parameters.AddWithValue("@CreatedDate", DateTime.Now); } command.Parameters.AddWithValue("@UpdatedBy", (string.IsNullOrWhiteSpace(data.UpdatedBy) ? "" : data.UpdatedBy)); if (!string.IsNullOrEmpty(data.UpdatedDate.ToString())) { DateTime dtNew = (DateTime)data.UpdatedDate; string dateString = dtNew.ToString("MM/dd/yyyy HH:mm:ss"); command.Parameters.AddWithValue("@UpdatedDate", dateString); } else { command.Parameters.AddWithValue("@UpdatedDate", DateTime.Now); } if (command.ExecuteNonQuery() == 1) { bRet = true; } } catch (SqlException sqlEx) { logger.Error(sqlEx); } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } return(bRet); }
private DataTable CreateTableItemColumn(MAS_TEMPLATECOLNAME colName) { /*********** For Create DataTable and Gridview Column ****************/ DataTable dtColName = null; dtColName = new DataTable(); dtColName.Clear(); dtColName.Columns.Add("ProjectItemNo", typeof(string)); dtColName.Columns.Add("ProjectNo", typeof(string)); /**************** Set Gridview Property ***************/ gvItem.Columns.Clear(); gvItem.AllowSorting = false; gvItem.AllowPaging = false; gvItem.ShowFooter = true; /******************************************************/ TemplateField tfield; if (!string.IsNullOrWhiteSpace(colName.ColumnName1)) { dtColName.Columns.Add("ItemColumn1", typeof(string)); tfield = new TemplateField(); tfield.HeaderText = colName.ColumnName1; tfield.ItemStyle.HorizontalAlign.Equals("Center"); tfield.ItemStyle.VerticalAlign.Equals("Middle"); gvItem.Columns.Add(tfield); } if (!string.IsNullOrWhiteSpace(colName.ColumnName2)) { dtColName.Columns.Add("ItemColumn2", typeof(string)); tfield = new TemplateField(); tfield.HeaderText = colName.ColumnName2; tfield.ItemStyle.HorizontalAlign.Equals("Center"); tfield.ItemStyle.VerticalAlign.Equals("Middle"); gvItem.Columns.Add(tfield); } if (!string.IsNullOrWhiteSpace(colName.ColumnName3)) { dtColName.Columns.Add("ItemColumn3", typeof(string)); tfield = new TemplateField(); tfield.HeaderText = colName.ColumnName3; tfield.ItemStyle.HorizontalAlign.Equals("Center"); tfield.ItemStyle.VerticalAlign.Equals("Middle"); gvItem.Columns.Add(tfield); } if (!string.IsNullOrWhiteSpace(colName.ColumnName4)) { dtColName.Columns.Add("ItemColumn4", typeof(string)); tfield = new TemplateField(); tfield.HeaderText = colName.ColumnName4; tfield.ItemStyle.HorizontalAlign.Equals("Center"); tfield.ItemStyle.VerticalAlign.Equals("Middle"); gvItem.Columns.Add(tfield); } if (!string.IsNullOrWhiteSpace(colName.ColumnName5)) { dtColName.Columns.Add("ItemColumn5", typeof(string)); tfield = new TemplateField(); tfield.HeaderText = colName.ColumnName5; tfield.ItemStyle.HorizontalAlign.Equals("Center"); tfield.ItemStyle.VerticalAlign.Equals("Middle"); gvItem.Columns.Add(tfield); } if (!string.IsNullOrWhiteSpace(colName.ColumnName6)) { dtColName.Columns.Add("ItemColumn6", typeof(string)); tfield = new TemplateField(); tfield.HeaderText = colName.ColumnName6; tfield.ItemStyle.HorizontalAlign.Equals("Center"); tfield.ItemStyle.VerticalAlign.Equals("Middle"); gvItem.Columns.Add(tfield); } if (!string.IsNullOrWhiteSpace(colName.ColumnName7)) { dtColName.Columns.Add("ItemColumn7", typeof(string)); tfield = new TemplateField(); tfield.HeaderText = colName.ColumnName7; tfield.ItemStyle.HorizontalAlign.Equals("Center"); tfield.ItemStyle.VerticalAlign.Equals("Middle"); gvItem.Columns.Add(tfield); } if (!string.IsNullOrWhiteSpace(colName.ColumnName8)) { dtColName.Columns.Add("ItemColumn8", typeof(string)); tfield = new TemplateField(); tfield.HeaderText = colName.ColumnName8; tfield.ItemStyle.HorizontalAlign.Equals("Center"); tfield.ItemStyle.VerticalAlign.Equals("Middle"); gvItem.Columns.Add(tfield); } return(dtColName); }
private void BindItemProject(string TemplateNo) { try { /******************* Get Column Item Project Name ********/ MAS_TEMPLATECOLNAME value = new MAS_TEMPLATECOLNAME(); Int64 pkItemCol = Int64.Parse(TemplateNo); Mas_TemplateColName_Manage manageCol = new Mas_TemplateColName_Manage(); MAS_TEMPLATECOLNAME para = new MAS_TEMPLATECOLNAME(); para.TemplateNo = pkItemCol; value = manageCol.GetMasTemplateColNameByKey(para); /*******************************************************/ /*************** Gen Table & Gridview Column **********/ DataTable dtColumnName = new DataTable(); dtColumnName = CreateTableItemColumn(value); /******************************************************/ /*************** List Item Project ********************************/ Mas_ProjectITemBidding_Manage projItemBL = new Mas_ProjectITemBidding_Manage(); List <MAS_PROJECTITEMBIDDING> lItemProj = new List <MAS_PROJECTITEMBIDDING>(); MAS_PROJECTITEMBIDDING sData = new MAS_PROJECTITEMBIDDING(); sData.ProjectNo = hdfProjectNo.Value.ToString().Trim(); lItemProj = projItemBL.ListMasProjItemBiddingByPNo(sData); /*****************************************************************/ DataRow row; foreach (MAS_PROJECTITEMBIDDING item in lItemProj) { row = dtColumnName.NewRow(); row["ProjectItemNo"] = item.ProjectItemNo; row["ProjectNo"] = item.ProjectNo; if (row.Table.Columns["ItemColumn1"] != null) { row["ItemColumn1"] = item.ItemColumn1; } if (row.Table.Columns["ItemColumn2"] != null) { row["ItemColumn2"] = item.ItemColumn2; } if (row.Table.Columns["ItemColumn3"] != null) { row["ItemColumn3"] = item.ItemColumn3; } if (row.Table.Columns["ItemColumn4"] != null) { row["ItemColumn4"] = item.ItemColumn4; } if (row.Table.Columns["ItemColumn5"] != null) { row["ItemColumn5"] = item.ItemColumn5; } if (row.Table.Columns["ItemColumn6"] != null) { row["ItemColumn6"] = item.ItemColumn6; } if (row.Table.Columns["ItemColumn7"] != null) { row["ItemColumn7"] = item.ItemColumn7; } if (row.Table.Columns["ItemColumn8"] != null) { row["ItemColumn8"] = item.ItemColumn8; } dtColumnName.Rows.Add(row); } /************ Set Empty Row ************/ if (dtColumnName.Rows.Count == 0) { dtColumnName = SetEmptyRows(dtColumnName); } /***************************************/ gvItem.DataSource = dtColumnName; gvItem.DataBind(); } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } }
protected void btnSave_Click(object sender, EventArgs e) { try { if (IsValid) { DataTable dt = (DataTable)Session["tbColumnName"]; if (dt != null && dt.Rows.Count > 0) { //=== Sort Column Grid ===== // DataTable dtSort = null; dt.DefaultView.Sort = "ColumnNo asc"; dtSort = dt.DefaultView.ToTable(); //===========================// MAS_TEMPLATECOLNAME data = new MAS_TEMPLATECOLNAME(); data.TemplateName = txtProjectName.Text.Trim(); data.ColumnName1 = dtSort.Rows.Count > 0 ? dtSort.Rows[0]["ColumnName"].ToString().Trim() : ""; data.ColumnName2 = dtSort.Rows.Count > 1 ? dtSort.Rows[1]["ColumnName"].ToString().Trim() : ""; data.ColumnName3 = dtSort.Rows.Count > 2 ? dtSort.Rows[2]["ColumnName"].ToString().Trim() : ""; data.ColumnName4 = dtSort.Rows.Count > 3 ? dtSort.Rows[3]["ColumnName"].ToString().Trim() : ""; data.ColumnName5 = dtSort.Rows.Count > 4 ? dtSort.Rows[4]["ColumnName"].ToString().Trim() : ""; data.ColumnName6 = dtSort.Rows.Count > 5 ? dtSort.Rows[5]["ColumnName"].ToString().Trim() : ""; data.ColumnName7 = dtSort.Rows.Count > 6 ? dtSort.Rows[6]["ColumnName"].ToString().Trim() : ""; data.ColumnName8 = dtSort.Rows.Count > 7 ? dtSort.Rows[7]["ColumnName"].ToString().Trim() : ""; data.CreatedBy = "System Admin"; data.CreatedDate = DateTime.Now; data.UpdatedBy = "System Admin"; data.UpdatedDate = DateTime.Now; Mas_TemplateColName_Manage ins = new Mas_TemplateColName_Manage(); bool bIns = ins.InsertMasTemplateColName(data); if (bIns) { MessageUtil util = new MessageUtil(); util.MsgBox("บันทึกข้อมูลสำเร็จ", this.Page, this); Response.Redirect("~/Form/ItemProjectList.aspx"); } else { MessageUtil util = new MessageUtil(); util.MsgBox("เกิดปัญหา ไม่สามารถบันทึกข้อมูลได้!", this.Page, this); } } else { MessageUtil util = new MessageUtil(); util.MsgBox("กรุณาระบุข้อมูล ลำดับและชื่อคอลัมน์", this.Page, this); return; } } else { return; } } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); MessageUtil util = new MessageUtil(); util.MsgBox("เกิดปัญหา ไม่สามารถบันทึกข้อมูลได้!", this.Page, this); } }
private void BindItemProject(string TemplateNo) { try { /******************* Get Column Item Project Name ********/ MAS_TEMPLATECOLNAME value = new MAS_TEMPLATECOLNAME(); Int64 pkItemCol = Int64.Parse(TemplateNo); Mas_TemplateColName_Manage manageCol = new Mas_TemplateColName_Manage(); MAS_TEMPLATECOLNAME para = new MAS_TEMPLATECOLNAME(); para.TemplateNo = pkItemCol; value = manageCol.GetMasTemplateColNameByKey(para); /*******************************************************/ /*************** Gen Table & Gridview Column **********/ DataTable dtColumnName = new DataTable(); dtColumnName = CreateTableItemColumn(value); ViewState["TemplateColName"] = dtColumnName; /******************************************************/ /*************** List Item Project ********************************/ Mas_ProjectITemBidding_Manage projItemBL = new Mas_ProjectITemBidding_Manage(); List <MAS_PROJECTITEMBIDDING> lItemProj = new List <MAS_PROJECTITEMBIDDING>(); string _biddingNo = hdfBiddingNo.Value; lItemProj = projItemBL.ListInfBiddingDetails(_biddingNo); /*****************************************************************/ DataRow row; string strComName = string.Empty; foreach (MAS_PROJECTITEMBIDDING item in lItemProj) { row = dtColumnName.NewRow(); //row["ProjectItemNo"] = item.ProjectItemNo; //row["ProjectNo"] = item.ProjectNo; if (row.Table.Columns["ItemColumn1"] != null) { row["ItemColumn1"] = item.ItemColumn1; } if (row.Table.Columns["ItemColumn2"] != null) { row["ItemColumn2"] = item.ItemColumn2; } if (row.Table.Columns["ItemColumn3"] != null) { row["ItemColumn3"] = item.ItemColumn3; } if (row.Table.Columns["ItemColumn4"] != null) { row["ItemColumn4"] = item.ItemColumn4; } if (row.Table.Columns["ItemColumn5"] != null) { row["ItemColumn5"] = item.ItemColumn5; } if (row.Table.Columns["ItemColumn6"] != null) { row["ItemColumn6"] = item.ItemColumn6; } if (row.Table.Columns["ItemColumn7"] != null) { row["ItemColumn7"] = item.ItemColumn7; } if (row.Table.Columns["ItemColumn8"] != null) { row["ItemColumn8"] = item.ItemColumn8; } strComName = item.ItemColumn1; dtColumnName.Rows.Add(row); } gvItem.DataSource = dtColumnName; gvItem.DataBind(); Session["BiddingDetailRPT"] = dtColumnName; } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } }
protected void gvListItem_RowCommand(object sender, GridViewCommandEventArgs e) { try { List <MAS_PROJECTITEMBIDDING> lRet = new List <MAS_PROJECTITEMBIDDING>(); lRet = (List <MAS_PROJECTITEMBIDDING>)ViewState["AddNewItem"]; if (e.CommandName.Equals("AddNew")) { MAS_PROJECTITEMBIDDING addItem = new MAS_PROJECTITEMBIDDING(); DropDownList ddlCompany = (DropDownList)gvListItem.FooterRow.FindControl("ddlCompany"); if (ddlCompany != null) { addItem.ItemColumn1 = ddlCompany.SelectedItem.Text; } TextBox TxtDetail = (TextBox)gvListItem.FooterRow.FindControl("TxtDetail"); if (TxtDetail != null) { addItem.ItemColumn2 = TxtDetail.Text; } TextBox TxtColumn2 = (TextBox)gvListItem.FooterRow.FindControl("TxtColumn2"); if (TxtColumn2 != null) { addItem.ItemColumn3 = TxtColumn2.Text; } TextBox TxtColumn3 = (TextBox)gvListItem.FooterRow.FindControl("TxtColumn3"); if (TxtColumn3 != null) { addItem.ItemColumn4 = TxtColumn3.Text; } TextBox TxtColumn4 = (TextBox)gvListItem.FooterRow.FindControl("TxtColumn4"); if (TxtColumn4 != null) { addItem.ItemColumn5 = TxtColumn4.Text; } TextBox TxtColumn5 = (TextBox)gvListItem.FooterRow.FindControl("TxtColumn5"); if (TxtColumn5 != null) { addItem.ItemColumn6 = TxtColumn5.Text; } TextBox TxtColumn6 = (TextBox)gvListItem.FooterRow.FindControl("TxtColumn6"); if (TxtColumn6 != null) { addItem.ItemColumn7 = TxtColumn6.Text; } TextBox TxtColumn7 = (TextBox)gvListItem.FooterRow.FindControl("TxtColumn7"); if (TxtColumn7 != null) { addItem.ItemColumn8 = TxtColumn7.Text; } lRet.Add(addItem); ViewState["AddNewItem"] = lRet; } else if (e.CommandName.Equals("Delete")) { GridViewRow gvr = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer); int RowIndex = gvr.RowIndex; lRet.RemoveAt(RowIndex); ViewState["AddNewItem"] = lRet; } MAS_TEMPLATECOLNAME vsColName = (MAS_TEMPLATECOLNAME)ViewState["ColNameByPk"]; BindItemProjectData(vsColName); } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } }
private void BindItemProjectData(MAS_TEMPLATECOLNAME ItemColName) { try { DataTable dtColumnName = new DataTable(); dtColumnName = CreateTableItemColumn(ItemColName); List <MAS_PROJECTITEMBIDDING> lItemRet = new List <MAS_PROJECTITEMBIDDING>(); lItemRet = (List <MAS_PROJECTITEMBIDDING>)ViewState["AddNewItem"]; if (lItemRet == null || lItemRet.Count == 0) { lItemRet = GetListItemProject(); ViewState["AddNewItem"] = lItemRet; } DataRow row; foreach (MAS_PROJECTITEMBIDDING item in lItemRet) { row = dtColumnName.NewRow(); row["ProjectItemNo"] = string.Empty; row["ProjectNo"] = string.Empty; if (row.Table.Columns["ItemColumn1"] != null) { row["ItemColumn1"] = item.ItemColumn1; } if (row.Table.Columns["ItemColumn2"] != null) { row["ItemColumn2"] = item.ItemColumn2; } if (row.Table.Columns["ItemColumn3"] != null) { row["ItemColumn3"] = item.ItemColumn3; } if (row.Table.Columns["ItemColumn4"] != null) { row["ItemColumn4"] = item.ItemColumn4; } if (row.Table.Columns["ItemColumn5"] != null) { row["ItemColumn5"] = item.ItemColumn5; } if (row.Table.Columns["ItemColumn6"] != null) { row["ItemColumn6"] = item.ItemColumn6; } if (row.Table.Columns["ItemColumn7"] != null) { row["ItemColumn7"] = item.ItemColumn7; } if (row.Table.Columns["ItemColumn8"] != null) { row["ItemColumn8"] = item.ItemColumn8; } dtColumnName.Rows.Add(row); } /************ Set Empty Row ************/ if (dtColumnName.Rows.Count == 0) { dtColumnName = SetEmptyRows(dtColumnName); } /***************************************/ gvListItem.DataSource = dtColumnName; gvListItem.DataBind(); gvListItem.ShowFooter = true; } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } }