vb.net datagrid update with button click

Question

2.00/5 (1 vote)

See more:

, +

Before I save or change data in a row/column on my datagrid I have to move off of the row/column before it is submitted to the DB.

Normally this is ok but I'm adding a filepath to a cell which is obtained via openfiledialogue. After I close the openfiledialogue the filepath dosnt show in the datagrid cell until I move off of the highlighted cell, this makes for tricky data entry.

How can I force the data to be submitted say with a button click or make the highlighted cell be the next row.?

Hope that makes sense

thankx for looking

Ok, so it seems it is harder to make ppl understand the problem fully than actualy solve it.

So Im thinking something along the lines of using a button click and code like this

Private Sub CmdNext_Click(sender As System.Object, e As System.EventArgs) Handles CmdNext.Click
Me.MyBindingSource.MoveNext() 'THIS MOVES THE FOCUS TO THE NEXT CELL
End Sub

the grid is now updated it WORKS.

SO THANKS TO YOU WHO MADE A CONTRIBUTION HERE AND I HOPE THIS WILL HELP SOMEONE IN THE FUTURE

Posted 2-Jan-12 21:55pm

It is what it is

Updated 3-Jan-12 12:35pm

v9

Add a Solution

Comments

Sergey Alexandrovich Kryukov 3-Jan-12 13:38pm

Please, give use fully-qualified name of the DataGridView type and tag your UI library and type of application (WPF, Silverlight, Forms, ASP.net, what?!).
--SA

Kschuler 3-Jan-12 14:24pm

Can you post the code you are currently using to put the text into the cell? It might help us understand the issue.

It is what it is 3-Jan-12 14:46pm

ok for what its worth, but I think its beside the point :)
I mean as far as im concerned there is no code, the data in the cell is submitted after you move off of the cell, this behaviour must be part of what happens under the covers with a datagridview yes??

In the code below I use a field from details view to hold the string, I'm using a gridview and details view on the same form, sorry its hard to explain.

Private Sub CmdInsertImage_Click(sender As System.Object, e As System.EventArgs) Handles CmdInsertImage.Click

OpenFileDialog1.ShowDialog()
FilePathTextBox.Text = OpenFileDialog1.FileName
'assign filename to FilepathTextBox. This field is derived from a details view
'that comes from the dataset.
TxtFileName.Text = OpenFileDialog1.SafeFileName 'not important
ImagePictureBox.Image = Image.FromFile(FilePathTextBox.Text) 'not important
DatestampDateTimePicker.Value = Now 'not important

End Sub

Kschuler 3-Jan-12 14:53pm

hm...so where in that code are you assigning a value to a datagridviewcell? You don't seem to be referencing a DataGrid anywhere in that code. It looks like you are just assigning the value to a textbox (The one you marked as "derived" from a details view, and I'm not sure what that means.) Could you explain some more? Also, you can click the "Improve Question" button and add this code and more information to your original question. That way people don't have to read all of the comments to find new info.

It is what it is 3-Jan-12 15:02pm

"derived" from a details view, and I'm not sure what that means

when u add a datasource you can drag a gridview onto the form. There is also an option the have the display set to details

You can also have gridview and details the same form that is how I'm working......

Kschuler 3-Jan-12 15:06pm

Yes, but how are you getting a TextBox object from the DataGridView object or the DataView object?

It is what it is 3-Jan-12 15:14pm

umm, datagridview, from the dataset...

Kschuler 3-Jan-12 15:16pm

Okay.....so how do you get the Textbox object from the DataGridView? You must have some bit of code that starts with
Dim FilePathTextBox as Textbox
And then assigns it to the editing control of the datagridviewcell? Or something similar? How are you doing that?

It is what it is 3-Jan-12 15:18pm

no code
just drag and drop

Dave Kreskowiak 3-Jan-12 15:59pm

The problem is you are assigning test and an image to a textbox and picturebox, but nowhere in this code are you assigning this data to any database, datatable, dataset, or anyn other datasource. Where is the datagridview getting the data to display from???

It is what it is 3-Jan-12 18:36pm

like I said to the other guy the code i have is not the issue :)

Dave Kreskowiak 3-Jan-12 19:20pm

Yes, it is. The problem is that most of the code you have is hidden by the designer.

You have to get the data from the textbox control to whatever the datagridview is bound to. We don't know what that is, so it's pretty much impossible to tell you what you have to do.

It is what it is 3-Jan-12 19:42pm

Now that you have seen my answer to my own question are you any closer to understanding the original question?

And would you have chosen it or can you now see another solution ?

Dave Kreskowiak 3-Jan-12 20:00pm

No. That's what we keep telling you. Nowhere in your code are you putting the data you've shown into anything that could be bound to the grid.

It is what it is 3-Jan-12 20:12pm

so is that a no to all three questions?
no you dont get it
no you wouldnt choose it and no you dont see another way

Dave Kreskowiak 3-Jan-12 22:37pm

I and everyone else is saying that there is one piece of information you're not giving us that is critical to answering your question. With the code you've posted, there is no way you can be getting the data from your textbox and filedialog to the datagrid without first putting it somewhere. That "somewhere" is what you're not telling us.

It is what it is 3-Jan-12 15:20pm

How can I add a screen shot here??

Dave Kreskowiak 3-Jan-12 15:57pm

You can't. You're also experiencing why people don't use the drag'n'drop designers to do database work also. Would could tell you a bunch of things, but since the designer is hiding all of the code that's doing the work, you have no idea what's really going on.

It is what it is 3-Jan-12 18:36pm

you can.

Private Sub CmdNext_Click(sender As System.Object, e As System.EventArgs) Handles CmdNext.Click
Me.MyBindingSource.MoveNext() 'THIS MOVES THE FOCUS TO THE NEXT CELL
End Sub

Dave Kreskowiak 3-Jan-12 19:19pm

Your question on this thread was "How can I add a screen shot here?" You can't.

It is what it is 3-Jan-12 19:34pm

Avoiding ambiguity; you're reply should have been "you can't add a screen shot".

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)

Oscar Arros González · Answer 1 · 2012-01-07T18:51:00

Solution 3

after the return of the dialog, you assing the data to the cell, if this is ok, after that, you can use this instruction to end the edition.

datagridview1.Endedit(true)

regards.

Posted 7-Jan-12 18:51pm

Oscar Arros González

Comments

It is what it is 8-Jan-12 1:58am

Thank you for your suggestion, I will include this in my project to see if it works and get back to you. I'm happy you can understand the problem.