如何使用VB在ASP中插入记录 [英] how to insert a record in asp using vb

问题描述

你好
我有一个要使用的数据输入表格，并将记录保存到表中.其强调"MYCOMMAND =新的SqlClient.SqlCommand(SQLSTR，MYCONNECTION)"

说没有定义SqlClient.SqlCommand ...

完整的代码写在下面

Hello
i have a data entry form that i want to use and save records into the a table . Its underlines "MYCOMMAND = New SqlClient.SqlCommand(SQLSTR, MYCONNECTION)"

saying SqlClient.SqlCommand is not defined ...

the full code is written below

Imports System
Imports System.Collections.Generic
Imports System.Linq
Imports System.Web
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports System.Data.SqlClient



Partial Class hazard_type
    Inherits System.Web.UI.Page
    Public MYCOMMAND As New SqlCommand
    Protected Sub btnsave_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnsave.Click
        Dim MYCONNECTION As String = "Data Source=NIFTY-PC\SQLEXPRESS;Initial Catalog=NRS_DATAMS;Trusted_Connection=Yes"

***************************************insert statememt
        Dim SQLSTR As String
        SQLSTR = ("INSERT INTO HAZARD_TYPE (HAZARD_TYPE)values" _
                  & "(''" & txthazard.Text & "'')")
         MYCOMMAND = New SqlClient.SqlCommand(SQLSTR, MYCONNECTION)
         MYCOMMAND.ExecuteNonQuery()

        MsgBox("Record Saved", MsgBoxStyle.Information, "Notifier")



    End Sub

    Protected Sub NewButton_Click(ByVal sender As Object, ByVal e As System.EventArgs)

    End Sub

End Class

[edit]已添加代码块-OriginalGriff [/edit]

[edit]Code block added - OriginalGriff[/edit]

推荐答案

尝试删除"sqlClient".位:

Try removing the "sqlClient." bit:

MYCOMMAND = New SqlClient.SqlCommand(SQLSTR, MYCONNECTION)

成为

MYCOMMAND = New SqlCommand(SQLSTR, MYCONNECTION)

因为顶部有

Because you have

Imports System.Data.SqlClient

，所以完全不需要限定对SqlCommand的使用.即使您确实想放入限定词，也需要完整的System.Data.SqlClient.SqlCommand来访问它！

at the top, you do not need to qualify your use of SqlCommand at all. Even if you did want to put the qualifier in, you would need the full System.Data.SqlClient.SqlCommand to access it!

这篇关于如何使用VB在ASP中插入记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！