public void TestFunc() { DmCommand command = new DmCommand(); command.Connection = cnn; try { string a, b, c; command.CommandText = "select * from Production.Product;"; var reader = command.ExecuteReader(); while (reader.Read()) { a = reader.GetString(0); b = reader.GetString(1); c = reader.GetString(2); Console.WriteLine("Name:" + a); Console.WriteLine("Author: " + b); Console.WriteLine("Publisher: " + c); Console.WriteLine("-----------------------------"); } } catch (Exception e) { Console.WriteLine(e.Message); ret = 0; } }
//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 override DbCommand GetCommand(string sql, SugarParameter[] parameters) { DmCommand sqlCommand = new DmCommand(sql, (DmConnection)this.Connection); sqlCommand.CommandType = this.CommandType; sqlCommand.CommandTimeout = this.CommandTimeOut; if (this.Transaction != null) { sqlCommand.Transaction = (DmTransaction)this.Transaction; } if (parameters.HasValue()) { IDataParameter[] ipars = ToIDbDataParameter(parameters); sqlCommand.Parameters.AddRange((DmParameter[])ipars); } CheckConnection(); return(sqlCommand); }
/// <summary> /// SqlDataAdapter /// </summary> /// <param name="command"></param> public MyDmDataAdapter(DmCommand command) { this.command = command; }