ado.net数据操作全接触四(表关联,DataAdapter)

原创 2005年03月02日 10:52:00
8.1创建一个(主/祥)表关联
1: <%@ Import Namespace="System.Data" %>
2: <%@ Import NameSpace="System.Data.SqlClient" %>
3:
4: <%
5: Dim myConnection As SqlConnection
6: Dim myDataAdapter As SqlDataAdapter
7: Dim myDataSet As DataSet
8: Dim myDataTable As DataTable
9: Dim Publisher As DataRow
10: Dim Title As DataRow
11:
12: myConnection = New SqlConnection( "server=localhost;uid=sa;pwd=secret;database=Pubs" )
13: myDataSet = New DataSet()
14: myDataAdapter = New SQLDataAdapter( "Select * From Publishers",
http://aspfree.com/chapters/sams/graphics/ccc.gifmyConnection )
15: myDataAdapter.Fill( myDataSet, "Publishers" )
16: myDataAdapter.SelectCommand = New SqlCommand( "Select * From Titles",
http://aspfree.com/chapters/sams/graphics/ccc.gifmyConnection )
17: myDataAdapter.Fill( myDataSet, "Titles" )
18:
19: myDataSet.Relations.Add( "PubTitles",
http://aspfree.com/chapters/sams/graphics/ccc.gifmyDataSet.Tables( "Publishers" ).Columns( "pub_id" ),
http://aspfree.com/chapters/sams/graphics/ccc.gifmyDataSet.Tables( "Titles" ).Columns( "pub_id" ) )
20:
21: For Each Publisher in myDataSet.Tables( "Publishers" ).Rows
22: Response.Write( "<p>" & Publisher( "pub_name" ) & ":" )
23: For Each Title In Publisher.GetChildRows( "PubTitles" )
24: Response.Write("<li>" & Title( "title" ) )
25: Next
26: Next
27:
28: %>
29:
9.1使用DataAdapter UPDATE模式
1: <%@ Import Namespace="System.Data" %>
2: <%@ Import NameSpace="System.Data.SqlClient" %>
3:
4: <%
5: Dim myConnection As SqlConnection
6: Dim myDataAdapter As SqlDataAdapter
7: Dim myBuilder As SqlCommandBuilder
8: Dim myDataSet As DataSet
9: Dim myDataTable As DataTable
10: Dim Author As DataRow
11:
12: ' Create the DataSet and DataAdapter
13: myConnection = New SqlConnection( "server=localhost;uid=sa;pwd=secret;database=Pubs" )
14: myDataSet = New DataSet()
15: myDataAdapter = New SqlDataAdapter( "Select * From Author", myConnection )
16: myDataAdapter.Fill( myDataSet, "Authors" )
17:
18: ' Change value of first row
19: myDataSet.Tables( "Authors" ).Rows( 0 ).Item( "au_fname" ) = "Jane"
20:
21: ' Update the Database Table
22: myBuilder = New SqlCommandBuilder( myDataAdapter )
23: myDataAdapter.Update( myDataSet, "Authors" )
24:
25: ' Display the Records
26: For Each Author in myDataSet.Tables( "Authors" ).Rows
27: Response.Write( "<p>" & Author( "au_fname" ) & " "
http://aspfree.com/chapters/sams/graphics/ccc.gif& Author( "au_lname" ) )
28: Next
29: %>
30:
9.2使用DataAdapter UPDATE模式(C#)


1: <%@ Page Language="C#" %>
2: <%@ Import Namespace="System.Data" %>
3: <%@ Import NameSpace="System.Data.SqlClient" %>
4:
5: <%
6: // Create the DataSet and DataAdapter
7: SqlConnection myConnection = new
http://aspfree.com/chapters/sams/graphics/ccc.gifSqlConnection( "server=localhost;uid=sa;pwd=secret;database=Pubs" );
8: DataSet myDataSet = new DataSet();
9: SqlDataAdapter myDataAdapter = new SqlDataAdapter(
http://aspfree.com/chapters/sams/graphics/ccc.gif"Select * From Authors3", myConnection );
10: myDataAdapter.Fill( myDataSet, "Authors" );
11:
12: // Change value of first row
13: myDataSet.Tables[ "Authors" ].Rows[ 0 ][ "au_fname" ] = "Jane";
14:
15: // Update the Database Table
16: SqlCommandBuilder myBuilder = new SqlCommandBuilder( myDataAdapter );
17: myDataAdapter.Update( myDataSet, "Authors" );
18:
19: // Display the Records
20: foreach ( DataRow Author in myDataSet.Tables[ "Authors" ].Rows )
21: {
22: Response.Write( "<p>" + Author[ "au_fname" ] + " "
http://aspfree.com/chapters/sams/graphics/ccc.gif+ Author[ "au_lname" ] );
23: }
24: %>
25:

ado.net数据操作全接触四(表关联,DataAdapter)

  • zgqtxwd
  • zgqtxwd
  • 2008年05月01日 04:25
  • 244

ADO.NET——DataAdapter对象

DataAdapter对象    来源以及作用:前面我所介绍的ADO.NET对象中,例如Connection对象,Command对象以及DataReader对象,这些对象均属于Data Provide...
  • u013067402
  • u013067402
  • 2015年05月18日 15:36
  • 1483

ADO.NET技术简介(二)获取数据库数据DataAdapter、DataReader、DataSet

一、DataAdapter 获取数据库数据最常用的办法是使用DataAdapter然后填充到DataSet public static DataSet SelectDat( ) { ...
  • vvhesj
  • vvhesj
  • 2014年02月10日 15:13
  • 1561

ado.net数据操作全接触

ado.net数据操作全接触一(insert,update,delete)window.attachEvent("onload",function (){AutoSizeDIV(CODE_4439)}...
  • deepbluekk
  • deepbluekk
  • 2006年03月14日 23:59
  • 492

ADO.NET 之核心组成对象

引言:在当今数据信息丰富的时代,计算机领域中使用数据库来存储信息和访问信息,但是本身数据库种类有很多,例如SQL Server,Oracle,Access,MySql等,因此,如何能更加高效、更加...
  • u013067402
  • u013067402
  • 2015年05月17日 16:54
  • 1372

浅析ADO.NET中利用DataAdapter进行数据操作

         对于刚刚学习ADO.NET数据访问技术的来说,DataAdapter也许往往会令他们感到迷惑,特别是习惯于利用托拽DataAdapter控件进行开发的朋友,通过这一ADO.NET数据...
  • liyufeng1983
  • liyufeng1983
  • 2006年06月30日 18:44
  • 1961

ado.net数据操作全接触三(存储过程,datasets)

6.1使用存储过程1: 2: 3:4: 5: Dim myConnection As SqlConnection6: Dim myCommand As SqlCommand7: Dim FirstNa...
  • redrainy
  • redrainy
  • 2007年02月25日 14:24
  • 432

ado.net数据操作全接触一(insert,update,delete)

  • zgqtxwd
  • zgqtxwd
  • 2008年05月01日 03:28
  • 62

ado.net数据操作全接触二(query,Parameters)

5.1使用SQLDataReader进行数据库查询1: 2: 3:4: 5: Dim myConnection As SqlConnection6: Dim myCommand As SqlComma...
  • redrainy
  • redrainy
  • 2007年02月25日 14:25
  • 391

ado.net数据操作全接触一(insert,update,delete

1.1创建数据库连接(sqlserver)1: 2: 3: 4: Dim myConnection As SqlConnection5: myConnection = New SqlConnectio...
  • redrainy
  • redrainy
  • 2007年02月25日 14:27
  • 375
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:ado.net数据操作全接触四(表关联,DataAdapter)
举报原因:
原因补充:

(最多只允许输入30个字)