vb.net中的SQL Server连接 [英] connection in vb.net for sql server

问题描述

我想从vb.net应用程序在sql服务器表中添加数据，请帮帮我，

我的代码块是-:

i want to add data in a sql server table from vb.net applicattion pls help me,

my code block is-:

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

Public Class Form1
    Private 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 = "Integrated Security=SSPI;Initial Catalog=anand;Data Source=ANAND-PC\SQLEXPRESS;"

    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

推荐答案

嘿

请参考以下链接，它将帮助您与sqlserver连接
http://www.developerfusion.com/article/4278/using-adonet-with -sql-server/ [ ^ ]
祝你好运
幸福的编码

hey

refer following link it will help u to connect with sqlserver
http://www.developerfusion.com/article/4278/using-adonet-with-sql-server/[^]
Best Luck
happy Coding

请参阅此

http://forums.asp.net/t/1595437.aspx [ http://www.connectionstrings.com/sql-server-2005 [

Refer this

http://forums.asp.net/t/1595437.aspx[^]

for connection string refer this

http://www.connectionstrings.com/sql-server-2005[^]

请参阅:

如何连接到SQL Server在VB.NET中使用代码? [

Refer it:

HOW TO CONNECT TO SQL SERVER USING CODE IN VB.NET?[^]

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