// (1)
OleDbDataAdapter da = new OleDbDataAdapter(
"select * from jobs;select * from employee", //invalid OLE DB SQL ?
"provider=Microsoft.Jet.OLEDB.4.0;Data Source=C://pubs.mdb");
DataSet ds = new DataSet("AcmeJobs");
try
{
da.Fill(ds); // (2)
ds.Tables[0].TableName = "Jobs"; // (3)
ds.Tables[1].TableName = "EmpInJob";
ds.Relations.Add(ds.Tables["Jobs"].Columns["job_id"],
ds.Tables["EmpInJob"].Columns["job_id"]); // (4)
ds.Relations[0].Nested = true; // (5)
ds.Namespace = "urn:jobs-emps-com:xml-joblist-1"; // (6)
ds.WriteXmlSchema("c://jobsemps.xsd"); // (7)
// (8)
ds.WriteXml("c://jobsemps.xml",
XmlWriteMode.IgnoreSchema);
}
catch (OleDbException se)
{
// first exception only
listBox1.Items.Add("OLE DB Exception: " + se.Message);
}
catch (Exception ex)
{
// write message
listBox1.Items.Add("Exception: " + ex.Message);
}
}
Return multiple dataset
最新推荐文章于 2022-04-04 20:06:03 发布