ADO.NET
关注
分享
扫一扫
文章平均质量分 81
li_ping
这个作者很懒，什么都没留下…
展开
-
ado.net数据操作全接触一（insert,update,delete）
1.1创建数据库连接（sqlserver）1: 2: 3: 4: Dim myConnection As SqlConnection5: myConnection = New SqlConnection( "server=localhost;database=Pubs;uid=sa" )6:7: myConnection.Open()8: %>9: Connection Opened!1.2创建数原创 2005-03-02 10:49:00 · 635 阅读 · 0 评论 -
ado.net数据操作全接触三（存储过程，datasets）
6.1使用存储过程1: 2: 3:4: 5: Dim myConnection As SqlConnection6: Dim myCommand As SqlCommand7: Dim FirstName As String = "Robert"8: Dim LastName As String = "Johnson"9:10: myConnection = New SqlConnection(原创 2005-03-02 10:51:00 · 562 阅读 · 0 评论 -
ado.net数据操作全接触二（query，Parameters）
5.1使用SQLDataReader进行数据库查询1: 2: 3:4: 5: Dim myConnection As SqlConnection6: Dim myCommand As SqlCommand7: Dim myDataReader As SqlDataReader8:9: myConnection = New SqlConnection( "server=localhost;uid=s原创 2005-03-02 10:50:00 · 560 阅读 · 0 评论 -
ado.net数据操作全接触四（表关联，DataAdapter）
8.1创建一个（主/祥）表关联1: 2: 3:4: 5: Dim myConnection As SqlConnection6: Dim myDataAdapter As SqlDataAdapter7: Dim myDataSet As DataSet8: Dim myDataTable As DataTable9: Dim Publisher As DataRow10: Dim Title A原创 2005-03-02 10:52:00 · 662 阅读 · 0 评论 -
.NET中各种数据库连接大全
SQL Server ODBC Standard Security:"Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;" Trusted connection:"Driver={SQL Server};Server=Aron1;Database=pubs;Trusted_Connection=yes;" Prompt原创 2005-03-02 10:53:00 · 523 阅读 · 0 评论