c连接SQL数据库的使用方法

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);/作者MyDataGrid.DataSource=ds.Tables(%2).DefaultView;/作者MyDataGrid.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);/作者MyDataGrid.DataSource=ds.Tables(%2).DefaultView;/作者MyDataGrid.DataBind();数值范围查询/usingSystem.Data;/usingSystem.Data.SqlClient;using(SqlConnectioncn=newSqlConnection(%1)/ConfigurationManager.ConnectionStringsdb2ConnectionString.ConnectionString/DataSource=myServerAddress

7、;InitialCatalog=myDataBase;UserId=myUsername;Password=myPassword;关闭时断开连接/usingSystem.Data;/usingSystem.Data.SqlClient;using(SqlConnectioncn=newSqlConnection(%1)/ConfigurationManager.ConnectionStringsdb2ConnectionString.ConnectionString/DataSource=myServerAddress;InitialCatalog=myDataBase;UserId=myUs

8、ername;Password=myPassword;执行命令/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数据库(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);/现在时间TimeSpantimeNow=newTimeSpan(DateTime.Now.Ticks);/时间间隔TimeSpants=runTime.Subtract(timeNow);/如果运行时间与当前时间的差大于0，则任务执行时间为当日if(ts.TotalMilliseconds0)returnts.TotalMilliseconds;/如果运行时间与当前时间的差小于0，则任务执行时间为次日Else/差值的绝对