如何利用DataSet读取xml中指定的行内容呢?
一、在页面中,我如此读去一个XML文件的内容
String strXmlFile = "";
strXmlFile = Server.MapPath("users.xml");
DataSet objDataSet = new DataSet();
objDataSet.ReadXml(strXmlFile);
dgUserinfo.DataSource = objDataSet.Tables[0].DefaultView;
dgUserinfo.DataBind();那我想读取指定的行或是列的内容,该如何去做?本人比较菜,希望高手指教!
一定给分,谢谢!
二、
1
DataSet guestData = new DataSet();
2
FileStream fin ;
3
fin = new FileStream(Server.MapPath(datafile),FileMode.Open, FileAccess.Read,FileShare.ReadWrite) ;
4
guestData.ReadXml(fin);
5
fin.Close();
6
DataTable customerTable = guestData.Tables[0];
7
DataView dv=new DataView(customerTable,"","otime DESC",DataViewRowState.CurrentRows);
8
dv.RowFilter = "ID<"+inta;
9
MyDataList.DataSource = dv;
10
MyDataList.DataBind();
11
三、
DataSet guestData = new DataSet();2
FileStream fin ;3
fin = new FileStream(Server.MapPath(datafile),FileMode.Open, FileAccess.Read,FileShare.ReadWrite) ; 4
guestData.ReadXml(fin);5
fin.Close();6
DataTable customerTable = guestData.Tables[0];7
DataView dv=new DataView(customerTable,"","otime DESC",DataViewRowState.CurrentRows);8
dv.RowFilter = "ID<"+inta;9
MyDataList.DataSource = dv;10
MyDataList.DataBind();11

1
//

2
DataSet ds = new DataSet();
3
ds.ReadXml(Server.MapPath("users.xml"),XmlReadMode.Auto);
4
DataTable dt = ds.Tables["user"];//表名要根据具体的xml文件该,user只是推测
5
string s=Convert.ToString(dr.Rows[rowid]["cloname"]);//取出rowid行,列名为colname行的值,转化成什么值你自己说了算!
6
DataRow dr = dt.Rows[rowid]//取出第rowid行
7
//

8
//

2
DataSet ds = new DataSet();3
ds.ReadXml(Server.MapPath("users.xml"),XmlReadMode.Auto);4
DataTable dt = ds.Tables["user"];//表名要根据具体的xml文件该,user只是推测5
string s=Convert.ToString(dr.Rows[rowid]["cloname"]);//取出rowid行,列名为colname行的值,转化成什么值你自己说了算!6
DataRow dr = dt.Rows[rowid]//取出第rowid行7
//

8


浙公网安备 33010602011771号