Public Sub ShowGrid(StrSQL As String)
ConnectDB
Dim Rs As New Adodb.Recordset
If Rs.State = 1 Then Rs.Close
If StrSQL = "" Then
Rs.Open "SELECT lname,fName,fathername,nshen,sbirth,birthdate FROM personnel ORDER BY ID ASC", Conn, adOpenStatic, adLockOptimistic
Else
Rs.Open StrSQL, Conn, adOpenStatic, adLockOptimistic
End If
' Set Me.VS.DataSource = Rs
Rs.Requery
Set Me.VS.DataSource = Rs
DoEvents
End Sub
سلام
دستور زير رو بنويسيد
Set Me.VS.DataSource = Nothing
سپس دوباره دستورات بالا رو اجرا كنيد و به صورت معمولي به آخر گرايد بريد