VB.NET操纵SQLServer

需要导入Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.oleDb

Visual Basic.NET图形图像编程与实例详解 - 是本好书
通过 SqlConnection对象连接SQLServer
然后通过SqlCommand 或 SqlDataAdapter  DataSet来操纵数据库。
Try
            Dim com As New SqlCommand()
            com.Connection = sqlcon

            Dim idd As New SqlParameter("@xn", SqlDbType.Int, 4)
            Dim username As New SqlParameter("@username", SqlDbType.Char, 20)
            Dim pass As New SqlParameter("@pass", SqlDbType.Char, 15)
            Dim m_part As New SqlParameter("@part", SqlDbType.Char, 100)
            Dim m_sov As New SqlParameter("@sov", SqlDbType.Char, 100)

            Dim str = "insert into userInfo (id,username,pass,所属部门,学历) values(@xn,@username,@pass,@part,@sov)"
            com.CommandText = str

            idd.Value = TextBox1.Text
            username.Value = TextBox2.Text
            pass.Value = TextBox3.Text
            m_part.Value = TextBox4.Text
            m_sov.Value = TextBox5.Text

            com.Parameters.Add(idd)
            com.Parameters.Add(username)
            com.Parameters.Add(pass)
            com.Parameters.Add(m_part)
            com.Parameters.Add(m_sov)

            com.ExecuteNonQuery()
        Catch ce As Exception
            MessageBox.Show("该用户已存在" + ce.Message)
        End Try

转载于:https://www.cnblogs.com/microsoftxiao/archive/2006/03/11/348055.html