我们看到,表默认为Table,Table1,Table2,以此类推,显示给客户不太友好。如下图:
我们可以使用DataTableMaooing类来对DataTable对象与DataColumn对象进行一次友好的名称映射!
上述效果代码如下
public DataSet GetDataSet(string v_strConn)
{
SqlConnection conn = new SqlConnection(v_strConn);
string strSql = "Select * from tbClass;Select * from tbBoard";
//创建SqlDataAdapter对象
SqlDataAdapter da = new SqlDataAdapter(strSql, conn);
DataSet dt = new DataSet();
DataTableMapping dtmClass = da.TableMappings.Add("Table", "论坛分类表");
dtmClass.ColumnMappings.Add("ClassID", "分类ID");
dtmClass.ColumnMappings.Add("ClassName", "分类名");
DataTableMapping dtmBoard = da.TableMappings.Add("Table1", "论坛版块表");
dtmBoard.ColumnMappings.Add("BoardID", "版块ID");
dtmBoard.ColumnMappings.Add("BoardName", "版块名");
dtmBoard.ColumnMappings.Add("BoardClassID", "所属分类ID");
da.Fill(dt);
return dt;
}