《c#连接SQL数据库的使用方法》由会员分享,可在线阅读,更多相关《c#连接SQL数据库的使用方法(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;Pa
2、ssword=myPassword; SqlCommand 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.Conne
3、ctionString/Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword; SqlCommand cmd = new SqlCommand(Select Count(*) From jobs,cn); cn.Open();%2=cmd.ExecuteScalar(); /Message.InnerHtmlif(%2=%3)%4 3.显示表格/using System.Data;/using System.Data.SqlClient;DataSet ds=n
4、ull;using (SqlConnection cn = new SqlConnection(%1)/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
5、.Fill(ds,%2); /作者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;Ini
6、tial Catalog=myDataBase;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 (Sql
7、Connection cn = new SqlConnection(%1)/ConfigurationManager.ConnectionStringsdb2ConnectionString.ConnectionString/Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword; 6.关闭时断开连接/using System.Data;/using System.Data.SqlClient;using (SqlConnection cn = new SqlCo
8、nnection(%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)/ConfigurationMa
9、nager.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.Or
10、acle8/8i/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=my
11、Password; 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=OraOLEDB.Oracle;Data Source
12、=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 username and password
13、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 by Rama Mohan
14、 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 format used in the tnsnames.ora file without the need to actually 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