can any solve this? its showing me Input string was not in a correct format.../..

Question

0.00/5 (No votes)

See more:

C#

private void bind()
     {
         SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);

         SqlDataAdapter da = new SqlDataAdapter("select * from employee1", con);
         DataSet ds = new DataSet();


         da.Fill(ds);

         datalist1.DataSource = ds;
         datalist1.DataBind();
     }

     protected void datalist1_ItemCommand(object source, DataListCommandEventArgs e)
     {

     }

     protected void datalist1_ItemDataBound(object sender, DataListItemEventArgs e)
     {
         if (e.Item.ItemType == ListItemType.Footer)
         {

             TextBox textid = e.Item.FindControl("textid") as TextBox;

             TextBox textname = e.Item.FindControl("textname") as TextBox;
             TextBox textaddress = e.Item.FindControl("textaddress") as TextBox;
             TextBox texteducation = e.Item.FindControl("texteducation") as TextBox;
             SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);
             SqlCommand cmd = new SqlCommand("Insert into employee1(emp_id,emp_name,emp_address,emp_education values(@1,@2,@3,@4)",con);
             cmd.Parameters.Add("@1", SqlDbType.Int).Value = Convert.ToInt32(textid.Text);
             cmd.Parameters.Add("@2", SqlDbType.NChar,10).Value = textname.Text;
             cmd.Parameters.Add("@3", SqlDbType.NChar,10).Value = textaddress.Text;
             cmd.Parameters.Add("@4", SqlDbType.NChar,10).Value=texteducation.Text;
             con.Open();
             cmd.ExecuteNonQuery();
             con.Close();
             bind();

[Update]
Server Error in '/' Application.

Input string was not in a correct format.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.FormatException: Input string was not in a correct format.

Source Error:

Line 59: SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);
Line 60: SqlCommand cmd = new SqlCommand("Insert into employee1(emp_id,emp_name,emp_address,emp_education values(@1,@2,@3,@4)",con);
Line 61: cmd.Parameters.Add("@1", SqlDbType.Int).Value = Convert.ToInt32("textid.Text");
Line 62: cmd.Parameters.Add("@2", SqlDbType.NChar,10).Value = textname.Text;
Line 63: cmd.Parameters.Add("@3", SqlDbType.NChar,10).Value = textaddress.Text;

Source File: C:\Users\Vishal\downloads\documents\visual studio 2010\Projects\WebApplication2\WebApplication2\datalist.aspx.cs Line: 61

Stack Trace:

[FormatException: Input string was not in a correct format.]
System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) +11177559
System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) +145
System.Convert.ToInt32(String value) +43
WebApplication2.WebForm1.datalist1_ItemDataBound(Object sender, DataListItemEventArgs e) in C:\Users\Vishal\downloads\documents\visual studio 2010\Projects\WebApplication2\WebApplication2\datalist.aspx.cs:61
System.Web.UI.WebControls.DataList.OnItemDataBound(DataListItemEventArgs e) +9579420
System.Web.UI.WebControls.DataList.CreateItem(Int32 itemIndex, ListItemType itemType, Boolean dataBind, Object dataItem) +151
System.Web.UI.WebControls.DataList.CreateControlHierarchy(Boolean useDataSource) +9580357
System.Web.UI.WebControls.BaseDataList.OnDataBinding(EventArgs e) +63
System.Web.UI.WebControls.BaseDataList.DataBind() +54
WebApplication2.WebForm1.bind() in C:\Users\Vishal\downloads\documents\visual studio 2010\Projects\WebApplication2\WebApplication2\datalist.aspx.cs:39
WebApplication2.WebForm1.Page_Load(Object sender, EventArgs e) in C:\Users\Vishal\downloads\documents\visual studio 2010\Projects\WebApplication2\WebApplication2\datalist.aspx.cs:19
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +51
System.Web.UI.Control.OnLoad(EventArgs e) +92
System.Web.UI.Control.LoadRecursive() +54
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +772

Posted 19-Nov-15 18:43pm

vishal goyal

Updated 19-Nov-15 20:33pm

Patrice T

v2

Add a Solution

Comments

Garth J Lancaster 20-Nov-15 0:49am

where is it giving you the error ? have you put a breakpoint in above this [error point] and stepped down to the error point inspecting the variables ?

PIEBALDconsult 20-Nov-15 0:57am

Probably in Convert.ToInt32(textid.Text)
Never use Convert; try using Int32.TryParse instead.
And use the debugger to see what the value is.

[no name] 20-Nov-15 1:23am

Match the column data type with provided parameter type. Might be there will be issue with Convert.ToInt32(textid.Text). Post your full error message and stack trace.

vishal goyal 20-Nov-15 1:42am

Server Error in '/' Application.

Input string was not in a correct format.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.FormatException: Input string was not in a correct format.

Source Error:

Line 59: SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);
Line 60: SqlCommand cmd = new SqlCommand("Insert into employee1(emp_id,emp_name,emp_address,emp_education values(@1,@2,@3,@4)",con);
Line 61: cmd.Parameters.Add("@1", SqlDbType.Int).Value = Convert.ToInt32("textid.Text");
Line 62: cmd.Parameters.Add("@2", SqlDbType.NChar,10).Value = textname.Text;
Line 63: cmd.Parameters.Add("@3", SqlDbType.NChar,10).Value = textaddress.Text;

Source File: C:\Users\Vishal\downloads\documents\visual studio 2010\Projects\WebApplication2\WebApplication2\datalist.aspx.cs Line: 61

Stack Trace:

[FormatException: Input string was not in a correct format.]
System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) +11177559
System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) +145
System.Convert.ToInt32(String value) +43
WebApplication2.WebForm1.datalist1_ItemDataBound(Object sender, DataListItemEventArgs e) in C:\Users\Vishal\downloads\documents\visual studio 2010\Projects\WebApplication2\WebApplication2\datalist.aspx.cs:61
System.Web.UI.WebControls.DataList.OnItemDataBound(DataListItemEventArgs e) +9579420
System.Web.UI.WebControls.DataList.CreateItem(Int32 itemIndex, ListItemType itemType, Boolean dataBind, Object dataItem) +151
System.Web.UI.WebControls.DataList.CreateControlHierarchy(Boolean useDataSource) +9580357
System.Web.UI.WebControls.BaseDataList.OnDataBinding(EventArgs e) +63
System.Web.UI.WebControls.BaseDataList.DataBind() +54
WebApplication2.WebForm1.bind() in C:\Users\Vishal\downloads\documents\visual studio 2010\Projects\WebApplication2\WebApplication2\datalist.aspx.cs:39
WebApplication2.WebForm1.Page_Load(Object sender, EventArgs e) in C:\Users\Vishal\downloads\documents\visual studio 2010\Projects\WebApplication2\WebApplication2\datalist.aspx.cs:19
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +51
System.Web.UI.Control.OnLoad(EventArgs e) +92
System.Web.UI.Control.LoadRecursive() +54
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +772

[no name] 20-Nov-15 2:29am

Debug the value for textid.Text.Probable Its not an integer while you converting it.

vishal goyal 20-Nov-15 2:36am

its showing me null value for textid

[no name] 20-Nov-15 2:44am

So you need to check for null before converting it to int.

Arasappan 20-Nov-15 1:29am

Show your db design

vishal goyal 20-Nov-15 1:39am

emp_id int
emp__name nchar(10)
emp_address nchar(10)
emp_education nchar(10)

Arasappan 20-Nov-15 1:49am

Is your Input more than the 10 ..

like KINGMAKER=9
KINGMAKER1=10
KINGMAKER11=11..not in correct format

vishal goyal 20-Nov-15 2:08am

no..its less than 10

Arasappan 20-Nov-15 2:11am

Use My Solution

Arasappan 20-Nov-15 2:11am

First Open The Con then Query Then Close

vishal goyal 20-Nov-15 2:15am

yes i did..bt showing me same error

Arasappan 20-Nov-15 2:17am

MAke Break point then run

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)

Abhinav S · Answer 1 · 2015-11-19T18:50:00

Solution 1

Check the various database types versus what you are passing into the query.
There is a type mismatch between what you send versus the parameters / table schema.

Posted 19-Nov-15 18:50pm

Abhinav S

Arasappan · Answer 2 · 2015-11-19T19:56:00

Solution 3

C#

TextBox textid = e.Item.FindControl("textid") as TextBox;
  int id = int.Parse(textid.Text);
  cmd.Parameters.Add("@1", SqlDbType.Int).Value = id;

First Open the cOnnection

C#

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);
con.Open();
Query
Con.Close();

Posted 19-Nov-15 19:56pm

Arasappan

Updated 19-Nov-15 20:10pm

v2

Comments

Arasappan 20-Nov-15 2:21am

whats happen when using this solution

vishal goyal 20-Nov-15 2:30am

showing same error

Arasappan 20-Nov-15 2:30am

Dd u use break point

vishal goyal 20-Nov-15 2:33am

yes..

Arasappan 20-Nov-15 2:37am

Wheres the error appear;

Arasappan 20-Nov-15 2:37am

Use f10 for step by step

Naveen.Sanagasetti · Answer 3 · 2015-11-19T19:49:00

Problem is in this line

C#

SqlCommand cmd=new SqlCommand(Insert into
employee1(emp_id,emp_name,emp_address,emp_education values(@1,@2,@3,@4)",con);

Replace with

C#

SqlCommand cmd=new SqlCommand(Insert into
employee1(emp_id,emp_name,emp_address,emp_education) values(@1,@2,@3,@4)",con);

You need to close the brace ")" after column declaration completed, after closing if you still face the same problem then I request you to please compare your database datatypes and your code datatypes, both should be same.