Hi,

I have a web page with some controls

1) text boxes

2) labels and dropdownlists

Totally I have 4 stored procedures (sp)  to use.

a) First sp is used to fetch data to fill in textboxes ( this data come from properties after sp has executed in DAO layer)

b) Second sp is used to fill all the 20 dropdowns (returns DataTable using which all dropdowns are binded)

c) Third sp is used to display 20 labels text dynamically (each label is located in front of one dropdown) (returns DataTable using which we bind data to all labels)

d) Fourth sp is used to select the dropdown selected item

   The scenario how I am calling all the stored procedures is..

In the page_Load -> I am calling First sp, if the datatable which it returns has count >0  i'm sending a boolean value true to code behind.

If the boolean value is true, I am calling second and third sp and filling dropdowns and labels text,

finally I am checking the condition which item should be selected in the drop down list..

Every time I am calling a new function to execute stored procedure.

Is this the correct scenario what iam doing??

If not then please tell me a better way to call...