2022年c#连接SQL数据库的使用方法 .pdf

《2022年c#连接SQL数据库的使用方法 .pdf》由会员分享，可在线阅读，更多相关《2022年c#连接SQL数据库的使用方法 .pdf（6页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、c#连接 SQL 数据库的使用方法最佳答案1.提取单条记录/using System.Data;/using System.Data.SqlClient;using(SqlConnection cn=new SqlConnection(%1)/ConfigurationManager.ConnectionStringsdb2ConnectionString.ConnectionString/Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;SqlComman

2、d cmd=new SqlCommand(Select Count(*)From jobs,cn);cn.Open();%2=cmd.ExecuteScalar();/Message.InnerHtml 2.单值比较/using System.Data;/using System.Data.SqlClient;using(SqlConnection cn=new SqlConnection(%1)/ConfigurationManager.ConnectionStringsdb2ConnectionString.ConnectionString/Data Source=myServerAddr

3、ess;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;SqlCommand cmd=new SqlCommand(Select Count(*)From jobs,cn);cn.Open();%2=cmd.ExecuteScalar();/Message.InnerHtml if(%2=%3)%4 3.显示表格/using System.Data;/using System.Data.SqlClient;DataSet ds=null;using(SqlConnection cn=new SqlConnect

4、ion(%1)名师资料总结-精品资料欢迎下载-名师精心整理-第 1 页，共 6 页 -/ConfigurationManager.ConnectionStringsdb2ConnectionString.ConnectionString/Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;cn.Open();cmd=new SqlDataAdapter(Select*From Author,cn);ds=new DataSet();cmd.Fill(ds,%2

5、);/作者 MyDataGrid.DataSource=ds.Tables(%2).DefaultView;/作者 MyDataGrid.DataBind();4.操作表格/using System.Data;/using System.Data.SqlClient;using(SqlConnection cn=new SqlConnection(%1)/ConfigurationManager.ConnectionStringsdb2ConnectionString.ConnectionString/Data Source=myServerAddress;Initial Catalog=my

6、DataBase;User Id=myUsername;Password=myPassword;cn.Open();cmd=new SqlDataAdapter(Select*From Author,cn);ds=new DataSet();cmd.Fill(ds,%2);/作者 MyDataGrid.DataSource=ds.Tables(%2).DefaultView;/作者 MyDataGrid.DataBind();5.数值范围查询/using System.Data;/using System.Data.SqlClient;using(SqlConnection cn=new Sq

7、lConnection(%1)/ConfigurationManager.ConnectionStringsdb2ConnectionString.ConnectionString/Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;6.关闭时断开连接名师资料总结-精品资料欢迎下载-名师精心整理-第 2 页，共 6 页 -/using System.Data;/using System.Data.SqlClient;using(SqlConnection cn

8、=new SqlConnection(%1)/ConfigurationManager.ConnectionStringsdb2ConnectionString.ConnectionString/Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;7.执行命令/using System.Data;/using System.Data.SqlClient;using(SqlConnection cn=new SqlConnection(%1)/Configura

9、tionManager.ConnectionStringsdb2ConnectionString.ConnectionString/Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;SqlCommand cmd=new SqlCommand(insert userRegister_t values(+TextBox1.Text+,+TextBox2.Text+),cn);cn.Open();cmd.ExecuteNonQuery();7.Oracle8/8i

10、/9i 数据库（thin 模式）/using System.Data;Oracle Set Your custom connection strings values ODBC New version Driver=Microsoft ODBC for Oracle;Server=myServerAddress;Uid=myUsername;Pwd=myPassword;Old version Driver=Microsoft ODBC Driver for Oracle;ConnectString=OracleServer.world;Uid=myUsername;Pwd=myPasswor

11、d;名师资料总结-精品资料欢迎下载-名师精心整理-第 3 页，共 6 页 -OLE DB,OleDbConnection(.NET)Standard security This connection string uses a provider from Microsoft.Provider=msdaora;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;Standard Security This connection string uses a provider from Oracle.Provider=OraOL

12、EDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;Trusted Connection Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;OracleConnection(.NET)Standard Data Source=MyOracleDB;Integrated Security=yes;This one works only with Oracle 8i release 3 or later Specifying usern

13、ame and password Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;Integrated Security=no;This one works only with Oracle 8i release 3 or later Missing the System.Data.OracleClient namespace?Download.NET Managed Provider for Oracle Great article!Features of Oracle Data Provider for.NET b

14、y Rama Mohan G.at C#Corner Omiting tnsnames.ora This is another type of Oracle connection string that doesnt rely on you to have a DSN for the connection.You create a connection string based on the 名师资料总结-精品资料欢迎下载-名师精心整理-第 4 页，共 6 页 -format used in the tnsnames.ora file without the need to actually

15、have one of these files on the client pc.SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort)(CONNECT_DATA=(SERVICE_NAME=MyOracleSID);uid=myUsername;pwd=myPassword;Core Labs OraDirect(.NET)Standard User ID=myUsername;Password=myPassword;Host=ora;Pooling=true;Min Pool Size=0;Max Pool

16、 Size=100;Connection Lifetime=0;Read more at Core Lab And at the product page Data Shape MS Data Shape Provider=MSDataShape.1;Persist Security Info=False;Data Provider=MSDAORA;Data Source=orac;User Id=myUsername;Password=myPassword;16.程序计时DateTime runTime=Convert.ToDateTime(System.Configuration.Conf

17、igurationSettings.AppSettingsTimerRunAt);/运行时间TimeSpan runTime=new TimeSpan(runTime.Ticks);/现在时间TimeSpan timeNow=new TimeSpan(DateTime.Now.Ticks);/时间间隔TimeSpan ts=runTime.Subtract(timeNow);/如果运行时间与当前时间的差大于0，则任务执行时间为当日if(ts.TotalMilliseconds 0)return ts.TotalMilliseconds;/如果运行时间与当前时间的差小于0，则任务执行时间为次日E

18、lse /差值的绝对值应加1 天名师资料总结-精品资料欢迎下载-名师精心整理-第 5 页，共 6 页 -return ts.Duration().Add(new TimeSpan(1,0,0,0,0).TotalMilliseconds;17.延时/using System.Threading;Thread.Sleep(Int32.Parse(%1);18.连接 Excel 文件string connString=Provider=Microsoft.Jet.OLEDB.4.0;Data Source=+excel文件名（绝对路径）+;Extended Properties=Excel 8.0;v 名师资料总结-精品资料欢迎下载-名师精心整理-第 6 页，共 6 页 -