vb.net 应用程序中的 System.Data.dll 中发生类型为“System.Data.SqlClient.SqlException"的第一次机会异常 [英] A first chance exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll in vb.net application

问题描述

我正在创建一个 vb.net 应用程序，其中出现错误'System.Data.SqlClient.SqlException' 类型的第一次机会异常发生在 System.Data.dll" 我不知道如何解决这个错误，有 4 个字段在表格中

I am creating a vb.net application in which I'm getting error " A first chance exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll" I dont know how to solve this error and there are 4 fields in tables

1. o_id 主键自增 1
2. c_id 静态
3. owner_name varchar()

4. 投资

1. o_id primary key auto increment by 1
2. c_id static
3. owner_name varchar()

4. investment

Dim connetionString As String

Dim cnn As SqlConnection

Dim cmd As New SqlCommand


connetionString = "Data Source=.\SQLEXPRESS;AttachDbFilename='C:\Users\javed\Documents\Visual Studio 2008\Projects\WindowsApplication1\WindowsApplication1\bin\Debug\Database1.mdf';Integrated Security=True;User Instance=True"

cnn = New SqlConnection(connetionString)

Try

    cnn.Open()
    MsgBox("Connection is Open ! ")
    cmd.Connection = cnn
    cmd.CommandText = "INSERT INTO owner_detail(c_id, o_name, investment) values(@cid,'" + TextBox1.Text + "','" + TextBox2.Text + "')"
    cmd.ExecuteNonQuery()
    MsgBox("Data is Successfully Inserted! ")
    cnn.Close()

Catch ex As Exception

    MsgBox("Can not open connection ! ")

End Try

推荐答案

您没有在任何地方添加参数 @cid.

You are not adding the parameter @cid anywhere.

cmd.Parameters.Add(new SqlParameter("@cid", SqlDbType.Int))
cmd.Parameters("@cid").Value = Idvalue

这篇关于vb.net 应用程序中的 System.Data.dll 中发生类型为“System.Data.SqlClient.SqlException"的第一次机会异常的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！