Converting string into int in database

Question

1.00/5 (1 vote)

See more:

ASPX.CS code

C#

int[] no = new int[100];
           int i = 0;
           DataTable dt = bl.BL_AutogerateKey(txt_req_form_id.Text);
           if (dt.Rows.Count == 0)
           {
               txt_req_form_id.Text = "1000001";
           }
           else
           {
               foreach (DataRow dr in dt.Rows)
               {                
                   no[i] = Convert.ToInt32(dr["FORM_ID"].ToString());
                   i++;
               }
              int auto = no.Max();
              txt_req_form_id.Text = "100000" + Convert.ToString(auto + 1);

DataLayer

C#

String str = "select substring(FORM_ID,5,50) as FORM_ID from PREV_REQUEST_TO_RECRUIT";
        SqlDataAdapter da = new SqlDataAdapter(str, con);
        DataSet ds = new DataSet();
        da.Fill(ds);
        DataTable dt = ds.Tables[0];
        return dt;

I am doing auto generation of form_id. but the value "100000" is storing as string in DB whereas I want this to be stored as int. what alteration should I do in C# code to change it as integer?

Posted 11-Nov-13 2:45am

sathish kumar

Add a Solution

3 solutions

Solution 1

You should change the database storage type - it's out of your applications hands when it's sent to SQL's processing - and the field type would seem to be a char type instead of an int in the database (I am relying upon your description of the problem).

SQL will then return the object as an int.

ASIDE: SQL has the ability to promote int's sent in as strings if required for storage - if they're convertible.

Posted 11-Nov-13 2:51am

W∴ Balboos, GHB

Comments

sathish kumar 11-Nov-13 9:26am

I have changed the DB to numeric(10,0). but instead of 1000001,1000002 adding like this the code adds 10000011000002 . Please help me

W∴ Balboos, GHB 11-Nov-13 9:42am

From your input, above:
txt_req_form_id.Text = "100000" + Convert.ToString(auto + 1);

You're "adding" text to text. In C#, the '+' sign is overloaded to concatenate to strings.
Also, I note that you seem to be working only with integers: make your field of type INT not NUMERIC - good up to about 2*10^9

This being said, I think you need to step back, take a breath, and consider what you want to do and what you're actually doing.

Also - if you're using these INT values as UNIQUE keys in your table (a primary key) - why not just declare the field IDENTITY and let SQL number it for you?
(If you don't want to start with 1, you can initialize the starting value to whatever you wish).

But try to get straight in your code/plan how you wish to handle these values - as numbers or strings, and stick to it except where absolutely necessary to cast/convert.

Solution 3

Change the column type in DB table column as int

Posted 26-Nov-13 6:05am

Karthik_Mahalingam

Updated 26-Nov-13 6:06am

v2

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)

sathish kumar · Accepted Answer · 2013-11-25T00:38:00

Solution 2

Replace

txt_req_form_id.Text = "100000" + Convert.ToString(auto + 1);

with

txt_req_form_id.Text = Convert.ToString((100000 + auto + 1));

Posted 25-Nov-13 0:38am

sathish kumar