create xml file from a datasetThis code snippet show how to export DataSet to xml file.Here we have taken data from database and fill dataset.We have taken a aspx page and a button there,after clicking the button a xml file will be created at specified location. public void CreateXml() { DataSet ds = new DataSet(); SqlDataAdapter da...
Tuesday, December 6, 2011
Monday, December 5, 2011
Insert XML data into SQL Server 2008
protected void Button1_Click(object sender, EventArgs e)
{
string EmpCode = null;
string City = null;
string State = null;
string Country = null;
string str = null;
SqlConnection con = new SqlConnection("Data Source=localhost;Initial Catalog=Test;Integrated Security=True");
...
