1)I am trying to make a web services with few web methods. Web methods are executing stored procedures with <BR>parameres. Now after executing it is making dataset. Now how can I get the dataset(1) or dataset(2) as used <BR>to get recorset(1) & ....<BR><BR>2) About connection string- in executing stored procedures- how to write that. <BR><BR>3)Is there any way to check the State of the dataset (as in case of recordset - rst.state, rst.open, rst.eof..etc)<BR><BR>any suggestion resources or comments is appreciated.<BR><BR>thanks <BR>