get data from dataset

[Sam]

I've created dataset using 'Add new Data source' - ShoppingMallDataSet
Then I what to get data from table TClient. So I've created global variable BindingSource bs and initialize it in method GetData

void GetData(){
using(ShoppingMallDataSet smds = new ShoppingMallDataSet())
            {
                using (var conn = new SqlConnection(connection_string))
                {
                    using (var adapter = new ShoppingMallDataSetTableAdapters.TClientTableAdapter() { Connection = conn })
                    {
                        adapter.Fill(smds.TClient);
                        bs.DataSource = smds.TClient;
                    }
                }
}

and here its using in code

.....
rgv.MasterTemplate.DataSource = bs;

GetData();

DataSource is not null but rgv has neither rows no columns. Where is the problem?

[Julian Benkov]

Hello Jei,

Thank you for writing.

I have tested the reported scenario and I did not find an issue with RadGridView binding to BindingSource component, which is loaded with data at the end. Here is an example:

using System.Data;
using System.Windows.Forms;
using Telerik.WinControls.UI;

namespace Lab.Grid
{
    public partial class GridBindToBindingSource : Form
    {
        private RadGridView gridView = new RadGridView();
        private BindingSource bindingSource = new BindingSource();

        public GridBindToBindingSource()
        {
            InitializeComponent();

            gridView.Dock = DockStyle.Fill;
            gridView.Parent = this;
            gridView.DataSource = this.bindingSource;

            DataTable table = new DataTable();
            table.Columns.Add("Id");
            table.Columns.Add("Name");

            for (int i = 0; i < 10; i++)
            {
                table.Rows.Add(i, "Name" + i);
            }

            this.bindingSource.DataSource = table;
        }
    }
}

Please refer to the attached screenshot, where you can see the result on my end. If you continue to experience the same issues, please send us some part of your data and a sample application that demonstrates the used loading mechanism to investigate the issues locally and find best solution for your application.  

Thank you for your time and cooperation. 

Greetings,
Julian Benkov
the Telerik team

[Sam]

                                                                                                                                                                                                                        I've solved the problem. There wasn't any colums or rows until I added RadGridView to controls. After that - on the next line debugger showed that columns count is correct.