[ابو ليلى]

جرب كالتالي

PHP كود :

               Dim cmd As New SqlClient.SqlCommand("select * from Table1 where serialin like @serialin + '%'", con2010)
                cmd.Parameters.AddWithValue("@serialin", TextBox1.Text.Trim)
                con2010.Open()
                Dim reader As SqlClient.SqlDataReader = cmd.ExecuteReader

                If reader.HasRows = False Then
                    MessageBox.Show("لا توجد نتائج")
                    DataGridView1.DataSource = Nothing
                Else
                    Table1.Load(reader)
                    DataGridView1.DataSource = Table1
                End If
                reader.Close()
                cmd.Dispose()
                con2010.Close()