LINQ to SQL Windows Form Binding Data Step by Step

LINQ to SQL Windows Form Binding Data Step by Step

  • Comments 11

LINQ to SQL designer in Visual Studio allows us to create mapped class using the drag and drop feature from Server Explorer. Now that is business object which ideally you could use as your datasource and from Visual Studio 2008. So let us have this step by step,

Open your Visual Studio 2008 and create a new Windows Forms application (assume C#).

Now add new item to the project LINQ to SQL (.dbml). Give name NW.dbml.

Open a new Data Connection from your VS 2008’s Server Explorer window.

Point to Northwind database. Drag and drop Customers and Orders table. Since Customer and Order table has one to many relationship the designer will get generated like below,

Dbml_thumb4

Now open a data source from Data menu of your VS 2008. Click on add new Datasource. Add object DataSource.

image

Now click on next, choose Customer.

image

Click next and finish.

Now your datasource window will show both Customer and Order because they are connected through PK/FK.

image

Make Customer as details view

image

Drag Customer to your Windows Forms. Then all the navigator and grid will be created as the RAD (Rapid Application Development).

Now you also drag and drop Orders (this will create DataGrid). Now a add the code to your form_load event.

private void Form1_Load(object sender, EventArgs e)

{

NWDataContext db = new NWDataContext();

this.customerBindingSource.DataSource = db.Customers;

}

 

That's all.

Final look,

image

Namoskar!!!

Leave a Comment
  • Please add 2 and 7 and type the answer here:
  • Post
  • LINQ to SQL designer in Visual Studio allows us to create mapped class using the drag and drop feature

  • Welcome to the thirty-fifth edition of Community Convergence. This week we have an interview with C#

  • hi,

    This is apprent so easy, but as RAD helps us to develop rapidly we need to face problem regarding to customize according to our own choice. So, can you address few links or article where i will get the same type of sample which emphasis on manul code generation or changes after auto generated code.

    Thanking in advance.

    Zaq

    Dhaka

  • Thanks.  Just the jump start I needed!!!

  • This is very good but I want to have both related tables displayed a Details view not just one as a details view and one as a gridview. I want my users to enter data into my form without having to drop into another section.

    I personally believe this is impossible (although I was able to do it with MS Access by writing it as a query. I don't know how to do this in Visual Studio)There are absolutley no "How To's" on this problem and feel this is a huge downfall of what forms are supposed to be all about.

  • When i drop the customer and order tables and go back to form1 and then open Menu.. i dont find any "add new datasource" and "Add object DataSource". so how i will do that...

  • @vicky,

    Please use Data Source menu to add/remove data source from Visual Studio.

  • HI,

    That's great.

    Yes, I got it.

    Your guide helped me to complete a part of my final year project.  That's a big step forward on it.

    Thanks your very much.

  • Great!!!

    So Clear guideline which helped me so much.

    Thanks a lot.

  • @Little Starfish & Irene,

    The sole purpose of this BLOG is to help community adopt the latest and greatest Microsoft Technologies. I am happy to see it helped you.

  • Thanks man for the quick start!

Page 1 of 1 (11 items)