Ryan,

Read the data into a Typed DataSet based on your .xsd. Then simply use the WriteXml() method of the DataSet.

string TestConnection = "server=(local);database=MyDataBase;uid=sa;pwd=MyPassword";
SqlDataAdapter da = new SqlDataAdapter("select * from bob", this.TestConnection);
MyDataSet ds = new MyDataSet();
da.Fill(ds, "MyTable");
ds.WriteXml("MyData.xml");

~~Bonnie



>Hi to All,
>
>
> how to export dbf file to xml data file i have a schema(xsd file) for the xml.
>
>TIA
>ryan.