02. oktober 2003 - 08:19Der er
11 kommentarer og 1 løsning
'Connection' is not a member of 'System.Data.SqlClient.SqlDataAda
Hej Eksperter Jeg er ny indenfor .net, så den her er sikkert ganske simpel. Jeg er ved at lave en login side.
Jeg får den her fejlmeddelese
BC30456: 'Connection' is not a member of 'System.Data.SqlClient.SqlDataAdapter'.
i den her linie
MyCommand.Connection.Open()
her er min kode
<script runat="server">
Sub Click(Obj as Object, e as Imageclickeventargs)
Dim connectionString As String = "server='xxx'; user id='xxxx'; password='xxxxx'; database='xxxxx'" Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString) Dim DS As New DataSet Dim reader as string
Dim MyConnection as New SqlConnection(connectionString) Dim MyCommand As New SqlDataAdapter("select * from netsiteusers where (username='" & username.Text & "') and (password='" & password.Text & "')" , MyConnection) MyCommand.Connection.Open()
reader = myCommand.ExecuteNonQuery()
MyCommand.Close() if reader > "" then Message.Text = "<br>Du er logget ind" Else Message.Text = "<br>Fejl i brugernavn eller password. Prøv igen" End If End Sub
'Connection' is not a member of 'System.Data.SqlClient.SqlDataAdapter' kunne jo godt give et hint om at SqlDataAdapteren 'MyCommand' ikke har funktionen Connection.
Nej! Det er den her du skal gøre det med: Dim MyConnection as New SqlConnection(connectionString) Og der er ikke, og har aldrig været en SqlDataAdapter.
Dim MyConnection as New SqlConnection(connectionString) MyConnection.Open() Dim MyCommand As New SqlDataAdapter("select * from netsiteusers where (username='" & username.Text & "') and (password='" & password.Text & "')" , MyConnection) reader = myCommand.ExecuteNonQuery() MyCommand.Close()
Dim MyCommand As New SqlCommand("select * from netsiteusers where (username='" & username.Text & "') and (password='" & password.Text & "')" , MyConnection)
Tak for hjælpen odegaard
Synes godt om
Ny brugerNybegynder
Din løsning...
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.