1.
If
sql12 =
"Select * from in_stock1 where product_name='"
& TextBox4.Text &
"' and product_color='"
& TextBox3.Text &
"' and mat_return='Material Return' and boi='"
& TextBox10.Text &
"'"
Then
2.
loaddgv2(
"Select * from in_stock1 where product_name='"
& TextBox4.Text &
"' and product_color='"
& TextBox3.Text &
"' and mat_return='Material Return' and boi='"
& TextBox10.Text &
"'"
)
3.
ElseIf
sql12 =
"select * from in_stock1 where mat_return like 'NO'"
Then
4.
loaddgv2(
"select * from in_stock1 where product_name='"
& TextBox4.Text &
"' and product_color='"
& TextBox3.Text &
"' and mat_return='NO' and boi='"
& TextBox10.Text &
"'"
)
5.
End
If