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

[Solved] Dataset

3 Answers 157 Views

GridView

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

This question is locked. New answers and comments are not allowed.

3 Answers, 1 is accepted

answered on 09 Sep 2009, 01:38 PM

Hi Vlad,

My wcf service does the following:

im using the following dll's

using

Microsoft.Practices.EnterpriseLibrary.Data;

using

System.Data;

using

Silverlight.DataSetConnector;

    
            DbProviderFactory fact = DbProviderFactories.GetFactory(ProviderName);  
        
            Database database;  
        
            DbCommand dbCommand = null;  
        
            DataSet data = new DataSet();  
        
            string StringData = "";  
        
            database = Unilin.Data.EnterpriseLibrary.DatabaseFactory.CreateDatabase(ConnectionString, ProviderName);  
        
            dbCommand = database.GetSqlStringCommand("select * from persons);  
        
            database.LoadDataSet(dbCommand, data, "Persons");  
        
            StringData = Connector.ToXml(data);  
        
            if (dbCommand != null)  
        
                dbCommand.Dispose();  
        
            return StringData;

The code above goes and returns all the lines from the persons table and creates an xml string (dataset info) and sends it to the silverlight app.

In the silverlight app i call the service above (so i get the xml-string)
On the complete event a do the following code.

using

Silverlight;

    
            DataSet dataSet = new DataSet();  
        
            dataSet.FromXml(e.Result);  
        
            Connector connector = new Connector();  
        
            radgridItems.AutoGenerateColumns = true;  
        
            gridItems.ItemsSource = dataSet.Tables["Persons"].GetBindableData(connector);  
        
            radgridItems.ItemsSource = dataSet.Tables["Persons"].GetBindableData(connector);  gridItems.ItemsSource;

It casts the xml-string to a dataset and binds it to a radgrid and a standard datagrid.

The standard datagrid everything is autogenerated correctly.
In the radgrid it doesn't generate any columns but shows the correct number of rows.

Regards