یاشار رضایی نسب
سه شنبه 07 دی 1389, 11:48 صبح
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim conn As New SqlConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\\sherkat\\nagshe - info.accdb")
Dim cmm As New SqlCommand
Dim dr As SqlDataReader
Dim code As String
conn.Open()
cmm.Connection = conn
cmm.CommandText = "select * from table1"
cmm.ExecuteNonQuery()
dr = cmm.ExecuteReader
While (dr.Read())
code = dr.GetString(6)
If (code.Trim() = TextBox2.Text.Trim()) Then
CheckBox1.CheckState = CheckState.Checked
End If
End While
Try
conn.Close()
Catch ex As Exception
Me.Text = ex.Message()
End Try
End Sub
البته با vb2008 این کد نوشتم پایگاه داده ام اکسس هست .
Dim conn As New SqlConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\\sherkat\\nagshe - info.accdb")
Dim cmm As New SqlCommand
Dim dr As SqlDataReader
Dim code As String
conn.Open()
cmm.Connection = conn
cmm.CommandText = "select * from table1"
cmm.ExecuteNonQuery()
dr = cmm.ExecuteReader
While (dr.Read())
code = dr.GetString(6)
If (code.Trim() = TextBox2.Text.Trim()) Then
CheckBox1.CheckState = CheckState.Checked
End If
End While
Try
conn.Close()
Catch ex As Exception
Me.Text = ex.Message()
End Try
End Sub
البته با vb2008 این کد نوشتم پایگاه داده ام اکسس هست .