|
http://dshalimov.russia.webmatrixhosting.net/default.aspx?content=codesamples#SQLDMO
Say NO to the Hardcode when using Microsoft Application Data Block. Say YES to the full power of the Visual Studio .Net intellisence. Use this Windows application to generate complete Data Access Layer for your applications.
When using DataBlock, to Execute GetClientInfo stored Porcedure developer need to put "GetClientInfo" as one of the parameters to any method of SQL Helper.
If developer put "GetClientInfo123", no compile time error is going to be raised. Of couse you will get an error at run time only.
Using DataBlock :
DataSet oDs= SqlHelper.ExecuteDataset(ConnString,"GetClientInfo",ClientID);
Using DataBlock With Extender:
DataSet oDs= DataAccessLayer.GetClientInfo.ExecuteDataset(ConnString,ClientID);
When using Extended code generated by this tool, developer will have all stored procedures in the Intellicence window.
The Source Code also shows how to use SQLDMO COM Object
jahlive
18 February 2005 04:22 Комментарии (0)
|