This is a migrated thread and some comments may be shown as answers.

[Solved] Grid binding to xml/XDocument/XElement support

1 Answer 35 Views
Grid
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Chai Avisar
Top achievements
Rank 1
Chai Avisar asked on 16 Jan 2011, 04:18 PM
hello,

Is it possible some how to bind the Grid to  XML data source ?
If it is, what are the limitations ?

thanks,

Chai.

1 Answer, 1 is accepted

Sort by
0
chris
Top achievements
Rank 1
answered on 27 Jan 2011, 04:27 PM
This is how i do ...

client side:
void client_GetTableOfICSCompleted(object sender, ServiceReference1.GetTableOfICSCompletedEventArgs e)
{
    radGridView1.ItemsSource = GetPICSList(XDocument.Parse(e.Result));
}
 
 
public List<T_IC> GetPICSList(XDocument _traceXDocument)
{
 
    if (_traceXDocument == null)
        return null;
 
    try
    {
 
        List<T_IC> outputList = new List<T_IC>();
 
        foreach (XElement oneElement in _traceXDocument.Element("DataSet").Elements("T_IC"))
        {
 
            T_IC newTTI = new T_IC();
 
            newTTI.BSNSCD = oneElement.Element("BSNSCD").Value;
            newTTI.CTRYCD = oneElement.Element("CTRYCD").Value;
            newTTI.CHKDGT = oneElement.Element("CHKDGT").Value;
            newTTI.NTNLID = oneElement.Element("NTNLID").Value;
 
            outputList.Add(newTTI);
        }
 
        return outputList;
 
    }
    catch
    {
        return null;
    }
}

and wcf side :

public string GetTableOfICS()
{
    DataClassesDataContext dtclDC = new DataClassesDataContext();
    DbConnection conn = dtclDC.Connection;
    conn.Open();
 
    Table<T_IC> DT = dtclDC.GetTable<T_IC>();
 
    conn.Close();
    DataSet ds = new DataSet("DataSet");
    ds.Tables.Add(ToDataTable<T_IC>(DT));
    return ds.GetXml();
}

but I still looking for a better solution....
Tags
Grid
Asked by
Chai Avisar
Top achievements
Rank 1
Answers by
chris
Top achievements
Rank 1
Share this question
or