PGlabo

« [ASP.NET|SQL Server] SQLServer認証 と WINDOWS認証 | メイン | [ASP.NET] DataGrid （特定の列のみ表示） »

2005年10月06日

[ASP.NET|SQL Server] SQL Server に接続

 
       Dim Conn As New System.Data.SqlClient.SqlConnection
       Dim Cmd As New System.Data.SqlClient.SqlCommand

        Conn.ConnectionString = "server=localhost;User=sa;Password=;database=TEST;"

        Cmd.Connection = Conn

        Cmd.CommandText = "SELECT * FROM UserTable ORDER BY UserName ASC"

        Dim Conn As System.Data.SqlClient.SqlConnection
        Dim Cmd As System.Data.SqlClient.SqlCommand
 
        Conn = New SqlConnection("server=localhost;User ID=sa;Password=;database=TEST;")
        Conn.Open()

        Cmd = New SqlCommand("SELECT * FROM UserTable ORDER BY UserName ASC", Conn)

        '終了処理
        Cmd.Dispose()
        Conn.Dispose()

2005 / 10 / 06