//public string ImportTestResult(DmDataReader dr) public string ImportTestResult(OleDbDataReader dr) { //OleDbConnection m_cn = null; DmConnection m_cn = null; try //测试服务器是否还有效 { m_cn = new DmConnection(conStr); try { m_cn.Open(); } catch (Exception e) { return(e.Message); } //OleDbCommand m_cm = m_cn.CreateCommand(); DmCommand m_cm = m_cn.CreateCommand(); try { m_cm.CommandText = "DROP TABLE TEST_RESULT"; m_cm.ExecuteNonQuery(); } catch { } m_cm.CommandText = "CREATE TABLE TEST_RESULT(ID INT IDENTITY(1,1) PRIMARY KEY, [NAME] VARCHAR(200), [PATH] VARCHAR(300), TEST_TIME DATETIME, IS_SUCCESS CHAR(1))"; m_cm.ExecuteNonQuery(); m_cm.CommandText = "CREATE INDEX I_TEST_RESULT ON TEST_RESULT([NAME], [PATH])"; m_cm.ExecuteNonQuery(); while (dr.Read()) { string sql = "INSERT INTO TEST_RESULT(NAME, PATH, TEST_TIME, IS_SUCCESS) VALUES('"; sql += dr[0].ToString() + "','" + dr[1].ToString() + "','" + Convert.ToString(dr[2]) + "','" + dr[3].ToString() + "')"; m_cm.CommandText = sql; m_cm.ExecuteNonQuery(); } } catch (Exception e) { m_cn.Close(); return(e.Message); } m_cn.Close(); return(null); }
public void Close() { if (conn == null) { return; } if (conn.State != ConnectionState.Closed) { conn.Close(); } }
static void Main(string[] args) { try { cnn.ConnectionString = "Server=localhost; User Id=SYSDBA; PWD=SYSDBA"; cnn.Open(); Program program = new Program(); program.TestFunc(); cnn.Close(); } catch (Exception ex) { Console.WriteLine(ex.Message); } }