c連接SQL數(shù)據(jù)庫的使用方法

1、最佳答案提取單條記錄/usingSystem.Data;/usingSystem.Data.SqlClient;using(SqlConnectioncn=newSqlConnection(%1)/ConfigurationManager.ConnectionStringsdb2ConnectionString.ConnectionString/DataSource=myServerAddress;InitialCatalog=myDataBase;UserId=myUsername;Password=myPassword;SqlCommandcmd=newSqlCommand(SelectC

2、ount(*)Fromjobs,cn);cn.Open();%2=cmd.ExecuteScalar();/Message.InnerHtml單值比較/usingSystem.Data;/usingSystem.Data.SqlClient;using(SqlConnectioncn=newSqlConnection(%1)/ConfigurationManager.ConnectionStringsdb2ConnectionString.ConnectionString/DataSource=myServerAddress;InitialCatalog=myDataBase;UserId=m

3、yUsername;Password=myPassword;SqlCommandcmd=newSqlCommand(SelectCount(*)Fromjobs,cn);cn.Open();%2=cmd.ExecuteScalar();/Message.InnerHtmlif(%2=%3)%4顯示表格/usingSystem.Data;/usingSystem.Data.SqlClient;DataSetds=null;using(SqlConnectioncn=newSqlConnection(%1)/ConfigurationManager.ConnectionStringsdb2Conn

4、ectionString.ConnectionString/DataSource=myServerAddress;InitialCatalog=myDataBase;UserId=myUsername;Password=myPassword;cn.Open();cmd=newSqlDataAdapter(Select*FromAuthor,cn);ds=newDataSet();cmd.Fill(ds,%2);/作者M(jìn)yDataGrid.DataSource=ds.Tables(%2).DefaultView;/作者M(jìn)yDataGrid.DataBind();操作表格/usingSystem.

5、Data;/usingSystem.Data.SqlClient;using(SqlConnectioncn=newSqlConnection(%1)/ConfigurationManager.ConnectionStringsdb2ConnectionString.ConnectionString/DataSource=myServerAddress;InitialCatalog=myDataBase;UserId=myUsername;Password=myPassword;cn.Open();cmd=newSqlDataAdapter(Select*FromAuthor,cn);ds=n

6、ewDataSet();cmd.Fill(ds,%2);/作者M(jìn)yDataGrid.DataSource=ds.Tables(%2).DefaultView;/作者M(jìn)yDataGrid.DataBind();數(shù)值范圍查詢/usingSystem.Data;/usingSystem.Data.SqlClient;using(SqlConnectioncn=newSqlConnection(%1)/ConfigurationManager.ConnectionStringsdb2ConnectionString.ConnectionString/DataSource=myServerAddress

7、;InitialCatalog=myDataBase;UserId=myUsername;Password=myPassword;關(guān)閉時斷開連接/usingSystem.Data;/usingSystem.Data.SqlClient;using(SqlConnectioncn=newSqlConnection(%1)/ConfigurationManager.ConnectionStringsdb2ConnectionString.ConnectionString/DataSource=myServerAddress;InitialCatalog=myDataBase;UserId=myUs

8、ername;Password=myPassword;執(zhí)行命令/usingSystem.Data;/usingSystem.Data.SqlClient;using(SqlConnectioncn=newSqlConnection(%1)/ConfigurationManager.ConnectionStringsdb2ConnectionString.ConnectionString/DataSource=myServerAddress;InitialCatalog=myDataBase;UserId=myUsername;Password=myPassword;SqlCommandcmd=

9、newSqlCommand(insertuserRegister_tvalues(+TextBox1.Text+,+TextBox2.Text+),cn);cn.Open();cmd.ExecuteNonQuery();7.0racle8/8i/9i數(shù)據(jù)庫(thin模式)/usingSystem.Data;OracleSetYourcustomconnectionstringsvaluesODBCNewversionDriver=MicrosoftODBCforOracle;Server=myServerAddress;Uid=myUsername;Pwd=myPassword;Oldvers

10、ionDriver=MicrosoftODBCDriverforOracle;ConnectString=OracleServer.world;Uid=myUsername;Pwd=myPassword;OLEDB,OleDbConnection(.NET)StandardsecurityThisconnectionstringusesaproviderfromMicrosoft.Provider=msdaora;DataSource=MyOracleDB;UserId=myUsername;Password=myPassword;StandardSecurityThisconnections

11、tringusesaproviderfromOracle.Provider=OraOLEDB.Oracle;DataSource=MyOracleDB;UserId=myUsername;Password=myPassword;TrustedConnectionProvider=OraOLEDB.Oracle;DataSource=MyOracleDB;OSAuthent=1;OracleConnection(.NET)StandardDataSource=MyOracleDB;IntegratedSecurity=yes;ThisoneworksonlywithOracle8irelease

12、3orlaterSpecifyingusernameandpasswordDataSource=MyOracleDB;UserId=myUsername;Password=myPassword;IntegratedSecurity=no;ThisoneworksonlywithOracle8irelease3orlaterMissingtheSystem.Data.OracleClientnamespace?Download.NETManagedProviderforOracleGreatarticle!FeaturesofOracleDataProviderfor.NETbyRamaMoha

13、nG.atC#CornerOmitingtnsnames.oraThisisanothertypeofOracleconnectionstringthatdoesntrelyonyoutohaveaDSNfortheconnection.Youcreateaconnectionstringbasedontheformatusedinthetnsnames.orafilewithouttheneedtoactuallyhaveoneofthesefilesontheclientpc.SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(

14、PORT=MyPort)(CONNECT_DATA=(SERVICE_NAME=MyOracleSID);uid=myUsername;pwd=myPassword;CoreLabsOraDirect(.NET)StandardUserID=myUsername;Password=myPassword;Host=ora;Pooling=true;MinPoolSize=0;MaxPoolSize=100;ConnectionLifetime=0;ReadmoreatCoreLabAndattheproductpageDataShapeMSDataShapeProvider=MSDataShap

15、e.1;PersistSecurityInfo=False;DataProvider=MSDAORA;DataSource=orac;UserId=myUsername;Password=myPassword;16.程序計時DateTimerunTime=Convert.ToDateTime(System.Configuration.ConfigurationSettings.AppSettingsTimerRunAt);/運行時間TimeSpanrunTime=newTimeSpan(runTime.Ticks);/現(xiàn)在時間TimeSpantimeNow=newTimeSpan(DateTime.Now.Ticks);/時間間隔TimeSpants=runTime.Subtract(timeNow);/如果運行時間與當(dāng)前時間的差大于0，則任務(wù)執(zhí)行時間為當(dāng)日if(ts.TotalMilliseconds0)returnts.TotalMilliseconds;/如果運行時間與當(dāng)前時間的差小于0，則任務(wù)執(zhí)行時間為次日Else/差值的絕對