How to insert into my sql table in wpf using Dataset

Question

I was wondering what would be the best way to insert a row into my sql table through WPF application window. I have two wpf DataGrids in my application, and I want the user to be able to push a button and insert data into the grid from there (inserting data into the sql table and refresh the grid when the user closes the pop-up window after inserting). I´m using a DataSet database model and running .sdf database inside my application.

I´m using a TableAdapter to fill my DataGrid:

    HomeApplication.TheHomeApplicationDBDataSet theHomeApplicationDBDataSet;
    HomeApplication.TheHomeApplicationDBDataSetTableAdapters.AccountingTableAdapter  homeApplicationDataSetAccountingTableAdapter;

What is the best way to do this? Any ideas would help. thx :)

Start reading this example and change the appropriate database connection , parameters and variables to fit your environment dotnetcurry.com/ShowArticle.aspx?ID=566 — MethodMan
– MethodMan, Commented Jan 12, 2013 at 19:45

Lightness Races in Orbit · Accepted Answer · 2013-01-24 05:03:09Z

1

WPF doesn't help you for data acces. So you can do something like that northwindDataSet1.Customers.Rows.Add(newCustomersRow);

edited Jan 24, 2013 at 5:03

Lightness Races in Orbit

387k77 gold badges670 silver badges1.1k bronze badges

answered Jan 13, 2013 at 3:55

Stephane Halimi

5063 silver badges5 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

tingason Over a year ago

I solved this like that theHomeApplicationDBDataSet.AccountingIncome.Rows.Add(null, "Wage A", 3000, null, "2013-01-01"); This is stored in my sql table and my wpf datgrid picks up the changes right away :)

Collectives™ on Stack Overflow

How to insert into my sql table in wpf using Dataset

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related