学步园

/// <summary>
    /// 跟据查询语句集合升成一个DataTable对象
    /// </summary>
    /// <param name="selectSqls">查询语句集合</param>
    /// <returns>查询结果</returns>
    public static DataTable GetDataForSqls(System.Collections.Generic.List<string> selectSqls) {
        using (SqlConnection conn = new SqlConnection(connectionString))
        {
            conn.Open();
            try
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = conn;
                cmd.CommandType = CommandType.Text;
                DataTable dt = new DataTable("wwmTable");
                foreach (string selectSql in selectSqls)
                {
                    cmd.CommandText = selectSql;
                    SqlDataReader sdr = cmd.ExecuteReader();
                    while (sdr.Read())
                    {
                        for (int i = 0; i < sdr.FieldCount; i++){
                            string columnName = sdr.GetName(i);
                            if (dt.Columns.Contains(columnName)) continue;
                            dt.Columns.Add(columnName, sdr.GetFieldType(i));
                        }
                        DataRow dr = dt.NewRow();
                        for (int i = 0; i < sdr.FieldCount; i++)
                        {
                            string columnName = sdr.GetName(i);
                            dr[columnName] = sdr[i];
                        }

                        dt.Rows.Add(dr);
                    }
                    sdr.Dispose();
                }

                return dt;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally { 
                if (conn.State == ConnectionState.Open) conn.Close();
            }
        }
    }