Check database table for pre-existing record

[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,

 

[Islay Rodriguez Jr.]

Thanks for your quick response, Can you direct me to some good examples?

Islay

 

[Islay Rodriguez Jr.]

Thanks again
--
Islay

You'll find the documentation at
http://msdn.microsoft.com/en-us/library/tyy0sz6b(VS.80).aspx and around...