With ActiveDB you can access your SQL Server stored procedures from a .NET program with one line of code. It's like having IntelliSense on your database. Just point ActiveDB at your development database and let it generate all the stored procedure call stubs. Then give ActiveDB the actual connection string and invoke the stored procedure as easily as a .NET method: DataSet ds = Northwind. Employee_Sales_by_Country (from, thru); ActiveDB handles all the stored procedure parameters correctly -- their type and if they are an output parameter. It even creates overloaded methods for parameters with default values.
What's more, if your stored procedure returns a data set, with ActiveDB you can reference the columns of the returned data set table using auto-generated column names that are the same as the column names in the SQL query. No more hardcoding column references or using numeric indices into the Columns collection. Version 1 includes unspecified updates.
Requirements:
Windows 2000/XP/2003 Server, Microsoft .NET Framework 2
Comments not found