RamezanBeik
یک شنبه 27 تیر 1389, 12:43 عصر
سلام حدمت تمام برنامه نویسان عزیز
Dim strsql As String
Dim query1 As String
query1 = Textsearch.Text
If combo_Search <> "" Then
If Textsearch.Text <> "" Then
Select Case combo_Search.ListIndex
Case 0
Set Rs = Nothing
strsql = "SELECT *FROM personal WHERE Id='" & query1 & "'"
Rs.Open strsql, CN, adOpenStatic, adLockOptimistic
Set Grid1.DataSource = Rs
Call changecaption
Case 1
Set Rs = Nothing
strsql = "SELECT *FROM personal WHERE Name = '" & query1 & "'"
Rs.Open strsql, CN, adOpenKeyset, adLockOptimistic, adCmdText
Set Grid1.DataSource = Rs
Call changecaption
Case 2
Set Rs = Nothing
strsql = "SELECT *FROM personal WHERE Lname='" & query1 & "'"
Rs.Open strsql, CN, adOpenStatic, adLockOptimistic
Set Grid1.DataSource = Rs
Call changecaption
Case 3
Set Rs = Nothing
strsql = "SELECT *FROM personal WHERE Fname ='" & query1 & "'"
Rs.Open strsql, CN, adOpenStatic, adLockOptimistic
Set Grid1.DataSource = Rs
Call changecaption
Case 4
Set Rs = Nothing
strsql = "SELECT *FROM personal WHERE Age ='" & query1 & "'"
Rs.Open strsql, CN, adOpenStatic, adLockOptimistic
Set Grid1.DataSource = Rs
Call changecaption
Case 5
Set Rs = Nothing
strsql = "SELECT *FROM personal WHERE Tel ='" & query1 & "'"
Rs.Open strsql, CN, adOpenStatic, adLockOptimistic
Set Grid1.DataSource = Rs
Call changecaption
Case 6
Set Rs = Nothing
strsql = "SELECT *FROM personal WHERE Sex ='" & query1 & "'"
Rs.Open strsql, CN, adOpenStatic, adLockOptimistic
Set Grid1.DataSource = Rs
Call changecaption
End Select
If Grid1.Text = "" Then
MsgBox "", vbOKOnly + vbInformation, ""
Set Rs = Nothing
Rs.Open "Select *from Personal", CN, adOpenStatic, adLockOptimistic
Set Grid1.DataSource = Rs
Call changecaption
Grid1.RightToLeft = True
End If
Else
MsgBox "", vbOKOnly + vbInformation, ""
Textsearch.SetFocus
End If
Else
MsgBox "", vbOKOnly + vbInformation, ""
combo_Search.SetFocus
End If
combo_Search.Text = ""
Textsearch.Text = ""
مشکل این کد جسجو چیه که وقتی پارامتر عددی وارد مکنید جستجو را انجام میدهد اما وقتی رشته وارد می کنم هیچ وا کنشی نشون نمده در ضمن در تالار جستجو کردم کارم راه نیفتاد
Dim strsql As String
Dim query1 As String
query1 = Textsearch.Text
If combo_Search <> "" Then
If Textsearch.Text <> "" Then
Select Case combo_Search.ListIndex
Case 0
Set Rs = Nothing
strsql = "SELECT *FROM personal WHERE Id='" & query1 & "'"
Rs.Open strsql, CN, adOpenStatic, adLockOptimistic
Set Grid1.DataSource = Rs
Call changecaption
Case 1
Set Rs = Nothing
strsql = "SELECT *FROM personal WHERE Name = '" & query1 & "'"
Rs.Open strsql, CN, adOpenKeyset, adLockOptimistic, adCmdText
Set Grid1.DataSource = Rs
Call changecaption
Case 2
Set Rs = Nothing
strsql = "SELECT *FROM personal WHERE Lname='" & query1 & "'"
Rs.Open strsql, CN, adOpenStatic, adLockOptimistic
Set Grid1.DataSource = Rs
Call changecaption
Case 3
Set Rs = Nothing
strsql = "SELECT *FROM personal WHERE Fname ='" & query1 & "'"
Rs.Open strsql, CN, adOpenStatic, adLockOptimistic
Set Grid1.DataSource = Rs
Call changecaption
Case 4
Set Rs = Nothing
strsql = "SELECT *FROM personal WHERE Age ='" & query1 & "'"
Rs.Open strsql, CN, adOpenStatic, adLockOptimistic
Set Grid1.DataSource = Rs
Call changecaption
Case 5
Set Rs = Nothing
strsql = "SELECT *FROM personal WHERE Tel ='" & query1 & "'"
Rs.Open strsql, CN, adOpenStatic, adLockOptimistic
Set Grid1.DataSource = Rs
Call changecaption
Case 6
Set Rs = Nothing
strsql = "SELECT *FROM personal WHERE Sex ='" & query1 & "'"
Rs.Open strsql, CN, adOpenStatic, adLockOptimistic
Set Grid1.DataSource = Rs
Call changecaption
End Select
If Grid1.Text = "" Then
MsgBox "", vbOKOnly + vbInformation, ""
Set Rs = Nothing
Rs.Open "Select *from Personal", CN, adOpenStatic, adLockOptimistic
Set Grid1.DataSource = Rs
Call changecaption
Grid1.RightToLeft = True
End If
Else
MsgBox "", vbOKOnly + vbInformation, ""
Textsearch.SetFocus
End If
Else
MsgBox "", vbOKOnly + vbInformation, ""
combo_Search.SetFocus
End If
combo_Search.Text = ""
Textsearch.Text = ""
مشکل این کد جسجو چیه که وقتی پارامتر عددی وارد مکنید جستجو را انجام میدهد اما وقتی رشته وارد می کنم هیچ وا کنشی نشون نمده در ضمن در تالار جستجو کردم کارم راه نیفتاد