example of Inserting and Retrieving data from xml file -- dotnet ado.net

Cowboy (Gregory A. Beamer)
9/27/2007 8:45:40 AM

Good example of using an XSD to save off data as a file and use it again to
bind to a grid. As we move into LINQ, you will find that there are other
options for XML, however.

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

*************************************************
| Think outside the box!
|
*************************************************
[quoted text, click to view]

hanusoft
9/27/2007 12:49:31 PM

This is an example of Inserting and Retrieving data from xml file.

http://www.hanusoftware.com

private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here

if(!IsPostBack)
{
BindGrid();
}
}

private void BindGrid()
{
ds = new DataSet();
try
{
ds.ReadXml(@"c:\inetpub\wwwroot\WebApplication10\XMLFile1.xml");
DataGrid1.DataSource = ds;
DataGrid1.DataBind();
}
catch(Exception ex)
{
throw ex;
}
}

private void Button1_Click(object sender, System.EventArgs e)
{
ds = new DataSet();
try
{
ds.ReadXml(@"c:\inetpub\wwwroot\WebApplication10\XMLFile1.xml");
DataRow row = ds.Tables[0].NewRow();
row["name"]=txtName.Text;
row["fathersname"]=txtFName.Text;
row["address"]=txtAddress.Text;
ds.Tables[0].Rows.Add(row);
ds.WriteXml(@"c:\inetpub\wwwroot\WebApplication10\XMLFile1.xml");
txtAddress.Text="";
txtFName.Text="";
txtName.Text ="";
BindGrid();
}
catch(Exception ex)
{
throw ex;
}

[url=http://www.hanusoftware.com] Software Development Company [/url]

--
Message posted via DotNetMonster.com
http://www.dotnetmonster.com/Uwe/Forums.aspx/dotnet-ado-net/200709/1

dotnet ado.net : example of Inserting and Retrieving data from xml file