check record and then run second query to display in data grid

[mamun]

Hi All,

I am doing it for the first time in C# (using Visual Studio 2005),

First I need to check if data exists in a table for a variable. If so
then run the second query and display the resultsets in Gridview.

For ex., in the form I am entering contract id and running the query
for that contract id. If results found then use that contract id to
run the second query and show the results in gridview.

My question is how I can accomplish that?
I do appreciate your help.

Thanks a ton in advance.
best regards,
Mamun

 

[Laura T.]

You can find a lot of examples here:

http://msdn2.microsoft.com/en-us/data/aa937711.aspx
http://samples.gotdotnet.com/quickstart/howto/doc/adoplus/ADOPlusOverview.aspx
http://quickstarts.asp.net/QuickStartv20/aspnet/doc/ctrlref/data/gridview.aspx

Also, I think you don't need two queries. Just run the select query and
check if the result contains records or not.
If you are using ASP.NET, you might be able to do it without writing code
(or almost).