creating a xml file and reading it and inserting into database

Creating xml file

Step1: create a function as below

void crete_xml()
{

/// creation of table
DataTable dt = new DataTable();
DataColumn gis1 = new DataColumn("gisno");
DataColumn appname = new DataColumn("appname");
DataColumn fname = new DataColumn("fname");
DataColumn age = new DataColumn("age");


///creation of collumns


dt.Columns.Add(gis1);
dt.Columns.Add(appname);
dt.Columns.Add(fname);
dt.Columns.Add(age);
dt.Columns.Add(prof);

//creation of rows

DataRow dr = dt.NewRow();

dr["gisno"] = lbl_GISno.Text;
dr["appname"] = txt_name.Text;
dr["fname"] = txt_Father.Text;
dr["age"] = txt_Age.Text;

//creating & deleting xml file in the given path


dt.Rows.Add(dr);
DataSet df = new DataSet();
df.Tables.Add(dt);
File.Delete(MapPath("my.xml"));
df.WriteXml(MapPath("my.xml"));


}

----paste this function in page load---


Reading tht xml file in the next aspx page and inserting in to data base


----------create function--------



void read_xml()
{
ds.ReadXml(MapPath("my.xml"));
if (ds.Tables[0].Rows.Count > 0)
{
lbl_GISno.Text = ds.Tables[0].Rows[0]["gisno"].ToString();
lbl_name.Text = ds.Tables[0].Rows[0]["appname"].ToString();
lbl_fname.Text = ds.Tables[0].Rows[0]["fname"].ToString();
lbl_age.Text = ds.Tables[0].Rows[0]["age"].ToString();

}

paste the function in page load

///inserting in to database

void InsertQuery()
{

con.ConnectionString = strConnstring;
con.Open();
SqlCommand cmd = new SqlCommand("InsertFMS", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter pr1 = new SqlParameter("@app_id", SqlDbType.VarChar);
pr1.Value = lbl_GISno.Text;
cmd.Parameters.Add(pr1);

SqlParameter pr2 = new SqlParameter("@Name", SqlDbType.VarChar);
pr2.Value = lbl_name.Text;
cmd.Parameters.Add(pr2);
//
SqlParameter prm_Father = new SqlParameter("@Father", SqlDbType.VarChar);
prm_Father.Value = lbl_fname.Text;
cmd.Parameters.Add(prm_Father);
SqlParameter prm_Age = new SqlParameter("@Age", SqlDbType.VarChar);
prm_Age.Value = lbl_age.Text;
cmd.Parameters.Add(prm_Age);
}

paste the function in pageload