将DateRead转化为DataSet

public DataSet GetAddTopicByUserId(int id) { SqlDataReader reader = null; DataSet ds = new DataSet(); DataTable tb = new DataTable(); DataColumn col; DataRow row; try { reader = DBHelper.ExecuteReader("PR_GetBBSTopicByUserId", new SqlParameter("@userid",id)); int i; for (i = 0; i < reader.FieldCount; i++) { col = new DataColumn(); col.ColumnName = reader.GetName(i); col.DataType = reader.GetFieldType(i); tb.Columns.Add(col); } while (reader.Read()) { row = tb.NewRow(); for (i = 0; i < reader.FieldCount; i++) { row[i] = reader[i]; } tb.Rows.Add(row); } ds.Tables.Add(tb); return ds; reader.Close(); } catch { reader.Close(); return null; } }