VB6.0如何連接SQL server 2005

Public sqlcon As System.Data.SqlClient.SqlConnection

Public sqladapter As System.Data.SqlClient.SqlDataAdapter

Public command As System.Data.SqlClient.SqlCommand

Public ds As System.Data.DataSet

Public dr As System.Data.DataTable

sqlcon = New System.Data.SqlClient.SqlConnection

sqlcon.ConnectionString = "Server=服務器名; Initial Catalog=數據庫名 ; User ID=sa; Password=123"

ds = New System.Data.DataSet

dr = New System.Data.DataTable(" 表名 ")

ds.Tables.Add(dr)

sqladapter = New System.Data.SqlClient.SqlDataAdapter("select * from 表名", sqlcon)

sqlcon.Open()

sqladapter.Fill(dr)

sqlcon.Close()

上一篇:小賭養家糊口，大賭創家立業；還是小賭怡情，大賭傷身？

下一篇:菜鳥，問個php問題。$arr[]和$arr有什麽區別