how to convert string to int.

Question

4.00/5 (1 vote)

See more:

Hi,
how to convert string to int.
In my database table filed is integer field.
ex: Masterindustryid int

I want to get Masterindustryid 3,6,9,45,67 related records from another table company.

asp.net my string like "4,6,9,45,67"

I want to convert string to integer and pass to database.

my query is:

select c.id,c.name from company c join masterindustru mi on c.industryid=mi.Masterindustryid where c.industryid in(3,6,9,45,67)

Dynamically I passed a string using stored procedure.

Here I got convertion problem is string to int.

Please help me,
Thank you.

Posted 11-Aug-14 21:07pm

NagaRaju Pesarlanka

Updated 11-Aug-14 21:08pm

v2

Add a Solution

Comments

Kishor Deshpande 12-Aug-14 3:10am

How you are passing the values in in clause?

Would like to see the ADO.NET code involing this query...

Kumarbs 12-Aug-14 3:12am

What would you like to convert cid in select statement or something else?

NagaRaju Pesarlanka 12-Aug-14 3:24am

I want to pass dynamic parameter as a string type to stored procedure, like industry="3,5,8,9,87,34"
but my db field is integer, How can I pass where in clase.

Kumarbs 12-Aug-14 3:27am

Even if you use the IN operator in where clause you will get the output. Is there any specific reason to convert to int?

NagaRaju Pesarlanka 12-Aug-14 3:40am

my db field is integer, it is mandatory for this query.

_Asif_ 12-Aug-14 3:33am

Can you show us your SP code

NagaRaju Pesarlanka 12-Aug-14 3:39am

@industryids this is dynamic parameter, @industryids='4,6,35,45'
select c.id,c.name from company c join masterindustru mi on c.industryid=mi.Masterindustryid where c.industryid in(@industryids)

3 solutions

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)

_Asif_ · Answer 1 · 2014-08-11T21:44:00

Solution 2

You can use the Tip Using comma separated value parameter strings in SQL IN clauses[^] to get your issue resolved

Posted 11-Aug-14 21:44pm

_Asif_

Comments

NagaRaju Pesarlanka 12-Aug-14 4:09am

Think you this link code working...

Jameel VM · Answer 2 · 2014-08-11T21:21:00

Solution 1

Convert to you string to List<string>

C#

string str="1,2,3,4";
var lst=str.Split(',').ToList();

and then try the below code

C#

.Where(c => lst.Contains(c.industryid))

Hope this helps

Posted 11-Aug-14 21:21pm

Jameel VM

Updated 11-Aug-14 21:22pm

v2

Comments

NagaRaju Pesarlanka 12-Aug-14 3:25am

I want to pass dynamic parameter as a string type to stored procedure, like industry="3,5,8,9,87,34"
but my db field is integer, How can I pass where in clase.

Jameel VM 12-Aug-14 4:13am

use dynamic keyword

CPallini · Answer 3 · 2014-08-11T21:50:00

Solution 3

You got a conversion problem because your string contains a comma separated sequence of integers, not a single one. You have to first extract those integers (you may use the String.Split[^] method) and then convert such extracted integers.

Posted 11-Aug-14 21:50pm

CPallini