Insert data from datagridview into access table

Question

0.00/5 (No votes)

See more:

I have this datagridview whose rows are manually added on a click of a button..and i inherit a class to it's column to make it's cell datatimepicker.i need to insert it into the database without the need to retrieve it first from the database

What I have tried:

to insert it row by row by command excutenonquery

Posted 8-Sep-16 8:33am

newcoder1

Updated 8-Sep-16 9:46am

Add a Solution

Comments

[no name] 8-Sep-16 14:40pm

Nothing you wrote after "button" makes any sense. Can you reword your posting to clearly describe a problem, ask a question and show the code you wrote that demonstrates your problem?

Karthik_Mahalingam 9-Sep-16 0:56am

post the code.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2016-09-08T08:48:00

Solution 1

If I understand the question correctly, you could
- Instead of populating a datatable from the database, define a data table having the desired structure that matches your datagridview (and your actual table)
- bind the datatable to the datagridview
- make modifications to the datatable (by the user)
- use OleDbDataAdapter to reflect the changes from the datatable to the Access database.

Have a look at following article: How to: Bind Data to the Windows Forms DataGridView Control[^] It uses Sql Server classes such as SqlCommand or SqlConnection but you would probably use OleDbCommand and OleDbConnection etc instead. Otherwise this should get you started.

Posted 8-Sep-16 8:48am

Wendelius

Comments

Maciej Los 8-Sep-16 15:44pm

Good suggestion. 5ed!

newcoder1 8-Sep-16 17:59pm

your solution wont work in my case
because if i bind the datatable to the datagridview then i can't use any control that i inherit to the datagridview

Wendelius 8-Sep-16 23:24pm

Not quite sure what you mean. Can you post example code

Wendelius 8-Sep-16 23:39pm

As additional info, here's an example how to use custom column with datagridview. This shouldn't affect data binding How to: Host Controls in Windows Forms DataGridView Cells[^]

newcoder1 9-Sep-16 6:25am

ok mika here's the thing
i'll make table
then i fill it with schema from the database
then i'll bind it to the datagridview datagridview.datasource=table
so after binding>>>if i want to add new row to the datagridview by code i wont be able
i will not be able to use such code( datagridview.rows.add)
instead it will be bindingsource code
so it will be like bindingsource.addnew()

and that is the problem when i use bindingsource.addnew()it will not add the custom datagridview coulmns

it will add just normal row which will appear in the datagridview since it's binding to the datatable

got it?

try it your self

Wendelius 9-Sep-16 7:54am

The fact that you cannot add rows to the datagridview directly but you have to add rows to the data table is by design. When you bind the grid to a data source, all data modifications should be done to the object holding the data not to the grid which is only visualizing the data. So that makes perfect sense.

However, I'm not sure what you mean that the code will not add custom columns. The number of columns is typically static. I take it that you mean that you can't use custom editor for the cell in custom column for the newly added row. For this problem please refer to the example I posted in previous comment. That should explain how you can use a customized editor for the data in a particular cell.

newcoder1 9-Sep-16 14:15pm

give me a code example for what you are saying please

Maciej Los · Answer 2 · 2016-09-08T09:46:00

Solution 2

Start here: Bulk Record Insert for Access[^]

Posted 8-Sep-16 9:46am

Maciej Los