× 评论会员:米卡Wendelius 时间:2012/02/05
而不是SQL字符串传递到适配器创建一个
]为您的适配器,并使用该命令。当你这样做也有创造的SqlConnection。
所以是这样的:
Dim databaseConnection As New SqlConnection
Dim queryCommand As New SqlCommand
databaseConnection.ConnectionString = conStr
databaseConnection.Open
queryCommand.CommandText = " SELECT * FROM tblTest where Name=@NM and Rank=@RN"
queryCommand.Parameters.AddWithValue(" @NM" , someNMvariable)
queryCommand.Parameters.AddWithValue(" @RN" , someRNvariable)
queryCommand.Connection = databaseConnection
Dim dAdt As New SqlDataAdapter(queryCommand)
...
databaseConnection.Close
× 评论会员:AbhijitANA 时间:2012/02/05
检查了这一点,{A}]