Linq fans, anyone how-to bind at design-time

385

Robert posted over 15 years ago

I'm a big fan of Linq, and use it a lot because I like its ability to code against in a natural c# kind of way. One thing I don't like, however, and maybe this is just me being thick or stupid, but I haven't found a way to specify it as the data-source at design time for the purpose of customizing my column appearances etc. Anybody else tackled this with more success than myself? I found I could specify the linq to sql class in "add Project Data Source" (in the context menu for the grid), but this resulted in a grid based on the internal class metadata, not the table columns. Thx, Bob Graham

385

Robert posted over 15 years ago in reply to Amiram Korach

Yes, I understand now... I still don't think object-oriented enough sometimes, or these concepts would fall into place without so much digging! Thanks
Cancel
Reply

Cancel
17259

Offline Amiram Korach posted over 15 years ago in reply to Robert

You can also drag a BindingSource from the toolbox and do the same steps for the BindingSource. After that you can select the BindingSource as the data source of the grid.
Cancel
Reply

Cancel
17259

Verified Answer
Offline Amiram Korach posted over 15 years ago in reply to Robert

You don't have to use dataset.

1. In the grid properties, drop down "DataSource".

2. Click on "Add Project Data Source...".

3. Select "Object".

4. Find your data object type. You have to make a reference to where it is defined and build before.

5. After you finished the wizard you should see the BindingSource in the bottom of your designer.
Cancel
Reply

Reject Answer

Cancel
385

Robert posted over 15 years ago in reply to Amiram Korach

Amiram Korach said:
I get a binding source in my form
This is the part I'm not getting... I've pulled a stupid on getting any design time object onto my form designer that the grid can pull an editable layout from. I have used datasets to pull a schema at design time and then substituted the Linq-generated data at run time, but this seems like a kludge.
Cancel
Reply

Cancel
17259

Offline Amiram Korach posted over 15 years ago

I use Linq to Sql and UltraGrid a lot. I do just as you said. I add a project data source and I get a binding source in my form. Ofcourse, this won't put the data itself on the grid when you run the app, but this is how any object data source work.

In your form, use the load event to load data and put it in BindingSource.DataSource.
Cancel
Reply

Cancel