DataSet ds = new DataSet(); DataSet ds1 = new DataSet(); DataTable dt = new DataTable("books"); ds.ReadXml(Server.MapPath("books.xml")); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string bid = Convert.ToString(ds.Tables[0].Rows[i]["bid"].ToString()); if (Convert.ToString(TextBox1.Text.ToLower()) == bid.ToLower()) { int col = ds.Tables[0].Columns.Count; ds1.Tables.Add(dt); dr = ds1.Tables["books"].NewRow(); for (int j = 0; j < col; j++) { string colname = ds.Tables[0].Columns[j].ColumnName.ToString(); dt.Columns.Add(colname, typeof(string)); dr[colname] = Convert.ToString(ds.Tables[0].Rows[i][colname].ToString()); } dt.Rows.Add(dr); XmlDataDocument doc = new XmlDataDocument(ds1); XslCompiledTransform transform = new XslCompiledTransform(); transform.Load(Server.MapPath("xsl1.xsl")); XmlTextWriter writer = new XmlTextWriter(Server.MapPath("mybooks.xml"), Encoding.UTF8); writer.Formatting = Formatting.Indented; writer.Indentation = 4; transform.Transform(doc, null, writer); } }