07-01-18, 12:35 AM
(06-01-18, 01:33 PM)وائل القطاوي كتب : Dim dt As New DataTable
dt.Clear()
Dim da As New OleDbDataAdapter(" SELECT * from users where user_name & pass_word like '%" & TextBox1.Text & "%'", con)
da.Fill(dt)
Me.DataGridView1.DataSource = dt
السلام عليكم ورحمة الله وبركاته
الشكر الجزيل لاستاذي وائل القطاوي واستاذي محمود صالح
الحمد لله الكود يعمل وهذا هو الكود الذي استخدمته
===========================================================================
Dim sql As String = "SELECT * FROM [ERC_Cascaded_Sites] WHERE [SITE ID] LIKE '%" & TextBox3.Text & "%' Or [2G_CID] LIKE '%" & TextBox3.Text & "%' Or [3G_CID] LIKE '%" & TextBox3.Text & "%' Or [FDD_CID] LIKE '%" & TextBox3.Text & "%' Or [TDD_CID] LIKE '%" & TextBox3.Text & "%' Or [WiFi_CID] LIKE '%" & TextBox3.Text & "%'"
Using da As New OleDbDataAdapter(sql, con)
Dim dt As New DataTable
da.Fill(dt)
DataGridView1.DataSource = dt
End Using

