public void output(string myConnectionString)
{
DataTable DT = new DataTable();
// If the connection string is empty, use default.
if (myConnectionString == "")
{
myConnectionString =
"User ID=SAJET; Password=TECH; Direct = true; Host=127.0.0.1; Service Name=MAZDA; Port=1521";
}
OracleConnection myConn = new OracleConnection(myConnectionString);
string mySeletQuery = "SELECT * FROM G_CRANE_JOB";
//////OracleCommand myCommand = new OracleCommand(mySeletQuery);
//////myCommand.Connection = myConn;
myConn.Open();
myCommand.ExecuteNonQuery(); //可執行新增修改刪除
try
{
OracleDataAdapter OD = new OracleDataAdapter(mySeletQuery, myConn); //使用物件查詢結果
OD.Fill(DT); //將結果寫入Datatable
dataGridView1.DataSource = DT; //選擇資料來源=DT
}
finally
{
myConn.Close();
}
}
留言列表