27-12-23, 06:40 PM
PHP كود :
DT.Clear()
Dim query As String = "SELECT * FROM [MTable] WHERE [Name] LIKE @param1 and [FamousName] LIKE @param2 and [MotherName] LIKE @param3 and [Plag] LIKE @param4 and [Address] LIKE @param5 and [InternationalID] LIKE @param6 and [AccType] LIKE @param7 and [IDCard] LIKE @param8"
DA1 = New OleDbDataAdapter(query, CN)
DA1.SelectCommand.Parameters.AddWithValue("@param1", "%" & TName.Text & "%")
DA1.SelectCommand.Parameters.AddWithValue("@param2", "%" & TFamousName.Text & "%")
DA1.SelectCommand.Parameters.AddWithValue("@param3", "%" & TMotherName.Text & "%")
DA1.SelectCommand.Parameters.AddWithValue("@param4", "%" & TAddress.Text & "%")
DA1.SelectCommand.Parameters.AddWithValue("@param5", "%" & TInternationalID.Text & "%")
DA1.SelectCommand.Parameters.AddWithValue("@param6", "%" & TextBox4.Text & "%")
DA1.SelectCommand.Parameters.AddWithValue("@param7", "%" & TextBox6.Text & "%")
DA1.SelectCommand.Parameters.AddWithValue("@param8", "%" & TIDCard.Text & "%")
DA1.Fill(DT)
DGV1.DataSource = DT
لقد واجهة مشكلة في مشروعك لدى جرب التعديل هذا

