/// <summary> /// This method is used to get the columnList for exporting the parameters to datasource /// </summary> /// <returns></returns> private string GetColumnNameListForTableCreation(DataTable dt) { string cols = string.Empty; try { StringBuilder colList = new StringBuilder(); colList.Append(mDSDetails.AddNewCustomizedTableQuery() + ","); foreach (DataColumn col in dt.Columns) { if (col.ColumnName == "GINGER_ID" || col.ColumnName == "GINGER_USED" || col.ColumnName == "GINGER_LAST_UPDATED_BY" || col.ColumnName == "GINGER_LAST_UPDATE_DATETIME") { continue; } colList.Append(mDSDetails.AddColumnName(col.ColumnName)); } cols = colList.ToString().Remove(colList.ToString().LastIndexOf(","), 1); } catch (System.Exception ex) { Reporter.ToLog(eLogLevel.ERROR, ex.StackTrace); } return(cols); }