using System; using System.Collections.Generic; using System.Data.SqlClient; using System.Data; using System.Diagnostics; namespace ConsoleApplication1 { /// <summary> /// 数据库连接 /// </summary> class ODBC { public ODBC() { SqlConnection conn = new SqlConnection("server=192.168.0.68" + @"/" + "BATCHSQL;uid=LOKUSR01;pwd=LOKUSR01;database=master"); SqlCommand comd = null; //thisCommand.CommandType = CommandType.Text; try { // 打开数据库连接 conn.Open(); // 执行SQL语句,并返回DataReader对象 //SqlDataReader dr = comd.ExecuteReader(); for (char i = 'a'; i < 'z'; i++) { comd = new SqlCommand("insert into LOKMSTB2C..CABIN_CLASS_CD_CONVERSION (J_CABIN_CLASS_CD) values ('" + i.ToString() + "')", conn); comd.ExecuteNonQuery(); } // 循环读取结果集 //while (dr.Read()) //{ // OneDrCheck(dr); //} 关闭DataReader //dr.Close(); } catch (SqlException ex) { Console.WriteLine(ex); } finally { // 关闭数据库连接 conn.Close(); } } public ODBC(List<SqlParameter> para, string sql) { SqlConnection conn = new SqlConnection("server=BJB09" + @"/" + "SQLEXPRESS;uid=LOKUSR01;pwd=LOKUSR01;database=master"); conn.Open(); SqlCommand comd = new SqlCommand(sql, conn); SqlParameterCollection sqlCol = comd.Parameters; Debug.WriteLine("/n"); Debug.WriteLine("/n"); foreach (SqlParameter p in para) { sqlCol.Add(p); Debug.WriteLine(p.ParameterName + ":" + p.Value); Debug.WriteLine("/n"); } comd.ExecuteNonQuery(); } private static void OneDrCheck(SqlDataReader dr) { String str = dr["COURSE_NO"].ToString(); Debug.WriteLine(str); } } }