How to display the last inserted records in crystal report

[jggtz]

Forget it... in your post #25 you showed that it's the same datetime for all inserted records

[ADQUSIT]

Let me clarify myself for something. Will i ever have a problem as for as millisecond is concern? I mean that i've tried 7, 8 records but the millisecond doesn't change. But i mean that if the records are too many, so will millisecond be effected?

[jggtz]

You are not dealing with milliseconds...

Could you post the code where you are inserting the records

[ADQUSIT]

This is my insert button code on my SaleInfo Form.

 Try

            If dgvSales.Rows.Count <= 0 Then
                MessageBox.Show("At Least One record must be available in Data Viewer", "SellingMS", MessageBoxButtons.OK)
            Else


                Dim insSale As String = "insert into SaleInfo (Prod_ID, Sale_Prod_Qty, Sale_Prod_POO, Sale_Prod_POA, Sale_Date) values (@Prod_ID, @Sale_Prod_Qty, @Sale_Prod_POO, @Sale_Prod_POA, @Sale_Date)"
                Dim cmdSql As New SqlCommand(insSale, cnSql)
                cmdSql.CommandType = CommandType.Text
                daSql.InsertCommand = cmdSql

                cnSql.Open()
                Dim i As Integer
                For i = 0 To (dtSale.Rows.Count - 1)


                    cmdSql.Parameters.Clear()

                    With cmdSql
                        .Parameters.Add("@Prod_ID", SqlDbType.Int).Value = dtSale.Rows(i)("SaleProductID")
                        .Parameters.Add("@Sale_Prod_Qty", SqlDbType.Int).Value = dtSale.Rows(i)("SaleProductQty")
                        .Parameters.Add("@Sale_Prod_POO", SqlDbType.Int).Value = dtSale.Rows(i)("SaleProductUnitPrice")
                        .Parameters.Add("@Sale_Prod_POA", SqlDbType.Int).Value = dtSale.Rows(i)("SaleProductAllPrice")
                        .Parameters.Add("@Sale_Date", SqlDbType.DateTime).Value = dtSale.Rows(i)("DateTime")
                    End With
                    cmdSql.ExecuteNonQuery()

                Next
                MessageBox.Show(i & "  " & " records have been inserted successfully", "SellingMS", MessageBoxButtons.OK)
                txtSaleID.Focus()
                Call Clear(Me)
                Call selSale()
                Call ClearCombo(Me)
                dtSale.Rows.Clear()

                frmPracticeReport.Show()

            End If

        Catch ex As Exception
            MessageBox.Show(ex.Message)
        Finally
            cnSql.Close()
        End Try

[ADQUSIT]

So, My project is completed. Do you know that how to attach the Crystal Report to Setup File.