Here is my Code How to Slove this problem resolve this problem of indexing

Question

0.00/5 (No votes)

See more:

this is the code of
"

VB

Private Sub GetQuantity()
       Try
           sqL = "SELECT StocksOnhand FROM Item WHERE ItemNo = " & txtItemNo.Text & ""
           ConnDB()
           cmd = New OleDbCommand(sqL, conn)
           dr = cmd.ExecuteReader(CommandBehavior.CloseConnection)
           If dr.Read = True Then
               getStocksOnHand = dr(0)


           End If
       Catch ex As Exception
           MsgBox(ex.Message)
       Finally
           cmd.Dispose()
           conn.Close()
       End Try
   End Sub

"

i want to get this code into in c# but in the line getStocksOnHand=dr(0);
there is the problem that " can not implicitly convert string to int.
how to solve it

Posted 10-Apr-14 21:22pm

Member 10720633

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

phil.o · Answer 1 · 2014-04-10T21:29:00

Solution 1

Indexer in C# is the bracket, not the parenthesis. Moreover, you seem to try to affect a string variable to an integer variable.
Thus, said line should be

C#

getStocksOnHand = int.Parse(dr[0].ToString());

Or a more robust way that would take care about wrong values:

C#

int value;
if (int.TryParse(dr[0].ToString(), out value)) {
   getStocksOnHand = value;
   // ...
}

Hope this helps.

Posted 10-Apr-14 21:29pm

phil.o

Updated 10-Apr-14 21:59pm

v3

Comments

Member 10720633 11-Apr-14 3:43am

i use upper code but error is that " the best overloaded method match for int.parse(string) has some invalid arguments
if (dr.Read == true)
{
getStocksOnHand = int.Parse(dr[0]);
}

Tom Marvolo Riddle 11-Apr-14 3:56am

Try this:

getStocksOnHand = int.Parse(dr[0].ToString());

phil.o 11-Apr-14 3:58am

Thank you for correcting :)

Tom Marvolo Riddle 11-Apr-14 4:00am

You're welcome :)