实例136SqlServer更新数据

1.打开SMSS，创建一个Login.mdf数据库

录入测试数据

2.VS2010，创建一个VB项目，添加数据源Login.mdf，并保存

3.设计窗体

4.代码

Imports System.Data.SqlClient
Public Class Form1
    Public Function GetConnection() As SqlConnection
        Return New SqlConnection(My.Settings.LoginConnectionString)
    End Function
    Dim conn As SqlConnection = GetConnection()

    Private Sub Display1()
        conn.Open()

        Dim strSql As String = "Select * from userTable"
        Dim comm As New SqlCommand(strSql, conn)
        Dim myReader As SqlDataReader =