預(yù)習(xí)中軟國(guó)際卓越培訓(xùn)中心

ADO（ActiveDataObjects)是 續(xù)技術(shù)，提供對(duì)SQLSEVER等數(shù)據(jù)源的一致 （SQLSERVER\ACCESS\OLEDB等），ADO.NETDataSet是ADO.NET結(jié)構(gòu)的 元素是.NETFramawork 目前，.NETFramawork附帶了兩個(gè)數(shù)據(jù)提供程序：SQLServer和OLEDB數(shù)據(jù)提供程序。OLEDB數(shù)據(jù)提供程序位于System.Data.OleDbSQLServer OLEDBSQLServer提供程序OleDbSqlOleDbSqlusingusingusingusingusing; SQLSERVER namespace{class{staticvoidMain({stringconnStr=“server=(local);InitialCatalog=students;userId=sa;password=1234”;SqlConnectionconn=newSqlConnection(connStr);conn.Open(); mand(mandText=“SelectID,sNamefromstudent”;SqlDataReaderreader=cmd.ExecuteReader();stringoutput;while(reader.Read())output=string.Format({0}\t }reader.Close();conn.Close();}}usingusingusingusing;connStr變量，用來(lái)存放連接SQLSERVER的數(shù)據(jù)庫(kù)連接字符串。stringconnStr=“server=(local);InitialCatalog=students;userId=sa;password=1234”;SqlConnectionconn=newSqlConnection(connStr);conn.Open(); mand(mandText=“SelectID,sNamefromSqlDataReaderreader=cmd.ExecuteReader( while(reader.Read(output=string.Format({0}\t } reader.Close();conn.Close(); 用OLEDB數(shù)據(jù)提供程序時(shí)，要使用System.Data.OleDb空間的OleDbConnection對(duì)象，使用SQLServer數(shù)據(jù)提供

連接到SqlstringconnStr=“server=(local);InitialCatalog=students;userId=sa;password=1234”;SqlConnectionconn=newSqlConnection(connStr);conn.Open();SqlConnectionconn=newSqlConnection(“server=(local);InitialCatalog=students;userconn.Open(連接到Sql 接字符串賦值給Connection對(duì)象。如果不知道該對(duì)象是打開(kāi)stringconnStr=“server=(local);InitialstringconnStr=“DataSource=(local);InitialCatalog=students;userId=sa;password=1234”;InitialCatalog指明了連接使用的數(shù)據(jù)庫(kù)，userID和password則分別指明了數(shù)據(jù)庫(kù)時(shí)使用的用戶名和密 stringconnStr=“DataSource=(local);InitialCatalog=students;IntegratedSecurity=SSPI”;SqlConnection由自己的方法，如前面使用過(guò)的OpenClosed()方法。

啟動(dòng)，新建一個(gè)windows usingSystem.Data.Sql {SqlConnectionconn=newSqlConnection(id=sa;password=1234;initialCatalog=student;”;conn.Open();conn.Close();}catch(Exception} 連接OLEDB目前在網(wǎng)絡(luò)流行的小型數(shù)據(jù)庫(kù)access，就應(yīng)該使用OLEDBNET數(shù)據(jù)提供程序來(lái)數(shù)據(jù)，該程序在System.Data.OleDb空間中使用OLEDB.NETSQLSERVER.NET數(shù)據(jù)提 Source=mydb.mdb;userid=;password=; 略，在實(shí)際項(xiàng)目中，DataSource還必須轉(zhuǎn)化為絕對(duì)路徑。連接OLEDBusingSystem.Data.OleDb;

連接OLEDB{OleDbConnectionconn=newOleDbConnection(stringconnStr="Provider= .Jet.OLEDB.4.0;DataSource=";conn.Open();conn.Close();MessageBox.Show("關(guān)閉成功");}catch(Exception} 括為CRUD-CreateReadUpdate和Delete。 類型為TableDirect時(shí)，CommandText屬性為要 mand mand(象CommandText可以是從數(shù)據(jù)庫(kù)檢索數(shù)據(jù)的SQLSelect語(yǔ)句：stringCommandText=“select*fromstudent”； stringmandcmd=new mandcmd=newmand(ID,sName ExecuteScalar方法執(zhí)行返回單個(gè)值令，例如，想獲取數(shù)count(*)fromstudent。btnGetCount，以及l(fā)abel控件lblResult。stringcommandText=“selectcount(*)fromstringconnString=“DateSource=(local);InitialCatalog=students;userid=sa;password=1234”;SqlConnectionconn=newSqlConnection();mandcmd=new conn.Open();stringcount=cmd.ExecuteScalar().ToString();conn.Close();-1stringupdateQuery=“UPdatestudentSetsName=‘ SqlConnectionconn=newSqlConnection();mandcmd=new conn.Open();intRecordsAffected=cmd.ExecuteNonQuery();conn.Close(stringuserName=“ stringuserid=“200131500145”;stringupdateQuery=“UpdatestudentsName=‘”+userName+”’”+”WhereID=‘“+userid+”‘在SQLSERVER.NET UpdatestudentSetsName=@userNamewhereID=@userstringupdateQuery=“UpdatestudentSetsName=@userName”+”WhereID=@userid”;SqlConnectionconn=newSqlConnection(connectionString);mandcmd=new 對(duì)象。mand類提供了一個(gè)Parameters集合屬性，用以為命c(diǎn)md.Parameters.Add(“@userid”,userid); 在OLEDBNETOLEDB.NET并不支持指定參數(shù)的方法，但是可以在查詢中使用？來(lái)UpdatestudentSetsName=?Wheremandcmd=new cmd.Parameters.Add(“ID”,userid);數(shù)，兩句代碼如果調(diào)換前后順序，則userid的值賦值給第一個(gè)參數(shù)， boolCheckInfo({if(this.textbox1.Text.Trim(returnfalse;}elseif(this.textbox2.Text.Trim({MessageBox.Show(“ returnfalse;}returntrue;if(this.CheckInfo()){stringuserName=this.textbox2.Text.Trim(stringuserid=this.textbox1.Text.Trim(SqlConnectionconn=newSqlConnection(Catalog=student;userid=sa;password=1234”;stringupdateQuery=“updatestudentSetsName=‘”+userName+”‘“+”WhereID=‘”+userid+”mand conn.Open(int.ExecuteNonQuery();conn.Close();}if(this.CheckInfo()){stringuserName=this.textbox2.Text.Trim();stringuserid=this.textbox1.Text.Trim();SqlConnectionconn=newSqlConnection();Catalog=student;userid=sa;password=1234”;stringupdateQuery=“updatestudentSetsName=@userNameWhereID=@userid”;mand SqlParameter(“@userid”,userconn.Open(int.ExecuteNonQuery();conn.Close();}stringinsertQuery=“Insertintostudent ‘，’SqlConnectionconn=new ry,conn);conn.Open(intRecordsAffected=cmd.ExecuteNonQuery();conn.Close();stringdeleteQuery=“DeletefromstudentwhereSqlConnectionconn=newmandcmd=new conn.Open();intRecordsAffected=cmd.ExecuteNonQuery();conn.Close(); mandcmd=newSqlDataReaderreader=cmd.ExecuteReader(reader.Close( Item屬性是DataReader類的索引，總是基于0開(kāi)始編號(hào)的?？僧?dāng)執(zhí)行完SQL（selectID,sNamefromstudent)查詢后使用objectID=reader[“ID”];objectID=reader[0];objectsName=reader[1];intID=(int)reader[0]; intstring （３）在Ｆｏｒｍ１．ｃｓ中添加命名空間ｕｓｉｎｇＳｙ stringmessage=“OleDbConnectionconn=newOleDbConnection(); stringselectQuery=“selectID,sName,sGrade,s fromstudent”;mandcmd=new conn.Open(OleDbDataReader.ExecuteReader(CommandBehavior.CloseConnection);while(reader.read()){message+=“學(xué)號(hào)：”+reader[0].ToString()+”“;message+=“姓名：”+reader[“sName”].ToString()+”“;message+=“班級(jí)：”+reader.GetString(2)+”“;message+=“ “+reader.GetString(3)+”“;message+=“\n”;}reader.Close(stringmessage=“OleDbConnectionconn=newOleDbConnection(); stringselectQuery=“selectID,sName,sGrade,s fromstudent”;mandcmd=new conn.Open(OleDbDataReader.ExecuteReader(CommandBehavior.Cl