TOPIC:

Hey everyone

I need some help with the dataGridView because I don't really understand how to use it in X#
I am currently setting the datasource like this:If i use DELETE with SET DELETED ON this happens (See attachment)

What am i doing wrong?

Thank you very much

Florentin

Hi Florentin,
what do you like to accomplish with the Windows Forms DataGrid?
Wolfgang

Hi Wolfgang,
i would like to use it like the grid in the Visual FoxPro Forms!

Florentin

Hi Florentin,
there are several mentions of this class in the forums here, so someone seems to have used it.
But I think you need Robert or Fabrice here....
Wolfgang

Hi Florentin,

I don't use FoxPro, however, after DELETE you may have to do:

this.dataGridView1.Update()
this.dataGridView1.Refresh()

If this does not work, try binding the grid again.
What happens if you reopen the form? Does the display of rows look the same?

HTH,
Jamal

Hi Jamal,

i tried all of your suggestions and sadly none of them work for me.
I am also using SET DELETED ON
this is the code i use to set the DataSource:If I want to delete something I used this code:
The first screenshot shows what happens if i just delete.
For some reason it doesn't hide the deleted row even though i use SET DELETED ON.

The second screenshot shows what happens if i delete and then rebind the DataSource.



Im really lost on what to do

Florentin

Hi Florentin,
IMHO you need to wait what Robert says, and before he says something I'm pretty sure he needs some time to analyze that.
But AFAIK today is the first day of Virtual FoxFest, and maybe he had to prepare something for his presence there and was not able to check out your problem.
Wolfgang

Hi Florentin,

Is the datasource a DBF or SQL?

What is the code behind in DbDataSource()?

Edit: I suggest you create a reproducible sample for the dev team to look at.

Jamal

Florentin,
Wolgang was right. I was busy with my session for Virtual FoxFest.
At first glance I think the problem is that the DbDataSource returns the # of records in the table when asked by the Grid for the # of rows. And it does not subtract the # of deleted rows. That would explain why there is an empty row at the bottom.
Give me some time to look at this.
The alternative solution would be to use the DbDataTable(). This reads the contents from the cursor in a (detached) DataTable. A deletion in the table will remove the DataRow (move it to a list of deleted rows).
The disadvantage of this approach is that you will have to write the changes back to the database when you commit the changes (with a button or when you close the form).
I showed how this can be done in my session for VFF a couple of years ago,
It boils down to:
To see what happens when save is executed, look here
github.com/X-Sharp/XSharpPublic/blob/mai...DbDataTable.prg#L113

I'll look into this asap.


Robert

Robert,

thank you very much!

Hi Robert,
is a registration of this session available anywhere?
Maybe that would be really helpful (also for us VOers to understand how we can use these classes).
It would be a real pity to have such useful code.
Wolfgang

Hi Robert,

i tried using DbDataTable but now i can't use DELETE anymore.

Tanks for looking into DbDataSource, i really need it

Florentin

Hello Wolfgang,

wriedmann wrote:

It would be a real pity to have such useful code.

Dick

Hi Dick,
oh, I'm really sorry.... It seems I have sent my response without complete it - it without even notify that.
Wolfgang