DataSet.ReadXml()这样得到DataSet,剩下的处理就简单了.
解决方案 »
- asp用户名和密码(具体点)
- 使用WebClient下载遇到的问题
- 请教:如何上传图片到服务器指定路径
- xmlhttp刷新可以和DATAGRID一起使用吗?
- 有关点击Wed控件但网页不提交服务器的问题
- DataSet 中修改数据的问题!!!
- 求个大虾解决问题。。。。。。 江湖救急。江湖救急。江湖救急。江湖救急。江湖救急。江湖救急。
- 急,在线等候解决?我把创建的xml用dataset读出绑定到grdMain,我怎么新增,修改,删除啊?我这样做合理吗?
- 请教file field控件在网页刷新时服务器执行时间过长问题
- 在asp.net中怎样获得客户端网卡的MAC地址?????
- 简单问题,在线等!!
- 如何调整Crystal chart 位置,向上移 即上边距为0
能详细点吗??不是太看得懂啊
// Create a DataSet with one table and two columns.
DataSet OriginalDataSet = new DataSet("myDataSet");
OriginalDataSet.Namespace= "NetFrameWork";
DataTable myTable = new DataTable("myTable");
DataColumn c1 = new DataColumn("id", Type.GetType("System.Int32"));
c1.AutoIncrement= true;
DataColumn c2 = new DataColumn("item");
myTable.Columns.Add(c1);
myTable.Columns.Add(c2);
OriginalDataSet.Tables.Add(myTable);
// Add ten rows.
DataRow newRow;
for(int i = 0; i < 10; i++){
newRow = myTable.NewRow();
newRow["item"]= "item " + i;
myTable.Rows.Add(newRow);
}
OriginalDataSet.AcceptChanges();
// Print out values of each table in the DataSet using the
// function defined below.
PrintValues(OriginalDataSet, "Original DataSet");
// Write the schema and data to an XML file.
string xmlFilename = "myXmlDocument.xml";
// Use WriteXml to write the document.
OriginalDataSet.WriteXml(xmlFilename);
// Dispose of the original DataSet.
OriginalDataSet.Dispose();
// Create a new DataSet.
DataSet newDataSet = new DataSet("New DataSet");
// Read the XML document into the DataSet.
newDataSet.ReadXml(xmlFilename);
// Print out values of each table in the DataSet using the
// function defined below.
PrintValues(newDataSet,"New DataSet");
}private void PrintValues(DataSet ds, string label){
Console.WriteLine("\n" + label);
foreach(DataTable t in ds.Tables){
Console.WriteLine("TableName: " + t.TableName);
foreach(DataRow r in t.Rows){
foreach(DataColumn c in t.Columns){
Console.Write("\t " + r[c] );
}
Console.WriteLine();
}
}
}
SqlDataAdapter da=new SqlDataAdapter("select * from driverschool",conn);
DataSet ds=new DataSet("XmlProducts");
da.Fill(ds,"driverschool");
ds.WriteXml("d:\\driverschool.xml",XmlWriteMode.IgnoreSchema); DataGrid2.DataSource=ds;
DataGrid2.DataMember="driverschool";
DataGrid2.DataBind();
public DocTreeManager(string pubFilePath,string tableName)
{
if(File.Exists(pubFilePath+tableName+".xsd"))
{
ds=new DataSet();
ds.ReadXmlSchema(pubFilePath+tableName+".xsd");
ds.ReadXml(pubFilePath+tableName+".xml");
ds.AcceptChanges();
}
}