How to update datasource when more direct data on datagridview?

Question

0.00/5 (No votes)

See more:

Hi everybody!
I'm having a problem, I was looking on google but did not see his problem and decided on your website to seek help.
Specifically, my problem is as follows:
1 - I have a datagridview that allows users to automatically add new lines, and receive data from the new line (this issue I have done and works very well).
2 - when I export to excel conducted from the new line is added to the datasource of the datagridview I found to be null (The problem lies here).
People ask me, is when we add data directly on datagidview, the data will not be binding to the datasource? Is there any way so that when we add data directly on the datagridview, the data will be added to the datasource?
We hope to receive the help from everyone!
Thank you!

Posted 28-Sep-14 16:52pm

StackThanh

Add a Solution

Comments

Sinisa Hajnal 29-Sep-14 6:36am

Did you try Grid.CommitEdit? or DataTable.AcceptChanges? Look into those...

Nathan Minier 29-Sep-14 8:05am

If you want it added automatically you need to make sure that AJAX is setup properly. Do you have a ScriptManager running on the page? Is your GridView in an UpdatePanel?

If you don't want to use AJAX, you will need to postback before changes will be applied to the database.

ChintanShukla 1-Oct-14 5:21am

Can you pleas share your Code

[no name] 3-Oct-14 4:14am

could you please post your code

1 solution

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)

StackThanh · Accepted Answer · 2014-10-07T23:34:00

Solution 1

Hi EveryBody!
Thank you all very much!
Now I have found the solution to my problem.
I do not use the output data to excel from another datasource that will be used directly from the data row on the datagridview.
I would like to close this topic here.

Posted 7-Oct-14 23:34pm

StackThanh