Revision: 48826
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at July 11, 2011 06:44 by tabook22
Initial Code
'Method Creating Xml File if does'nt Exists
Private Sub createxml()
Dim tb As New DataTable("emptable")
tb.Columns.Add("eno", Type.[GetType]("System.Int32"))
tb.Columns.Add("ename", Type.[GetType]("System.String"))
tb.Columns.Add("eadd", Type.[GetType]("System.String"))
tb.Columns.Add("esal", Type.[GetType]("System.Int32"))
Dim r As DataRow = tb.NewRow()
r(0) = 1
r(1) = "Rahul Choudhary"
r(2) = "Chandigarh"
r(3) = 12000
tb.Rows.Add(r)
Dim st As [String] = Server.MapPath("emp.xml")
tb.WriteXml(st)
End Sub
'Method to bind Grid view
Private Sub getxml()
Dim st As [String] = Server.MapPath("emp.xml")
Dim ds As New DataSet()
ds.ReadXml(st)
GridView1.DataSource = ds
GridView1.DataBind()
End Sub
'Grid View Event to Save Data into Xml File
Protected Sub GridView1_RowCommand(sender As Object, e As GridViewCommandEventArgs)
If e.CommandName = "save" Then
Dim st As [String] = Server.MapPath("emp.xml")
Dim ds As New DataSet()
ds.ReadXml(st)
Dim r As DataRow = ds.Tables(0).NewRow()
r(0) = Convert.ToInt32(DirectCast(GridView1.FooterRow.FindControl("TextBox1"), TextBox).Text)
r(1) = DirectCast(GridView1.FooterRow.FindControl("TextBox3"), TextBox).Text
r(2) = DirectCast(GridView1.FooterRow.FindControl("TextBox5"), TextBox).Text
r(3) = Convert.ToInt32(DirectCast(GridView1.FooterRow.FindControl("TextBox7"), TextBox).Text)
ds.Tables(0).Rows.Add(r)
ds.WriteXml(st)
getxml()
End If
End Sub
'Grid View Row Deleting Event to Delete From Xml File
Protected Sub GridView1_RowDeleting(sender As Object, e As GridViewDeleteEventArgs)
Dim st As [String] = Server.MapPath("emp.xml")
Dim ds As New DataSet()
ds.ReadXml(st)
ds.Tables(0).Rows.RemoveAt(e.RowIndex)
ds.WriteXml(st)
getxml()
End Sub
Protected Sub GridView1_RowEditing(sender As Object, e As GridViewEditEventArgs)
GridView1.EditIndex = e.NewEditIndex
getxml()
End Sub
Protected Sub GridView1_RowCancelingEdit(sender As Object, e As GridViewCancelEditEventArgs)
GridView1.EditIndex = -1
getxml()
End Sub
'Grid View row Updating Event to update xml file
Protected Sub GridView1_RowUpdating(sender As Object, e As GridViewUpdateEventArgs)
Dim st As [String] = Server.MapPath("emp.xml")
Dim ds As New DataSet()
ds.ReadXml(st)
ds.Tables(0).Rows(e.RowIndex)(1) = DirectCast(GridView1.Rows(e.RowIndex).FindControl("TextBox2"), TextBox).Text
ds.Tables(0).Rows(e.RowIndex)(2) = DirectCast(GridView1.Rows(e.RowIndex).FindControl("TextBox4"), TextBox).Text
ds.Tables(0).Rows(e.RowIndex)(3) = Convert.ToInt32(DirectCast(GridView1.Rows(e.RowIndex).FindControl("TextBox6"), TextBox).Text)
GridView1.EditIndex = -1
ds.WriteXml(st)
getxml()
End Sub
Initial URL
Initial Description
This code will be used to bind an xml file to gridview
Initial Title
Binding xml file to Gridview
Initial Tags
xml, aspnet
Initial Language
VB.NET