VS. NET (C #) Database Interface C # DataTableMaooing class usage, vs.net
We can see that the default Table is Table, Table1, Table2, and so on. It is unfriendly to the customer. For example:
We can use the DataTableMaooing class to perform a friendly name ing between the DataTable object and the DataColumn object!
The code for the above effect is as follows:
Public DataSet GetDataSet (string v_strConn) {SqlConnection conn = new SqlConnection (v_strConn); string strSql = "Select * from tbClass; Select * from tbBoard "; // create the SqlDataAdapter object SqlDataAdapter da = new SqlDataAdapter (strSql, conn); DataSet dt = new DataSet (); DataTableMapping dtmClass = da. tableMappings. add ("Table", "Forum category Table"); dtmClass. columnMappings. add ("ClassID", "category ID"); dtmClass. columnMappings. add ("ClassName", "category name"); DataTableMapping dtmBoard = da. tableMappings. add ("Table1", "forum table"); dtmBoard. columnMappings. add ("BoardID", "Forum ID"); dtmBoard. columnMappings. add ("BoardName", "Forum name"); dtmBoard. columnMappings. add ("BoardClassID", "category ID"); da. fill (dt); return dt ;}