how to convert var type variable to int

Question

0.00/5 (No votes)

See more:

i am using var type variable in ForEach loop and i am assining it integer arry how can i convert it to int type, below is my code

C#

foreach (var item in this.checkedListBox1.CheckedItems)
           {        
                  
                       da.ProcName = "AssignSubjectToStudent";//calling stored procedure
                       da.OpenDBConnection();
                       da.CreateCommandObject();         
                   da.Parameters("@KeyStudent", int.Parse(txtStudent.SelectedValue.ToString()));
                       da.Parameters("@KeySubject",int.Parse(item) );// it can not be converted
                       da.ExecuteNonQuery();
                 
           }
           da.CloseConnection();
           empty();

Posted 22-May-14 20:53pm

Abdullah Kundi

Updated 22-May-14 20:56pm

v2

Add a Solution

Comments

Bh@gyesh 23-May-14 3:01am

Var type can take any datatype which is assigned it first. here item is var type so it is assigned as checkboxlist object.

You are passing keysubject as argument with int type conversion but item is an object type. so I think it is invalid. You should pass some other value i.e. item.count or item.selectedvalue etc...

DamithSL 23-May-14 3:20am

how you bind checkedListBox1? please update the question with that code

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)

Nithin Sundar · Answer 1 · 2014-05-22T21:31:00

var is supposed to be used in areas where you are not really sure of the datatype which is returned.

You intend the value to be converted into a int so I suppose you know the datatype.

You cannot always expect a conversion as it actually depends on the data present in your variable. You can instead try to avoid errors with the following:

int nNumber = -1;

bool bIsConversionDone = Int32.TryParse(item, out nNumber);

if(!bIsConversionDone)
{
    //Conversion failed
    nNumber = -1;
}

da.Parameters("@KeySubject",int.Parse(nNumber) );// it can not be converted

Karen Mitchelle · Answer 2 · 2014-05-22T21:10:00

Solution 2

Hi,
You can use Convert.Int32(item)

May I ask, why do you use var when you're going to convert it to int afterwards? Isn't it more convenient if you declare it as int and not to convert it after?

Posted 22-May-14 21:10pm

Karen Mitchelle

Comments

Abdullah Kundi 23-May-14 3:26am

thanks for reply, but it gives error ,"Specified cast is not valid."
foreach (int item in this.checkedListBox1.CheckedItems)

Pikoh 23-May-14 3:30am

you can't convert item to int. Someone told you up,use int.Parse(item.value).

Abdullah Kundi 23-May-14 3:50am

error object does not contain definition for value.
foreach (var item in this.checkedListBox1.CheckedItems)
{

da.ProcName = "AssignSubjectToStudent";
da.OpenDBConnection();
da.CreateCommandObject();
da.Parameters("@KeyStudent", int.Parse(txtStudent.SelectedValue.ToString()));
da.Parameters("@KeySubject", int.Parse(item.value));
da.ExecuteNonQuery();

}
da.CloseConnection();
empty();

Pikoh 23-May-14 3:56am

Sorry,didn't notice it was a chekedListBox...so checkedListBox1 is a list of strings. What do you want exactly to add to @keysubject? the index of the checked item? if so,define an int variable before the foreach,use the foreach of all items,ask if item is checked,if so execute query and finally increment variable.

UPDATE:
i'm not too awake as i'd like. use this instead

foreach(int indexChecked in checkedListBox1.CheckedIndices) {

db.Parameters["@keySubject"],indexChecked);
}

Abdullah Kundi 23-May-14 6:46am

it have a logical error. Sir ji.

Animesh Datta · Answer 3 · 2014-05-22T21:07:00

Solution 1

Hello ,
If you are using CheckedListBox then find any item by this way

(string)checkedListBox1.Items[i];//here i is the position of the selcted value

Now put this value into the store procedure
thanks

Posted 22-May-14 21:07pm

Animesh Datta

Comments

Abdullah Kundi 23-May-14 3:21am

thanks dear your logic is good but actualy i want to send database value member of selected items
in checkedlistbox, your code gives an error that Nvarchar value can'nt be converted to int,
the attribute in my table is of int type

Animesh Datta 23-May-14 4:06am

have your problem solved ?

Animesh Datta 23-May-14 3:34am

please select poper index of the column which you want to convert into Integer

how to convert var type variable to int

3 solutions

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us