We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Problem with OleDb.OleDbCommand.ExecuteScalar

ur_cherub
ur_cherub asked
on
Medium Priority
555 Views
Last Modified: 2013-12-25
Hi Experts,

I'm having a problem with the following piece of code.. Don't kno the reason for it and how to go bout correcting it...

---------------------------------

Dim Cmd1 As OleDb.OleDbCommand = New OleDb.OleDbCommand("SELECT UserName FROM Login WHERE UserName=" & txtUser.Text, Conn)

Dim userid As String = New String(CStr(Cmd1.ExecuteScalar))

---------------------------------

('txtUser' is a text box and 'conn' is an OleDbConnection). The error i'm getting is
      "No value given for one or more required parameters." for the second Dim statement...

pls help me out...
thank u...
Comment
Watch Question

Senior .Net Consultant
CERTIFIED EXPERT
Top Expert 2016
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Thank u very much emoreau...
very stupid of me to have left that out...

thanks a lot
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.