varchar转换为数字的错误? [英] error of conversion of varchar to numeric?

问题描述

(当我运行此代码时，它在"if(rdr.Read())"附近给出错误，未能将varchar转换为数值)
私有void Balance_Enquiry_Load(对象发送者，EventArgs e)
{
//label3.Visible = false;
SqlConnection con =新的SqlConnection(@数据源= ABHINAV-PC \ ABHI;集成安全性= true;初始目录= ATM;");
con.Open();
SqlCommand cmd =新的SqlCommand("select * from transaction where account_no =""+ label2.Text +"''，con);
SqlDataReader rdr = cmd.ExecuteReader();
如果(rdr.Read())
{
label2.Text = rdr ["total"].ToString();
}
rdr.Close();
rdr.Dispose();
con.Close();
}

(when i am running this code it is giving an error near "if(rdr.Read())" that failed to convert varchar to numeric)
private void Balance_Enquiry_Load(object sender, EventArgs e)
{
//label3.Visible = false;
SqlConnection con = new SqlConnection(@"data source=ABHINAV-PC\ABHI;integrated security=true;initial catalog=ATM;");
con.Open();
SqlCommand cmd = new SqlCommand("select * from transactions where account_no=''" + label2.Text + "''", con);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.Read())
{
label2.Text = rdr["total"].ToString();
}
rdr.Close();
rdr.Dispose();
con.Close();
}

推荐答案

您好
尝试这个，希望它能奏效

SqlCommand cmd =新的SqlCommand(从account_no ="的事务中选择* + Convert.ToInt16(label2.Text)+"''，con);

Hi
Try this hope this will work

SqlCommand cmd = new SqlCommand("select * from transactions where account_no=''" +Convert.ToInt16(label2.Text) + "''", con);

这篇关于varchar转换为数字的错误?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！