■usingSystem; usingSy...... using System; using System.Data; using System.Data.SqlClient; using System.Data.OleDb; namespace ConsoleApplication1 { /// /// Class1 的摘要说明。 /// class Class1 { /// /// 应用程序的主入口点。 /// [STAThread] static void Main(string[] args) { //以下是连接Access OleDbConnection dbconn=new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data source=c:\a.mdb"); dbconn.Open(); //OleDbCommand cmd=new OleDbCommand("select * from test1",dbconn); OleDbCommand cmd=dbconn.CreateCommand(); cmd.CommandText="select * from test1"; cmd.CommandType=CommandType.Text; OleDbDataReader reader=cmd.ExecuteReader(); //以下是连接SQL2000 /*SqlConnection conn=new SqlConnection("server=localhost;Initial catalog=NorthWind;user ID=sa;password=;"); conn.Open(); SqlCommand cmd=conn.CreateCommand(); cmd.CommandText="select * from Customers"; cmd.CommandType=CommandType.Text; SqlDataReader reader=cmd.ExecuteReader(CommandBehavior.CloseConnection);*/ string output; while(reader.Read()) { output=string.Format("custormer {0}:{1} works for {2}",reader.GetString(1),reader.GetString(2),reader.GetString(3)); Console.WriteLine(output); } } } } |
|小黑屋|最新主题|手机版|微赢网络技术论坛 ( 苏ICP备08020429号 )
GMT+8, 2024-9-29 23:25 , Processed in 0.114295 second(s), 12 queries , Gzip On, MemCache On.
Powered by Discuz! X3.5
© 2001-2023 Discuz! Team.