Database

Dim dr As DataRow
Using cn As New OleDb.OleDbConnection(cnStr)
            Dim cmd As New OleDb.OleDbCommand(strSelect, cn)
            Dim da As New OleDb.OleDbDataAdapter(cmd)
            
            Try
                cn.Open()
                da.Fill(dt)
                If dt.Rows.Count >= 1 Then
                    dr = dt.Rows(0)
                End If
            Catch ex As Exception
                'Err handling
            Finally
                cn.Close()
                dt = Nothing
            End Try
        End Using
        Return dr

I want to learn step by step implementation of the project tables
If someone can , please send it to me :confused:

Hi,
I am trying to make Merge Replication for my .NET application and I manged to set it up but I have an issue. I am making the replication every 5 minutes where the publisher and the distributor are on the server and the subscriber on a local machine. Also, I am using pull type subscriber. Inside my .NET application I am accessing the data from my local machine(subscriber), but during the replication process,the data on the subscriber gets deleted which causes a problem to my .NET application and the end user cannot find his/her information because it being deleted and re-inserted into the subscriber later on. This is a serious issue because I am building a POS application and the user need the data instantly.

My questions, is there a way to make the subscriber to do make the pull data without deleting the current data? any idea is very welcome.

Thank you!