C#及ADONET操作数据库.pptVIP

使用C#和ADO.NET操作数据库 ; ConnectionString为数据库连接字符串。 Persist Security Info=False; Integrated Security= SSPI; database =northwind; server = mySQLServer 下面的例子创建一个 SqlConnection对象并设置它的一些属性。 public void CreateSqlConnection() { SqlConnection myConnection = new SqlConnection(); myConnection.ConnectionString=Persist Security Info=False;” + “Integrated Security=SSPI;database=northwind;” + “server=mySQLServer;Connect Timeout=30; myConnection.Open()； } ;;public void InsertRow(string myConnectionString) { // If the connection string is null, use a default. if(myConnectionString = = ) { myConnectionString =Provider=SQLOLEDB;Data Source = localhost; Initial Catalog=Northwind;+Integrated Security=SSPI;; } OleDbConnection myConnection = new OleDbConnection(myConnectionString); string myInsertQuery = INSERT INTO Customers (CustomerID, CompanyName) Values(NWIND, Northwind Traders); OleDbCommand myCommand = new OleDbCommand(myInsertQuery); myCommand.Connection = myConnection; myConnection.Open(); myCommand.ExecuteNonQuery(); myCommand.Connection.Close(); };;public void InsertRow(string myConnection) { // If the connection string is null, use a default. if(myConnectionString = = ) { myConnection=DRIVER={SQL Server};SERVER=MyServer; Trusted_connection=yes;DATABASE=northwind;; } OdbcConnection myConn = new OdbcConnection(myConnectionString); string myInsertQuery = INSERT INTO Customers (CustomerID, CompanyName) Values(NWIND, Northwind Traders); OdbcCommand myOdbcCommand = new OdbcCommand(myInsertQuery); myOdbcCommand.Connection = myConn; myConn.Open(); myOdbcCommand.ExecuteNonQuery(); myOdbcCommand.Connection.Close(); };OracleConnection的使用; Command对象是对数据存储执行命令的对象。 实际上，当从Connection对象中运行一条命令时，已经隐含地创建一个Command对象。但是Connection对象在处理命令的功能上受到一定的限制，而Command对象是特别为处理命令的各方面问题而创建的