Asp.net连接数据库例程(C#):

Asp.net连接SQL Server2000数据库例程(C#): using System.Data.SqlClient; private void Page_Load(object sender, System.EventArgs e) { SqlConnection myConnection;                          SqlCommand myCommand;                          DataSet ds;                          //1.connect to sql server                          myConnection = new SqlConnection( "server=localhost;database=Pubs;uid=ueytjdf;pwd=doekdf" );                          myConnection.Open();                          la1.text="Connection Opened!" ;                          //2.Create a table                          myCommand = new SqlCommand( "CREATE TABLE [test] ([id] [int] IDENTITY (1, 1) NOT NULL ,[name] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,[sex] [char] (10) COLLATE Chinese_PRC_CI_AS NULL )", myConnection );                          myCommand.ExecuteNonQuery();                          la2.text="New table created!" ;                          //2 添加纪录                          myCommand = new SqlCommand( "Insert into [test] (name,sex) values( '黄志文','男' )", myConnection ) ;                          myCommand.ExecuteNonQuery() ;                          la3.text="New Record Inserted!" ;                          //3 更新数据                          myCommand = new SqlCommand( "UPDATE [test] SET name='Smith' where name='李明'", myConnection ) ;                          myCommand.ExecuteNonQuery() ;                          la4.text="Record Updated!" ;                          //4 删除数据                          myCommand = new SqlCommand( "delete from [test] where name='Smith'", myConnection ) ;                          myCommand.ExecuteNonQuery() ;                          la5.text="Record Deleted!";                          //5 用DataGrid显示数据                          myCommand = new SqlCommand( "select * from [test]", myConnection ) ;                          MyDataGrid.DataSource=myCommand.ExecuteReader();                          MyDataGrid.DataBind() ; } ASP.net连接access数据库例程c#: using System.Data.OleDb; OleDbConnection myConnection; OleDbCommand myCommand; void page_load() {                          //1.连接数据库                          string dbname;                          dbname=Server.MapPath("authors.mdb");                          myConnection = new OleDbConnection( "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=" + dbname );                          myConnection.Open();                          la1.text="Connection Opened!";                          //2.添加记录                          myCommand = new OleDbCommand( "Insert INTO Authors(Authors,country) Values('Simson','usa')", myConnection );                          myCommand.ExecuteNonQuery();                          la2.text="New Record Inserted!";                          //3 更新数据(Access)                          myCommand = new OleDbCommand( "UPDATE Authors SET Authors='Bennett' WHERE Authors = 'Simson'", myConnection );                          myCommand.ExecuteNonQuery();                          la3.text="Record Updated!";                          //4 删除数据（access）                          myCommand = new OleDbCommand( "DELETE FROM Authors WHERE Authors = 'David'", myConnection );                          myCommand.ExecuteNonQuery();                          la4.text="Record Deleted!";                          //5 使用DateGrid显示数据                          myCommand = new OleDbCommand( "select * FROM Authors", myConnection );                          MyDataGrid.DataSource=myCommand.Executereader();                          MyDataGrid.DataBind();                  }

http://hi.baidu.com/jonesvale/blog/item/15afaecd2c66661800e9285f.html