private void Button1_Click(object sender, System.EventArgs e)
{
DataSet ds = new DataSet();
SqlConnection conn = new SqlConnection("server=.;database=pubs;uid=sa;pwd=sa");
SqlDataAdapter sda = new SqlDataAdapter("select * from jobs",conn);
sda.Fill(ds);
ds.WriteXml(@"F:\\bb.xml");
DataView dv = new DataView(ds.Tables[0]);
DataGrid1.DataSource = dv;
DataGrid1.DataBind();
}
