在数据库运行StoredProcedure的语法动态

SVSaichandra:我已经从你的问题的理解，您在其中保存您尝试访问一个存储在SQL文件首先你应该了解，保存在文件中的存储过程只是为了用户，而不是为SQLServer。实际存储过程将被保存在你的数据库的数据库对象。你只需要创建一个SQL连接对象和命令对象是从数据库中访问存储过程的。你可以检查此代码:codeprespanclass="code-keyword"public/spanspanclass="code-keyword"void/spanRunStoredProc() { SqlConnectionconn=spanclass="code-keyword"null/span; SqlDataReaderrdr=spanclass="code-keyword"null/span;  Console.WriteLine(spanclass="code-string""/spanspanclass="code-string"\nTop10MostExpensiveProducts:\n"/span);  spanclass="code-keyword"try/span { spanclass="code-comment"///spanspanclass="code-comment"createandopenaconnectionobject/span conn=spanclass="code-keyword"new/span SqlConnection(spanclass="code-string""/spanspanclass="code-string"Server=(local);DataBase=Northwind;IntegratedSecurity=SSPI"/span); conn.Open();  spanclass="code-comment"///spanspanclass="code-comment"1.createacommandobjectidentifying/span spanclass="code-comment"///spanspanclass="code-comment"thestoredprocedure/span SqlCommandcmd=spanclass="code-keyword"new/spanSqlCommand( spanclass="code-string""/spanspanclass="code-string"TenMostExpensiveProducts"/span,conn);  spanclass="code-comment"///spanspanclass="code-comment"2.setthecommandobjectsoitknows/span spanclass="code-comment"///spanspanclass="code-comment"toexecuteastoredprocedure/span cmd.CommandType=CommandType.StoredProcedure;  spanclass="code-comment"///spanspanclass="code-comment"executethecommand/span rdr=cmd.ExecuteReader();  spanclass="code-comment"///spanspanclass="code-comment"iteratethroughresults,printingeachtoconsole/span spanclass="code-keyword"while/span(rdr.Read()) { Console.WriteLine( spanclass="code-string""/spanspanclass="code-string"Product:{0,-25}Price:${1,6:####.00}"/span, rdr[spanclass="code-string""/spanspanclass="code-string"TenMostExpensiveProducts"/span], rdr[spanclass="code-string""/spanspanclass="code-string"UnitPrice"/span]); } } spanclass="code-keyword"finally/span { spanclass="code-keyword"if/span(conn!=spanclass="code-keyword"null/span) { conn.Close(); } spanclass="code-keyword"if/span(rdr!=spanclass="code-keyword"null/span) { rdr.Close(); } } }/pre/code
米卡Wendelius

如果你要运行动态SQL语句在存储过程中，你可以使用imgsrc=http://www.orcode.com/img/ico/smiley_smile.gif]