I
Islay Rodriguez Jr.
I'm trying to check if a "CompanyProductNumber" already exists in a database
table
from within the "CompanyPruductNumber_TextChanged" event handler.
I have configured an SQLDataSource from the tool box called
"CheckRawMaterial"
with an sql select statement:
SELECT RawMaterialName FROM RawMaterial WHERE (CompanyProductNumber =
@CompanyProdNum) AND (CompanyID = @CompID)
with parameters @CompanyProdNum and @CompID which are bound to a
textbox.text control and a session field value. I have tested the SQL
statement in the configuration wizard and it works.
My problem is that I can't figure out how to execute the Select staement
from within the "CompanyPruductNumber_TextChanged" event handler. The
"CheckRawMaterial" object has no execute method.
I would appreciate any help.
Thanks,
table
from within the "CompanyPruductNumber_TextChanged" event handler.
I have configured an SQLDataSource from the tool box called
"CheckRawMaterial"
with an sql select statement:
SELECT RawMaterialName FROM RawMaterial WHERE (CompanyProductNumber =
@CompanyProdNum) AND (CompanyID = @CompID)
with parameters @CompanyProdNum and @CompID which are bound to a
textbox.text control and a session field value. I have tested the SQL
statement in the configuration wizard and it works.
My problem is that I can't figure out how to execute the Select staement
from within the "CompanyPruductNumber_TextChanged" event handler. The
"CheckRawMaterial" object has no execute method.
I would appreciate any help.
Thanks,