Click here to Skip to main content
15,890,438 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
when i save the data its save correctly but my appliction difind it some were in all data like:-

id no name name time date weight weigh weigh

1 2132 name name time date 10200 12200 13200
2 2132 name name time date 10200 12200 13200
3 2132 name name time date 10200 12200 13200
4 2132 name name time date 10200 12200 13200
5 2132 name name time date 10200 12200 13200
12 2132 name name time date 10200 12200 13200 < its show like this 3 rows
13 2132 name name time date 10200 12200 13200 <when i try new save data is show
14 2132 name name time date 10200 12200 13200 < down of 14 no rows.
6 2132 name name time date 10200 12200 13200
7 2132 name name time date 10200 12200 13200
8 2132 name name time date 10200 12200 13200
9 2132 name name time date 10200 12200 13200
10 2132 name name time date 10200 12200 13200
11 2132 name name time date 10200 12200 13200





in the database i check show line by line correctly but application shows different.
please help.......

What I have tried:

VB
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click


        FrmSlip.Show()

        FrmSlip.DW1BindingSource.AddNew()
        FrmSlip.TextBox1.Text = FrmSlip.Label15.Text
        Try
            Dim FG As Integer
            FG = FrmSlip.Label15.Text
            FrmSlip.Label15.Text = Format(FG + 1, "0000")
        Catch ex As Exception

        End Try
        FrmSlip.TextBox12.Text = Today.Date.ToString("dd-MM-yyyy")
        FrmSlip.TextBox13.Text = TimeOfDay.ToShortTimeString
        FrmSlip.TextBox1.Text = FrmSlip.Label15.Text
        ' FrmSlip.Label14.Text = FrmSlip.TextBox1.Text
        ' FrmSlip.TextBox1.Text = FrmSlip.Label15.Text
        Supplier.Close()
        Truck.Close()
        Party.Close()
        Operatore.Close()
        Product.Close()


' And this code is in the FrmSlip for save...............



 Private Sub Button2_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
        ' Button3.Enabled = True

        Button3.Focus()
        On Error GoTo SaveErr
        DW1BindingSource.EndEdit()
        DW1TableAdapter.Update(WB001DataSet.DW1)
SaveErr:
        Exit Sub
    End Sub



    End Sub
Posted
Comments
ZurdoDev 26-Sep-18 8:14am    
I suggest you fix your code.
Arnav121 27-Sep-18 7:42am    
WHATS WRNG IN MY CODE???
ZurdoDev 27-Sep-18 8:11am    
No idea. You have not explained the problem clearly nor have you posted the relevant code. That is why no one has been able to help you.

So, stop yelling and edit your question and make it clear what you need.
Arnav121 29-Sep-18 7:04am    
Access database records not staying in the right order when displayed in Application

see picture of database
https://drive.google.com/file/d/1jqP5a36wwKsL4S_GJRHlL9oUYQav2Csa/view?usp=sharing
ZurdoDev 29-Sep-18 15:30pm    
But the code you have shown has nothing to do with the order the records are shown.

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

  Print Answers RSS
Top Experts
Last 24hrsThis month


CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900