OracleCommand com = new OracleCommand();
com.Connection = con;
com.CommandText = "Hoursdj";
com.CommandType = CommandType.TableDirect;
出錯,此提供者不支援直接表格存取。
com.Connection = con;
com.CommandText = "Hoursdj";
com.CommandType = CommandType.TableDirect;
出錯,此提供者不支援直接表格存取。
OracleCommand com = new OracleCommand();
com.Connection = con;
com.CommandText = "select * from Hoursdj";
com.CommandType = CommandType.Text;
//OracleDataAdapter adta = new OracleDataAdapter(com);
//string ab = "ROWNO,PRODUCTNO,CUSTNO,RDESTIMATE,IMI05,IMIPIE,PIE,PIEDATE,RIMIPIE,RPIE,RPIEDATE,DJDATE,DJUSER,RDESTIMATEC,IMI05C,REMARK";
//string[] fieldname = ab.Split(',');
//for (Int16 i = 1; i < ds.Columns.Count; i++)
//{
// adta.TableMappings.Add(ds.Columns[i].ColumnName.ToString(), fieldname[i - 1]);
//}
//DataTable dsb = new DataTable();
//adta.Fill(dsb);