Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
hanusoft
Starting Member
2 Posts |
Posted - 2007-10-03 : 07:38:20
|
This is an example of Inserting and Retrieving data from xml file. http://www.hanusoftware.comprivate 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][url="http://www.hanusoftware.com"]Software Development Company [/url] |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-10-03 : 07:40:02
|
quote: Originally posted by hanusoft
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; }
E 12°55'05.25"N 56°04'39.16" |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-10-03 : 07:42:33
|
Thanks Peter for that formatting.Otherwise it was eligible candidate for "International Obfuscated C# Code Contest"Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
|
|