cONVERSION FAILED WEN CONVWERTING VARCHAR VALUE HELLO IN TO

Prudhvi Raj

9y878Learn iOS Programming

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using System.Data.SqlClient;

namespace Invoice_Genraton

{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

}

private void Form1_Load(object sender, EventArgs e)

{

}

private void textBox1_TextChanged(object sender, EventArgs e)

{

}

SqlDataAdapter da;

DataSet ds;

SqlConnection con;

private void btnSubmit_Click(object sender, EventArgs e)

{

con = new SqlConnection("Data Source=localhost;Initial Catalog=allcare;Integrated Security=True;Pooling=False");

da = new SqlDataAdapter("insert into [prudhvi] values('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','"

+ textBox4.Text + "','" + textBox5.Text + "','" + textBox6.Text + "','" + textBox7.Text + "','" + textBox8.Text + "','" +

textBox9.Text + "','" + textBox10.Text + "','" + "')", con);

ds = new DataSet();

da.Fill(ds);

Form2 f2 = new Form2();

this.Hide();

f2.label12.Text = textBox1.Text.ToString();

f2.label13.Text = textBox2.Text.ToString();

f2.label14.Text = textBox3.Text.ToString();

f2.label15.Text = textBox4.Text.ToString();

f2.label16.Text = textBox5.Text.ToString();

f2.label17.Text = textBox6.Text.ToString();

f2.label18.Text = textBox7.Text.ToString();

f2.label19.Text = textBox8.Text.ToString();

f2.label20.Text = textBox9.Text.ToString();

f2.label21.Text = textBox10.Text.ToString();

int n1 = int.Parse(textBox9.Text);

int n2 = int.Parse(textBox10.Text);

int total = n1 + n2;

f2.label22.Text = total.ToString();

f2.Show();

}

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P9y ago
please check your columns in your table prudhvi and passing parameter in your insert query. those must be in sequece order.
Prasath Balakrishnan9y ago
Hi Raj,

Here which field you are trying to converting and what is the input you are giving from the front end.Can you please give some clear info
Manas Mohapatra9y ago
As per error, it is sending incorrect datatype to prudhvi table. Like you one column int/bool and it is passing value as char format.

Inorder to resolve your problem, please recheck column datatype and pass correct value. Because here you are passing all textbox values as char format, recheck sequence parameter.

Secondly try to use parameterised query to avoid SQL injction.

https://www.aspsnippets.com/Articles/Using-Parameterized-queries-to-prevent-SQL-Injection-Attacks-in-SQL-Server.aspx
Dharmraj Thakur9y ago
Try this...
SqlConnection con;
SqlCommand cmd;
DataSet ds;

con = new SqlConnection("Data Source=localhost;Initial Catalog=allcare;Integrated Security=True;Pooling=False");
cmd = new SqlCommand("insert into [prudhvi](column1,column2,column3) values('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "')", con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();

Form2 f2 = new Form2();
this.Hide();
f2.label12.Text = textBox1.Text.ToString();
f2.label13.Text = textBox2.Text.ToString();
f2.label14.Text = textBox3.Text.ToString();
f2.label15.Text = textBox4.Text.ToString();
f2.label16.Text = textBox5.Text.ToString();
f2.label17.Text = textBox6.Text.ToString();
f2.label18.Text = textBox7.Text.ToString();
f2.label19.Text = textBox8.Text.ToString();
f2.label20.Text = textBox9.Text.ToString();
f2.label21.Text = textBox10.Text.ToString();

int total = Convert.ToInt32(textBox9.Text) + Convert.ToInt32(textBox10.Text);
f2.label22.Text = total.ToString();
f2.Show();
Ramesh Palanivel9y ago
Hi Prudhvi,

Kindly mention where you are getting error exactly?

Then only we can able to solve your issue..