使用vb.net将数据网格转换为xml文件 [英] data grid to xml file using vb.net
本文介绍了使用vb.net将数据网格转换为xml文件的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
datagrid中的数据应保存在单独的文件中.
该文件必须显示用户在数据网格中输入的每日数据
使用此代码,xml文件中的数据将覆盖旧文件并仅显示新文件.
请帮帮我.
data in datagrid should be saved in separate file.
the file must show daily data where user entered in data grid
with this code the data in xml file is overwriting the old one and showing only new file.
please help me.
Public Sub SwipeDTBind(ByVal EmplId As String)
Try
Dim ds As DataSet
ds = New DataSet
ds.Clear()
ds.ReadXml("EmployeeTimeCard_1.XML")
Dim dtbl As DataTable = ds.Tables(0)
ds.Tables(0).DefaultView.Sort = "EmployeeId DESC"
Dim dv As DataView = New DataView(dtbl)
dv.RowFilter = "EmployeeId = '" & EmplId & "'"
dv.Sort = "LoginTime"
dtbl.Columns(0).ColumnMapping = MappingType.Hidden
dtbl.Columns(1).ColumnMapping = MappingType.Hidden
ds.WriteXml("E:\Syscom\EmployeeTimeCard\EmployeeTimeCard_1.XML", XmlWriteMode.IgnoreSchema)
dgSwipedt.DataSource = dv
Catch ex As Exception
Me.ErrorLog(ex.Message.ToString())
End Try
End Sub
推荐答案
如果要使用单独的文件,请指定单独的文件名.
If you want that is separate file then specify separate file name.
ds.WriteXml("E:\Syscom\EmployeeTimeCard\EmployeeTimeCard_" & Now.ToString("ddMMyyyyHHmmss") & ".XML", XmlWriteMode.IgnoreSchema)
这篇关于使用vb.net将数据网格转换为xml文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文