如何从VB.net(或C#)调用sqlserver函数?是否有一些像存储过程的语法?

前端之家收集整理的这篇文章主要介绍了如何从VB.net(或C#)调用sqlserver函数?是否有一些像存储过程的语法?前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
  1. Public Sub cleanTables(ByVal prOKDel As Short)
  2. Dim sqlParams(1) As sqlParameter
  3. Dim sqlProcName As String
  4. sqlProcName = "db.dbo.sp_mySP"
  5. sqlParams(1) = New sqlParameter("@OKDel",prOKDel)
  6. Try
  7. dbConn.SetCommandTimeOut(0)
  8. dbConn.ExecuteNonQuery(CommandType.StoredProcedure,sqlProcName,sqlParams)
  9. Catch ex As Exception
  10.  
  11. Finally
  12.  
  13. End Try
  14. End Sub

在那儿

  1. CommandType.StoredProcedure...CommandType.Function
  2. sqlParams(1) = New sqlParameter("@OKDel",prOKDel)...

最后是datatable dt = dbConn.Execute(CommandType.StoredProcedure,sqlParams)

谢谢

抱歉,没有办法直接运行功能.使用sql Text命令调用
  1. Public Sub RunFunction(ByVal input As Short)
  2. Using myConnection As New Data.sqlClient.sqlConnection
  3. Using myCommand As New Data.sqlClient.sqlCommand("Select dbo.MyFunction(@MyParam)",myConnection)
  4. myCommand.CommandType = CommandType.Text
  5. myCommand.Parameters.Add(New Data.sqlClient.sqlParameter("@MyParam",input))
  6. myCommand.CommandTimeout = 0
  7. Try
  8. myCommand.ExecuteNonQuery()
  9. Catch ex As Exception
  10.  
  11. End Try
  12. End Using
  13.  
  14. End Using
  15. End Sub

或绕过它的程序……

  1. Create Procedure RunMyFunction(@MyParam as int)
  2. Select * FROM dbo.MyFunction(@MyParam)
  3. Go

猜你在找的VB相关文章