Input string was not in a correct format error

Question

0.00/5 (No votes)

See more:

hi,
In my sql server database table i have a column of type float and it allow null values.
But when from my web form user left that column empty then get error message:

System.FormatException was unhandled by user code
Message="Input string was not in a correct format."

what to do handle this .
thanks

Posted 21-Dec-12 20:21pm

ruby kaur

Add a Solution

Comments

choudhary.sumit 22-Dec-12 2:26am

post your code here.

ruby kaur 27-Dec-12 6:35am

This is code from .cs file code

Collapse | Copy Code
protected void btnAdd_Click(object sender, EventArgs e)
{

if (objLotCreation.Insert(ddlDepot.SelectedValue, txtlotcode.Text.Trim(), txtDepo_stackno.Text.Trim(), txtSPECIES_Ename.Text.Trim(),
txtSPECIES_Uname.Text.Trim(), txtSPECIES_Kname.Text.Trim(), txtGrade.Text.Trim(), Convert.ToInt32(txtNo_of_pieces.Text),
txtLength_class.Text.Trim(), txtlblGirth_class.Text.Trim(), Convert.ToDouble(txtCubic_meter.Text), Convert.ToDouble(txtUpset_price.Text),
Convert.ToDouble(txtSale_Price.Text), Convert.ToInt32(Session["OfficeID"].ToString())))
{
lblStatus.Text = Resources.Language.Common_Record_Add;
}
BindGrid(Session["Language"].ToString());
clearfields();
}

This is business logic code
Collapse | Copy Code
public bool Insert(string Depot_Code, string Lot_Code, string Depo_stackno, string SPECIES_Ename, string SPECIES_Uname, string SPECIES_Kname, string Grade,
int No_of_pieces, string Length_class, string Girth_class, double Cubic_meter,double Upset_price,double Sale_Price,int DIV_ID)
{
bool res = false;
System.Collections.ArrayList sel = new System.Collections.ArrayList();

sel.Add("SP_m_LotCreation_Insert");
ArrayList lstParam = new System.Collections.ArrayList();

SqlParameter param;

param = new SqlParameter();
param.ParameterName = "@Depot_Code";
param.SqlDbType = SqlDbType.VarChar;
param.Value = Depot_Code;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@Lot_Code";
param.SqlDbType = SqlDbType.NVarChar;
param.Value = Lot_Code;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@Depo_stackno";
param.SqlDbType = SqlDbType.VarChar;
param.Value = Depo_stackno;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@SPECIES_Ename";
param.SqlDbType = SqlDbType.VarChar;
param.Value = SPECIES_Ename;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@SPECIES_Uname";
param.SqlDbType = SqlDbType.VarChar;
param.Value = SPECIES_Uname;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@SPECIES_Kname";
param.SqlDbType = SqlDbType.VarChar;
param.Value = SPECIES_Kname;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@Grade";
param.SqlDbType = SqlDbType.VarChar;
param.Value = Grade;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@No_of_pieces";
param.SqlDbType = SqlDbType.Int;
param.Value = No_of_pieces;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@Length_class";
param.SqlDbType = SqlDbType.VarChar;
param.Value = Depo_stackno;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@Girth_class";
param.SqlDbType = SqlDbType.VarChar;
param.Value = Girth_class;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@Cubic_meter";
param.SqlDbType = SqlDbType.Float;
param.Value = Cubic_meter;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@Upset_price";
param.SqlD

[no name] 22-Dec-12 2:35am

you should post your code.

ruby kaur 27-Dec-12 6:36am

This is code from .cs file code

Collapse | Copy Code
protected void btnAdd_Click(object sender, EventArgs e)
{

if (objLotCreation.Insert(ddlDepot.SelectedValue, txtlotcode.Text.Trim(), txtDepo_stackno.Text.Trim(), txtSPECIES_Ename.Text.Trim(),
txtSPECIES_Uname.Text.Trim(), txtSPECIES_Kname.Text.Trim(), txtGrade.Text.Trim(), Convert.ToInt32(txtNo_of_pieces.Text),
txtLength_class.Text.Trim(), txtlblGirth_class.Text.Trim(), Convert.ToDouble(txtCubic_meter.Text), Convert.ToDouble(txtUpset_price.Text),
Convert.ToDouble(txtSale_Price.Text), Convert.ToInt32(Session["OfficeID"].ToString())))
{
lblStatus.Text = Resources.Language.Common_Record_Add;
}
BindGrid(Session["Language"].ToString());
clearfields();
}

This is business logic code
Collapse | Copy Code
public bool Insert(string Depot_Code, string Lot_Code, string Depo_stackno, string SPECIES_Ename, string SPECIES_Uname, string SPECIES_Kname, string Grade,
int No_of_pieces, string Length_class, string Girth_class, double Cubic_meter,double Upset_price,double Sale_Price,int DIV_ID)
{
bool res = false;
System.Collections.ArrayList sel = new System.Collections.ArrayList();

sel.Add("SP_m_LotCreation_Insert");
ArrayList lstParam = new System.Collections.ArrayList();

SqlParameter param;

param = new SqlParameter();
param.ParameterName = "@Depot_Code";
param.SqlDbType = SqlDbType.VarChar;
param.Value = Depot_Code;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@Lot_Code";
param.SqlDbType = SqlDbType.NVarChar;
param.Value = Lot_Code;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@Depo_stackno";
param.SqlDbType = SqlDbType.VarChar;
param.Value = Depo_stackno;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@SPECIES_Ename";
param.SqlDbType = SqlDbType.VarChar;
param.Value = SPECIES_Ename;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@SPECIES_Uname";
param.SqlDbType = SqlDbType.VarChar;
param.Value = SPECIES_Uname;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@SPECIES_Kname";
param.SqlDbType = SqlDbType.VarChar;
param.Value = SPECIES_Kname;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@Grade";
param.SqlDbType = SqlDbType.VarChar;
param.Value = Grade;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@No_of_pieces";
param.SqlDbType = SqlDbType.Int;
param.Value = No_of_pieces;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@Length_class";
param.SqlDbType = SqlDbType.VarChar;
param.Value = Depo_stackno;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@Girth_class";
param.SqlDbType = SqlDbType.VarChar;
param.Value = Girth_class;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@Cubic_meter";
param.SqlDbType = SqlDbType.Float;
param.Value = Cubic_meter;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@Upset_price";
param.SqlD

AshishChaudha 22-Dec-12 6:06am

have you tried something??

[no name] 22-Dec-12 11:02am

code ????????

ruby kaur 27-Dec-12 6:36am

This is code from .cs file code

Collapse | Copy Code
protected void btnAdd_Click(object sender, EventArgs e)
{

if (objLotCreation.Insert(ddlDepot.SelectedValue, txtlotcode.Text.Trim(), txtDepo_stackno.Text.Trim(), txtSPECIES_Ename.Text.Trim(),
txtSPECIES_Uname.Text.Trim(), txtSPECIES_Kname.Text.Trim(), txtGrade.Text.Trim(), Convert.ToInt32(txtNo_of_pieces.Text),
txtLength_class.Text.Trim(), txtlblGirth_class.Text.Trim(), Convert.ToDouble(txtCubic_meter.Text), Convert.ToDouble(txtUpset_price.Text),
Convert.ToDouble(txtSale_Price.Text), Convert.ToInt32(Session["OfficeID"].ToString())))
{
lblStatus.Text = Resources.Language.Common_Record_Add;
}
BindGrid(Session["Language"].ToString());
clearfields();
}

This is business logic code
Collapse | Copy Code
public bool Insert(string Depot_Code, string Lot_Code, string Depo_stackno, string SPECIES_Ename, string SPECIES_Uname, string SPECIES_Kname, string Grade,
int No_of_pieces, string Length_class, string Girth_class, double Cubic_meter,double Upset_price,double Sale_Price,int DIV_ID)
{
bool res = false;
System.Collections.ArrayList sel = new System.Collections.ArrayList();

sel.Add("SP_m_LotCreation_Insert");
ArrayList lstParam = new System.Collections.ArrayList();

SqlParameter param;

param = new SqlParameter();
param.ParameterName = "@Depot_Code";
param.SqlDbType = SqlDbType.VarChar;
param.Value = Depot_Code;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@Lot_Code";
param.SqlDbType = SqlDbType.NVarChar;
param.Value = Lot_Code;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@Depo_stackno";
param.SqlDbType = SqlDbType.VarChar;
param.Value = Depo_stackno;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@SPECIES_Ename";
param.SqlDbType = SqlDbType.VarChar;
param.Value = SPECIES_Ename;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@SPECIES_Uname";
param.SqlDbType = SqlDbType.VarChar;
param.Value = SPECIES_Uname;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@SPECIES_Kname";
param.SqlDbType = SqlDbType.VarChar;
param.Value = SPECIES_Kname;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@Grade";
param.SqlDbType = SqlDbType.VarChar;
param.Value = Grade;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@No_of_pieces";
param.SqlDbType = SqlDbType.Int;
param.Value = No_of_pieces;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@Length_class";
param.SqlDbType = SqlDbType.VarChar;
param.Value = Depo_stackno;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@Girth_class";
param.SqlDbType = SqlDbType.VarChar;
param.Value = Girth_class;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@Cubic_meter";
param.SqlDbType = SqlDbType.Float;
param.Value = Cubic_meter;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@Upset_price";
param.SqlD

Surendra0x2 22-Dec-12 11:41am

May b type casting issue or ur not filing fload value in the textbox.

2 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)

Member 10510822 · Answer 1 · 2012-12-22T05:35:00

Hi,
It would better if you submitted your code. ok, as per your explanation, You are sending null value in database. this is not problem of course you can send null value in database but problem is when you are converting your null value in float type then the error occurs. because you can convert null value to float.

thank you.
Rashed::Bangladesh.

Member 10017719 · Answer 2 · 2014-04-08T21:10:00

Solution 4

Refer this:

Click Here[^]

Posted 8-Apr-14 21:10pm

Member 10017719