private string combineSelectQuery() { String strResult = null; int i = 0; foreach (DataRow dataRow in dataTable.Rows) { DataColumn filedColumn = dataTable.Columns[0]; DataColumn commentColumn = dataTable.Columns[1]; DataColumn whereFiledColumn = dataTable.Columns[2]; DataColumn operationedColumn = dataTable.Columns[3]; string seleted = dataRow[operationedColumn].ToString(); if (seleted.Equals("true", StringComparison.OrdinalIgnoreCase) == false) { continue; } if (dataRow[filedColumn].ToString() == null) { continue; } if (dataRow[commentColumn].ToString() == null) { dataRow[commentColumn] = ""; } string strAdd = " "; if (i != 0) { strAdd = " , "; } string filed = dataRow[filedColumn].ToString(); string comment = dataRow[commentColumn].ToString(); strResult += strAdd + makeQuery.makeSelectQuery(filed, comment); strResult += "\n"; i++; } return(strResult); }
private string combineSelectQuery() { String strResult = "SELECT \n"; int i = 0; foreach (DataRow dataRow in dataTable.Rows) { DataColumn dataColumn1 = dataTable.Columns[0]; DataColumn dataColumn2 = dataTable.Columns[1]; DataColumn dataColumn3 = dataTable.Columns[2]; if (dataRow[dataColumn1].ToString() == null) { //Console.WriteLine(dataRow[dataColumn1].ToString().Value); continue; } if (dataRow[dataColumn2].ToString() == null) { dataRow[dataColumn2] = ""; } string strAdd = " "; if (i != 0) { strAdd = " , "; } strResult += strAdd + makeQuery.makeSelectQuery( dataRow[dataColumn1].ToString(), dataRow[dataColumn2].ToString()); strResult += "\n"; i++; } return(strResult); }