表单关闭时出错。将数据类型varchar转换为numeric时出错。错误是在线dr.Read [英] Error on form close. error converting datatype varchar to numeric. The error is on line dr.Read

问题描述

Private Sub btstfidcmb_SelectedIndexChanged(sender As System.Object, e As System.EventArgs) Handles btstfidcmb.SelectedIndexChanged
       Dim con As New SqlConnection("Data Source=ASHUTOSH-PC\SQLEXPRESS;Initial Catalog=Art Station Management System;Integrated Security=True")
       Dim com As SqlCommand
       Dim dr As SqlDataReader
       'Dim s = CInt(btstfidcmb.Text)
       Try
           con.Open()
           Dim str As String
           str = "select * from StaffRegister where stfstaffid = '" & btstfidcmb.Text & "'"
           com = New SqlCommand(str, con)
           dr = com.ExecuteReader
           While dr.Read
               stfnametxt.Text = dr.GetString(1)
               stfmnametxt.Text = dr.GetString(2)
               stflnametxt.Text = dr.GetString(3)
           End While
           con.Close()
       Catch ex As SqlException
           MessageBox.Show(ex.Message)
       End Try
   End Sub

推荐答案

这是一个非常简单的错误，如果您知道如何调试，可以在几秒钟内自行修复。在com = New SqlCommand（str，con）行上设一个断点，我敢打赌你的变量str有where stfstaffid =''或btstfidcmb.Text中的其他非数字值。



所有你需要做的就是解决这个问题。

This is a very simple error that you could fix on your own within seconds if you know how to debug. Put a breakpoint on the line com= New SqlCommand(str, con) and I'll bet you that your variable str has "where stfstaffid = ''" or some other non-numeric value in btstfidcmb.Text.

All you have to do is fix that.

这篇关于表单关闭时出错。将数据类型varchar转换为numeric时出错。错误是在线dr.Read的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！