for some strange reason this dataset duplicates all of the values
datestart is april first and datestop is april 15 and I get 1 through 15 and then 1 through 15 as second time. the selection is a social security number
I have checked the database, there are no duplicates. I am working in asp.net using vb.
does anyone know why the dataset would create duplicates?
Dim sqlthisPeriod3 As String = "Select * from EmployeeMonthlyrecord where workdate between '" & CDate(datestart) & "' and '" & CDate(datestop) & "' and EMPLOYEEID = '" & Dst.Tables("Dsthireinfo").Rows(0).Item(0).ToString() & "' "
Dim adapter35 As SqlDataAdapter = New SqlDataAdapter(sqlthisPeriod3, Connection)
Catch ex As System.Data.SqlClient.SqlException