如何给SqlClient.SqlParameter类型赋值?
我现在想往SqlDataAdapter.SelectCommand.Parameters中赋多个值,代码如下:
Dim adapter As New SqlClient.SqlDataAdapter
Dim aa() As SqlClient.SqlParameter
Public userid As String
Public password As String
Userid= "DotNet"
Password="DotNet"
aa(0).Value = userid 此处总报错, 'System.NullReferenceException' のハンドルされていない
aa(1).Value = password
……
For Each cmdParms As SqlClient.SqlParameter In aa
adapter.SelectCommand.Parameters.Add(cmdParms)
Next
该如何给SqlClient.SqlParameter类型赋值?另外如何给object类型赋值?问题可能比较菜,还请大虾们帮忙啊.