อยากทราบวิธีการดึงข้อมูลใน sql2005 ที่เก็บข้อมูล type เป็น xml ครับ

//สมมติ xml string ที่ query มาแล้ว เราเก็บไว้ในตัวแปรที่ชื่อ xmlString นะ

System.IO.TextReader Tr = new System.IO.StringReader(xmlString);

DataSet Ds = new DataSet();
Ds.ReadXml(Tr);
DataTable Dt = Ds.Tables[0];

GridView1.DataSource = Dt;
GridView1.DataBind();

System.IO.TextWriter Wr = new System.IO.StringWriter();

Dt.WriteXml(Wr);

string xmlString = Wr.ToString();

public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {

        if (!IsPostBack)
        {
            BindGrid();
        }
    }
    private void BindGrid()
    {

        GridView1.DataSource = GetDataSource();
        GridView1.DataBind();
    }

    protected DataTable GetDataSource()
    {
        const string key = "MyDataSource";
        DataTable Dt = Session[key] as DataTable;
        informationDataContext z = new informationDataContext();
        DataSet Ds = new DataSet();
        if (Dt == null)
        {
        Dt = new DataTable();
        Ds = new DataSet();
        var query = from a in z.jubzs where  select a.xml;
        var xmlstring = from q in query select q.ToString();
        foreach (string h in xmlstring)
        {
            System.IO.TextReader Tr = new System.IO.StringReader(h);
            Ds.ReadXml(Tr);
        }
        Dt.Columns.Add("Name", typeof(string));
        Dt.Columns.Add("City", typeof(string));
        Dt.Columns.Add("Age", typeof(string));
        Dt = Ds.Tables[0];
        Session[key] = Dt;
        }
        return Dt;
    }
    protected void GridView1_RowEditing(object sender,GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex;
        BindGrid();
    }
    protected void GridView1_RowCancelingEdit(object sender,
    GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        BindGrid();
    }
    protected void GridView1_RowUpdating(object sender,
    GridViewUpdateEventArgs e)
    {

        TextBox cityty = GridView1.Rows[e.RowIndex].FindControl("txtCity") as TextBox;
        TextBox ageage = GridView1.Rows[e.RowIndex].FindControl("txtAge") as TextBox;
        string newcity  = cityty.Text;
        string newAge = ageage.Text;
        DataTable Dt = GetDataSource();
        Dt.Rows[e.RowIndex][1] = newcity;
        Dt.Rows[e.RowIndex][2] = newAge;
        GridView1.EditIndex = -1;
        BindGrid();
    }
}

    protected DataTable GetDataSource()
    {
        const string key = "MyDataSource";
        DataTable Dt = Session[key] as DataTable;
        informationDataContext z = new informationDataContext();
        DataSet Ds = new DataSet();
        if (Dt == null)
        {
        Dt = new DataTable();
        Ds = new DataSet();
        var query = from a in z.jubzs where  select a.xml;
        var xmlstring = from q in query select q.ToString();
        foreach (string h in xmlstring)
        {
            System.IO.TextReader Tr = new System.IO.StringReader(h);
            Ds.ReadXml(Tr);
        }
        Dt.Columns.Add("Name", typeof(string));
        Dt.Columns.Add("City", typeof(string));
        Dt.Columns.Add("Age", typeof(string));
        Dt = Ds.Tables[0];
        }

        DataColumn Dc = new DataColumn();
        Dc.ColumnName = "ID";
        Dc.DataType = System.Type.GetType("System.Int32");

        Dt.Columns.Add(Dc);

        foreach (DataRow Dr in Dt.Rows)
        { 
           Dr["ID"] = *** YourID ***
        }

        Session[key] = Dt;

        return Dt;
    }