problem med database
22System.Data.OleDb.OleDbException: No value given for one or more required parameters. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.OleDb.OleDbCommand.ExecuteReader() at ASP.default_aspx.rblAfstemning_SelectedIndexChanged(Object sender, EventArgs e) in C:\wwwhosting\tomo.dk\afstemning\Default.aspx:line 89denne fejl får jeg..
dette er koden:
try
opendb()
ObjConn = new OledbConnection(strConn)
objConn.Open()
sSql="SELECT Antalstemmer from Muligheder where Muligheder=" & rblafstemning.selecteditem.value & ";"
'visdata()
objCmd = new OledbCommand(sSql,ObjConn)
objRs = objCmd.ExecuteReader()
do while objrs.read()=true
Session("AntalStemmer") = objrs("AntalStemmer")
loop
closedb()
objconn.close()
catch t as exception
Response.write(t.tostring())
end try
jeg kan bare simpelthen ikke se hvor problemet er henne?
