与vb.net的sql连接 [英] sql connection with vb.net

问题描述

我想从vb.net应用程序在sql服务器表中添加数据，我的代码块是

i want to add data in sql server table from vb.net application,my code block is

Imports System.Data.SqlClient
Imports System.Data.SqlClient.SqlConnection

Public Class Form1
    Dim cn As SqlConnection

    Dim ConStr As String
    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        ConStr = "Data Source=ANAND-PC\SQLEXPRESS;Initial Catalog=anand;User ID=;Password="
        cn = New SqlConnection(ConStr)

    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim cmd As New SqlClient.SqlCommand
        Dim query As String
        query = "Insert Into anand1 (roll) values (" & TextBox1.Text & ");"

        cmd.CommandText = query
        cmd.CommandType = CommandType.Text
        cmd.Connection = cn

        cn.Open()

        cmd.ExecuteNonQuery()

        cn.Close()

    End Sub
End Class

它在cn.open
中显示了一些错误
请帮助非常紧急

it is showing some error in cn.open

please help its very urgent

推荐答案

修改您的连接字符串，提供用户名和密码！！！

modify your connection string ,provide user id and password!!!

这篇关于与vb.net的sql连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！