String SrNo = cSerialNo.Text; String SrNumber; string s = System.Configuration.ConfigurationSettings.AppSettings.Get("Conn"); SqlConnection connection = new SqlConnection(s); connection.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connection; cmd.CommandText = ("SELECT c_SerialNo FROM Cultivator_tbl WHERE c_SerialNo=" +SrNo); SqlDataReader dr = cmd.ExecuteReader(); DataTable dt = new DataTable(); dt.Load(dr);//Error here cSerialNo.Text = dt.Rows[0][0].ToString(); SrNumber = dt.Rows[0][0].ToString(); if (SrNumber != "") { MessageBox.Show("SERIAL NO\t" + SrNumber + "\t ALREADY EXISTS"); } connection.Close();
ERROR:Conversion failed when converting the varchar value '311/3' to data type int.
varchar(50)
cmd.CommandText = ("SELECT c_SerialNo FROM Cultivator_tbl WHERE c_SerialNo= '" +SrNo +"'");
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)