在VB.NET中准备语句 [英] Prepared Statements in VB.NET

问题描述

我是新的在vb.net和Microsoft SQL Server 2008中准备语句。我真的找不到任何好的来源，通过连接字符串和执行预备语句连接到数据库。

I am new to prepared statements in vb.net and Microsoft SQL Server 2008. I can't really find any good sources for connecting to a database via connection string and executing prepared statements. Could someone show me an example or point me to a resource that might be useful?

推荐答案

准备的语句只不过是参数化的SqlCommands包含在内

Prepared statements are nothing but Parametrized SqlCommands enclosed in a Transaction.

例如，这是一个准备的语句：

For example, this is a Prepared Statement:

Using c As New SqlConnection(ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString)
   c.Open()
using mytransaction = c.BeginTransaction()

   Dim command = New SqlCommand("INSERT INTO yourtable(image) values (@image)", c)
   ''# this is specific to the FileUploadControl but the idea is to get the
   ''#image in a byte array; however you do it, it doesn't matter
    Dim buffer(FileUpload1.PostedFile.ContentLength) As Byte
    FileUpload1.PostedFile.InputStream.Read(buffer, 0, buffer.Length)
    command.Parameters.AddWithValue("@image", buffer)
    command.ExecuteNonQuery()    
 mytransaction .Commit()
End Using
End Using

这篇关于在VB.NET中准备语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！