getTableData 函數(shù)|顯示查詢數(shù)據(jù)

 public string getTableData(DataTable dt, string Model, params string[] columns)
       {

           System.Text.StringBuilder tempSb = new System.Text.StringBuilder("");
           if (dt != null)
           {
               foreach (DataRow dr in dt.Rows)
               {
                   string[] tempStr = new string[columns.Length];
                   for (int i = 0; i < tempStr.Length; i++)
                   {
                       tempStr[i] = Convert.ToString(dr[columns[i]]);
                   }

                   tempSb.AppendFormat(Model, tempStr);
               }
           }
           return tempSb.ToString();

       }
       /// <summary>
       /// 功能函數(shù)獲取沒(méi)有空值的函數(shù)
       /// </summary>
       /// <param name="str"></param>
       /// <returns></returns>
       public string GetNoNullString(string str)
       {
           str = string.IsNullOrEmpty(str) ? ("") : (str);
           return str;
       }