adonet操作数据库总结用sqlconnection连接sqlver加入

《adonet操作数据库总结用sqlconnection连接sqlver加入》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、ADO.net操作数据库总结一．用SqlConnection连接SQLServer1..加入命名空间usingSystem.Data.SqlClient;2.连接数据库SqlConnectionmyConnection=newSqlConnection();myConnection.ConnectionString="userid=sa;password=sinofindb;initialcatalog=test;datasource=127.0.0.1;ConnectTimeout=30";myConnection.Open();改进（更通用）的方法：strin

2、gMySqlConnection="userid=sa;password=sinofindb;Database=test;datasource=127.0.0.1;ConnectTimeout=30";SqlConnectionmyConnection=newSqlConnection(MySqlConnection);myConnection.Open();二。用OleDbConnection连接1.加入命名空间usingSystem.Data.OleDb;2.连接sqlserverstringMySqlConnection="Provider=SQLOLEDB

3、;DataSource=localhost;InitialCatalog=test;IntegratedSecurity=SSPI;";SqlConnectionmyConnection=newSqlConnection(MySqlConnection);myConnection.Open();3.连接Access(可通过建立.udl文件获得字符串)stringMySqlConnection="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=c:db2000.mdb;PersistSecurityInfo=False;4.连

4、接Oracle(也可通过OracleConnection连接)stringMySqlConnection="Provider=MSDAORA;DataSource=db;userid=sa;password=sinofindb";三.创建Command对象1．SqlCommand构造函数ADO.net操作数据库总结第8页①初始化SqlCommand类的新实例。 publicSqlCommand(); SqlCommandmyCommand=newSqlCommand();②初始化具有查询文本的SqlCommand类的新实例。publicSqlCommand(str

5、ing); StringmySelectQuery="Select*FROMmindata"; SqlCommandmyCommand=newSqlCommand(mySelectQuery);③初始化具有查询文本和SqlConnection的SqlCommand类实例。 PublicSqlCommand(string,SqlConnection); StringmySelectQuery="Select*FROMmindata"; stringmyConnectString="user    id=sa;password=;database=test;serve

6、r=mySQLServer"; SqlConnectionmyConnection=newSqlConnection(myConnectString); SqlCommandmyCommand=newSqlCommand(mySelectQuery,myConnection);④初始化具有查询文本、SqlConnection和Transaction的SqlCommand类实例。 publicSqlCommand(string,SqlConnection,SqlTransaction); SqlTransactionmyTrans=myConnection.Begi

7、nTransaction(); StringmySelectQuery="Select*FROMmindata"; stringmyConnectString="user  id=sa;password=;database=test;server=mySQLServer"; SqlConnectionmyConnection=newSqlConnection(myConnectString); SqlCommandmyCommand=newSqlCommand(mySelectQuery,myConnection,myTrans);2.建立SqlCommand与S

8、qlCon