转换failedvarcher转换为int窗体 [英] conversion failedvarcher to int windows form

问题描述

从sql表中获取数据int passno



获取错误转换失败varchar转换为int



thx提前

fetching data from sql table int passno

getting error conversion failed varchar to int

thx in advance

 SqlDataAdapter da = new SqlDataAdapter("select * from VisitorPass where PassNo = '" + (vfind.SelectedValue.ToString()) + "'", objConn1);
<pre>            DataSet ds = new DataSet();
            da.Fill(ds, "VisitorPass");
            if (ds.Tables["VisitorPass"].Rows.Count > 0)
            {
                MainCombo.SelectedValue = ds.Tables["VisitorPass"].Rows[0]["PassType"].ToString();
                txtvpassno.Text = ds.Tables["VisitorPass"].Rows[0]["PassNo"].ToString();
                VdateTimePicker1.Value = Convert.ToDateTime(ds.Tables["VisitorPass"].Rows[0]["Date"].ToString());
                Dttimein.Value = Convert.ToDateTime(ds.Tables["VisitorPass"].Rows[0]["Timein"].ToString());
                Dttimeout.Value = Convert.ToDateTime(ds.Tables["VisitorPass"].Rows[0]["Timeout"].ToString());
                txtvpassno.Text = ds.Tables["VisitorPass"].Rows[0]["VisitorsName"].ToString();
                txtvpassno.Text = ds.Tables["VisitorPass"].Rows[0]["Purpose"].ToString();
                txtvpassno.Text = ds.Tables["VisitorPass"].Rows[0]["ToSee"].ToString();
                vauthcombo.SelectedValue = ds.Tables["VisitorPass"].Rows[0]["AuthorisedSign"].ToString();

推荐答案

试试这个

Try this

SqlDataAdapter da = new SqlDataAdapter("select * from VisitorPass where PassNo = " + (vfind.SelectedValue.ToString()), objConn1);

注意：看起来，PassNo列的类型为INT。确保vfind.SelectedValue.ToString（）仅包含数字而不包含字母数字数据。



希望它有所帮助：）

Note: It looks, "PassNo" column is of type INT. Make sure that "vfind.SelectedValue.ToString()" contains number only and not alpha-numeric data.

Hope it helps :)

这篇关于转换failedvarcher转换为int窗体的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！