本文整理汇总了C#中System.Data.OracleClient.OracleDataAdapter类的典型用法代码示例。如果您正苦于以下问题:C# OracleDataAdapter类的具体用法?C# OracleDataAdapter怎么用?C# OracleDataAdapter使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
OracleDataAdapter类属于System.Data.OracleClient命名空间,在下文中一共展示了OracleDataAdapter类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的C#代码示例。
示例1: DeckIsRefD
public static bool DeckIsRefD(int Deck_id)
{
try
{
OracleConnection OraCon = new OracleConnection("Data Source=oids;User ID=plm;Password=123!feed;Unicode=True");
OraCon.Open();
OracleDataAdapter OrclPrjAdapter = new OracleDataAdapter();
OracleCommand OrclPrjCmd = OraCon.CreateCommand();
OrclPrjAdapter.SelectCommand = OrclPrjCmd;
OrclPrjCmd.CommandText = @"SELECT T.TABLE_NAME,T.COLUMN_NAME FROM use_deckid_tables_view T";
DataSet Mydata = new DataSet();
OrclPrjAdapter.Fill(Mydata);
DataSet tmpData = new DataSet();
string QueryPrjIdCmdStr = string.Empty;
for (int i = 0; i < Mydata.Tables[0].Rows.Count; i++)
{
QueryPrjIdCmdStr = @"SELECT T." + Mydata.Tables[0].Rows[i][1] + " FROM " + Mydata.Tables[0].Rows[i][0] + " T WHERE TO_CHAR(T." + Mydata.Tables[0].Rows[i][1] + ")=TO_CHAR(" + Deck_id + ")";
OrclPrjCmd.CommandText = QueryPrjIdCmdStr;
OrclPrjAdapter.Fill(tmpData);
if (tmpData.Tables[0].Rows.Count > 0)
return true;
}
return false;
}
catch (Exception err)
{
System.Console.WriteLine(err.Message);
return true;
}
}
开发者ID:freudshow,项目名称:raffles-codes,代码行数:32,代码来源:Program.cs
示例2: Query
/// <summary>
/// execute a query£¬return DataSet
/// </summary>
/// <param name="SQLString"></param>
/// <returns>DataSet</returns>
public static DataSet Query(string connectionString, CommandType cmdType, string SQLString, params OracleParameter[] cmdParms)
{
using (OracleConnection connection = new OracleConnection(connectionString))
{
OracleCommand cmd = new OracleCommand();
PrepareCommand(cmd, connection, null, cmdType, SQLString, cmdParms);
using (OracleDataAdapter da = new OracleDataAdapter(cmd))
{
DataSet ds = new DataSet();
//try
//{
da.Fill(ds, "ds");
cmd.Parameters.Clear();
//}
//catch (System.Data.OracleClient.OracleException ex)
//{
// throw new Exception(ex.Message);
//}
//finally
//{
// if (connection.State != ConnectionState.Closed)
// {
// connection.Close();
// }
//}
return ds;
}
}
}
开发者ID:viticm,项目名称:pap2,代码行数:34,代码来源:OracleHelper.cs
示例3: CreateDataAdapter
public static DbDataAdapter CreateDataAdapter(DbProviderType DbProviderType, IDbCommand command, IDbConnection connection)
{
switch (DbProviderType)
{
case DbProviderType.SQLSERVER:
SqlDataAdapter sqlda = new SqlDataAdapter();
sqlda.SelectCommand = (SqlCommand) command;
command.Connection = connection;
return sqlda;
case DbProviderType.ORACLE:
OracleDataAdapter orada = new OracleDataAdapter();
orada.SelectCommand = (OracleCommand) command;
command.Connection = connection;
return orada;
// case DbProviderType.MYSQL:
// MySqlDataAdapter mysqlda = new MySqlDataAdapter();
// mysqlda.SelectCommand = (MySqlCommand) command;
// command.Connection = connection;
// return mysqlda;
default:
OleDbDataAdapter oleda = new OleDbDataAdapter();
oleda.SelectCommand = (OleDbCommand) command;
command.Connection = connection;
return oleda;
}
}
开发者ID:BackupTheBerlios,项目名称:ch3etah-svn,代码行数:26,代码来源:DbProviderFactory.cs
示例4: Query
/// <summary>
/// ִ�в�ѯ��䣬����DataSet
/// </summary>
/// <param name="SQLString">��ѯ���</param>
/// <returns>DataSet</returns>
public static DataSet Query(string SQLString)
{
if (SQLString != null && SQLString.Trim() != "")
{
using (OracleConnection connection = new OracleConnection(connectionString))
{
DataSet ds = new DataSet();
try
{
connection.Open();
OracleDataAdapter command = new OracleDataAdapter(SQLString, connection);
command.Fill(ds, "ds");
}
catch (System.Data.OracleClient.OracleException ex)
{
throw new Exception(ex.Message);
}
finally
{
connection.Close();
}
return ds;
}
}
else
{
return null;
}
}
开发者ID:hijushen,项目名称:WindowDemo,代码行数:34,代码来源:OracleHelper.cs
示例5: stdnt_payment_info_btn_Click
private void stdnt_payment_info_btn_Click(object sender, EventArgs e)
{
dbConnect conObj = new dbConnect();
OracleConnection conn = conObj.connFunc();
OracleParameter parOut = new OracleParameter();
parOut.ParameterName = "res_cur";
parOut.OracleType = OracleType.Cursor;
parOut.Size = 32;
parOut.Direction = System.Data.ParameterDirection.Output;
OracleCommand cmd = conn.CreateCommand();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "student_payment_procedure";
cmd.Parameters.Add(parOut);
conn.Open();
OracleDataAdapter adapter = new OracleDataAdapter(cmd);
DataSet myset = new DataSet("res_cur");
adapter.Fill(myset);
stdnt_payment_dataGridView.DataSource = myset;
stdnt_payment_dataGridView.DataSource = myset.Tables[0];
conn.Close();
}
开发者ID:nixon1333,项目名称:oracleCSharpDemoProject,代码行数:26,代码来源:Form3.cs
示例6: ReadDataToDataSet
public DataSet ReadDataToDataSet(OracleConnection conn, String SQL, string diff)
{
OracleDataAdapter adapter = new OracleDataAdapter(SQL, conn);
DataSet testDataSet = new DataSet();
adapter.Fill(testDataSet);
return testDataSet;
}
开发者ID:weicheng1104,项目名称:IT_Monitor,代码行数:7,代码来源:Tool.cs
示例7: bookingsDetails
//Filling the booking details into the return cars datagridview
public void bookingsDetails(DataGridView grd_Bookings)
{
var tomorrow = DateTime.Today.AddDays(1).ToString("dd-MMM-yyyy");
var dueDate = DateTime.Today.AddDays(-5).ToString("dd-MMM-yyyy");
string query_String = string.Format("SELECT DISTINCT B.Customer_Id ,Forename, Surname ,B.Car_Reg ,Cost ,Customer_Type,Return_Date FROM Cars CA, " +
"Customers C JOIN Bookings B ON C.Customer_Id = B.Customer_Id " +
"WHERE Car_Status = 'U' AND CA.Car_Reg = B.Car_Reg AND Return_Date BETWEEN '{0}' AND '{1}'", dueDate, tomorrow );
// MessageBox.Show(query_String);
try
{
connection.Open();
cmd = connection.CreateCommand();
cmd.CommandText = query_String;
data_Adapter = new OracleDataAdapter(cmd);
data_Set = new DataSet();
data_Adapter.Fill(data_Set, "Bookings");
grd_Bookings.DataSource = data_Set.Tables["Bookings"];
data_reader = cmd.ExecuteReader();//the reader is used to read in the required record
data_reader.Read();
connection.Close();
}
catch (Exception ex) {MessageBox.Show("" + ex);}
}
开发者ID:pafennell,项目名称:SoftwareEngineering,代码行数:29,代码来源:Rental_Querys.cs
示例8: cmis_search
protected DataSet cmis_search(string ma_khang, string so_cto, out string txt_err)
{
DataSet ds = new DataSet();
try
{
string txt_cmd = string.Format("Data Source={0}; User ID={1}; Password={1}; Unicode=True", "THAINGUYEN", "CMIS01PC1");
OracleConnection ora_con = new OracleConnection(txt_cmd);
txt_cmd = @"select TEN_KHANG, DCHI_KHANG, DCHI_TTOAN, KY, THANG, NAM, NGAY_DKY, NGAY_CKY, LOAI_HDON, TONG_TIEN, DIEN_TTHU, NGAY_PHANH
from cmis01.hdn_hdon
where MA_KHANG=:ma_khang or SO_CTO=:so_cto
order by NGAY_CKY desc";
OracleParameter[] pa = new OracleParameter[2];
pa[0] = new OracleParameter("ma_khang", ma_khang.ToUpper());
pa[1] = new OracleParameter("so_cto", so_cto);
OracleDataAdapter ora_da = new OracleDataAdapter(txt_cmd, ora_con);
ora_da.SelectCommand.CommandType = CommandType.Text;
ora_da.SelectCommand.Parameters.Add(pa[0]);
ora_da.SelectCommand.Parameters.Add(pa[1]);
ora_con.Open();
ora_da.Fill(ds);
ora_con.Close();
txt_err = "";
}
catch (Exception ex) { txt_err = ex.Message; }
return ds;
}
开发者ID:chungnt88,项目名称:DesktopModules,代码行数:26,代码来源:cmis_hdmb_thainguyen.ascx.cs
示例9: Button1_Click
protected void Button1_Click(object sender, EventArgs e)
{
try
{
string strConn = "Data Source=orcl;User Id=chatroom;Password=chatroom;Integrated Security=no;";
OracleConnection oleDbConnection = new OracleConnection(strConn);
oleDbConnection.Open();
string strSql;
if (this.name.Text.ToString() == "")
{
strSql = "select * from scott.ChatRoomLog order by id desc";
}
else
{
strSql = "select * from scott.chatroomlog where name='" + this.name.Text.ToString() + "' order by id";
}
System.Data.OracleClient.OracleCommand oleDbCommand = new System.Data.OracleClient.OracleCommand();
oleDbCommand.CommandText = strSql;
oleDbCommand.Connection = oleDbConnection;
System.Data.OracleClient.OracleDataAdapter oleDbDataAdapter = new System.Data.OracleClient.OracleDataAdapter(oleDbCommand);
DataTable table = new DataTable();
oleDbDataAdapter.Fill(table);
oleDbConnection.Close();
this.GridView1.DataSource = table.DefaultView;
this.GridView1.DataBind();
}
catch
{
}
}
开发者ID:zzmy,项目名称:chatroom,代码行数:31,代码来源:admin.aspx.cs
示例10: frmMain_Load
private void frmMain_Load(object sender, EventArgs e)
{
my_rpt objRpt;
// Creating object of our report.
objRpt = new my_rpt();
String ConnStr = "SERVER=myDb;USER ID=user1;PWD=user1";
OracleConnection myConnection = new OracleConnection(ConnStr);
String Query1 = "select a.PROJECT_ID,a.PROJECT_NAME,b.GROUP_NAME from tbl_project a,tbl_project_group b where a.group_code= b.group_code";
OracleDataAdapter adapter = new OracleDataAdapter(Query1, ConnStr);
DataSet Ds = new DataSet();
// here my_dt is the name of the DataTable which we created in the designer view.
adapter.Fill(Ds, "my_dt");
if (Ds.Tables[0].Rows.Count == 0)
{
MessageBox.Show("No data Found", "CrystalReportWithOracle");
return;
}
// Setting data source of our report object
objRpt.SetDataSource(Ds);
CrystalDecisions.CrystalReports.Engine.TextObject root;
root = (CrystalDecisions.CrystalReports.Engine.TextObject)objRpt.ReportDefinition.ReportObjects["txt_header"];
root.Text = "Sample Report By Using Data Table!!";
// Binding the crystalReportViewer with our report object.
crystalReportViewer1.ReportSource = objRpt;
}
开发者ID:Vinhbaba,项目名称:dskfeorfqlhvsea,代码行数:35,代码来源:frmMain.cs
示例11: CreateDataAdapter
/// <summary>
/// ���������ļ��������õ����ݿ�����
/// �ʹ�������������������Ӧ���ݿ�����������
/// </summary>
/// <returns></returns>
public static IDbDataAdapter CreateDataAdapter(IDbCommand cmd)
{
IDbDataAdapter adapter = null;
switch (AdoHelper.DbType)
{
case DatabaseType.SQLSERVER:
adapter = new SqlDataAdapter((SqlCommand)cmd);
break;
case DatabaseType.ORACLE:
adapter = new OracleDataAdapter((OracleCommand)cmd);
break;
case DatabaseType.MYSQL:
adapter = new MySqlDataAdapter((MySqlCommand)cmd);
break;
case DatabaseType.ACCESS:
adapter = new OleDbDataAdapter((OleDbCommand)cmd);
break;
case DatabaseType.SQLITE:
adapter = new SQLiteDataAdapter((SQLiteCommand)cmd);
break;
default: throw new Exception("���ݿ�����Ŀǰ��֧�֣�");
}
return adapter;
}
开发者ID:zhangmuyang,项目名称:BugManage,代码行数:30,代码来源:DbFactory.cs
示例12: Finish
public void Finish()
{
_output = Output ?? "Output";
if (!Directory.Exists(_output))
{
Directory.CreateDirectory(_output);
}
Console.Write("输出路径:");
Console.WriteLine(_output);
using (OracleConnection conn = new OracleConnection(ConnectionString))
{
conn.Open();
using (OracleCommand cmd = new OracleCommand())
{
using (OracleDataAdapter da = new OracleDataAdapter(cmd))
{
cmd.Connection = conn;
foreach (string tableName in TableNames)
{
CreateFile(tableName, cmd, da);
Console.WriteLine("成功创建文件:{0}.cs", tableName);
}
Console.WriteLine("操作成功,成功生成{0}个文件", TableNames.Length);
}
}
}
}
开发者ID:Jitlee,项目名称:LPS,代码行数:29,代码来源:OracleHelper.cs
示例13: BuscaDGV
public static void BuscaDGV(DataGridView dgv, String nome)
{
OracleDataAdapter da = new OracleDataAdapter("SELECT f.funcionarioid, f.nome, c.nome cargo, f.numero, f.ativo FROM funcionarios f JOIN cargos c USING (cargoid) WHERE f.nome LIKE '" + nome + "%'", ConexaoOracle.ObterConexao());
DataTable dt = new DataTable();
da.Fill(dt);
dgv.DataSource = dt;
}
开发者ID:UCLINF-20152-PI1,项目名称:Beta,代码行数:7,代码来源:FuncionarioDAO.cs
示例14: button1_Click
private void button1_Click(object sender, EventArgs e)
{
try
{
OracleConnection OrclConn = new OracleConnection(DataAccess.OIDSConnStr);
OrclConn.Open();
OracleDataAdapter OrclNestAdapter = new OracleDataAdapter();
OracleCommand OrclNestCmd = OrclConn.CreateCommand();
OracleCommand OrclCmd = OrclConn.CreateCommand();
//OracleCommandBuilder myCommandBuilder = new OracleCommandBuilder(mOrclAdapter);
//mOrclAdapter.Update(MyDataSet);
//conn.Close();
//for each row and each spool , insert into single_inventory_table
for (int i = 0; i < InventoryTable.Rows.Count; i++)
{
string pipetype = InventoryTable.Rows[i]["类型"].ToString();
Int32 pipelength = Convert.ToInt32(InventoryTable.Rows[i]["长度"].ToString());
string erpcode = InventoryTable.Rows[i]["ERP编码"].ToString();
double weight = (Convert.ToDouble(InventoryTable.Rows[i]["重量"].ToString())) / (Convert.ToInt32(InventoryTable.Rows[i]["数量"].ToString()));
string batch_no = InventoryTable.Rows[i]["炉批号"].ToString();
for (int j = 0; j < Convert.ToInt32(InventoryTable.Rows[i]["数量"].ToString()); j++)
{
//insert into oracle
OrclCmd.CommandText = "INSERT INTO pipe_inventory_single_spool (PIPETYPE,PIPELENGTH,ERPCODE,WEIGHT,BATCH_NO,STATE) VALUES ('" + pipetype + "'," + pipelength + ",'" + erpcode + "'," + weight + ",'" + batch_no + "',1)";
OrclCmd.ExecuteNonQuery();
}
}
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
MessageBox.Show("更新成功!");
}
开发者ID:freudshow,项目名称:raffles-codes,代码行数:34,代码来源:inventory.cs
示例15: ExecuteDataSet
/// <summary>
/// 执行查询语句,返回DataSet
/// </summary>
/// <param name="SQLString">查询语句</param>
/// <returns>DataSet</returns>
public override DataSet ExecuteDataSet(string SQLString, params IDataParameter[] cmdParms)
{
using (OracleConnection connection = new OracleConnection(connectionString))
{
OracleCommand cmd = new OracleCommand();
PrepareCommand(cmd, connection, null, SQLString, cmdParms);
using (OracleDataAdapter da = new OracleDataAdapter(cmd))
{
DataSet ds = new DataSet();
try
{
da.Fill(ds, "ds");
cmd.Parameters.Clear();
}
catch (OracleException e)
{
//LogManage.OutputErrLog(e, new Object[] { SQLString, cmdParms });
throw;
}
finally
{
cmd.Dispose();
connection.Close();
}
return ds;
}
}
}
开发者ID:qq5013,项目名称:JXNG,代码行数:33,代码来源:OracleDataBaseProvider.cs
示例16: AuthenticateUser
public Member AuthenticateUser(String username, String password)
{
conn.Open();
try
{
cmd = conn.CreateCommand();
string sql = "Select * from members where username = '" + username + "' AND account_password = '" + password+"'" ;
cmd = new OracleCommand(sql);
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
da = new OracleDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds, "ss");
if (ds.Tables["ss"].Rows[0].ItemArray[0].Equals(username) && ds.Tables["ss"].Rows[0].ItemArray[2].Equals(password))
{
member = createMember(ds);
}
return member;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return null;
}
finally
{
conn.Close();
}
}
开发者ID:LukeBluett,项目名称:PostBored,代码行数:31,代码来源:MembersDAO.cs
示例17: EditStudentFrm_Load
private void EditStudentFrm_Load(object sender, EventArgs e)
{
//Author: Niall Stack - t00174406
string CloudDB = "Data Source=cp3dbinstance.c4pxnpz4ojk8.us-east-1.rds.amazonaws.com:1521/cp3db;User Id=sw4;Password=sw4;";
try
{
OracleConnection conn = new OracleConnection(CloudDB);
OracleCommand cmd = new OracleCommand("SELECT * FROM Students", conn);
cmd.CommandType = CommandType.Text;
OracleDataAdapter da = new OracleDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds, "ss");
studGrd.DataSource = ds.Tables["ss"];
conn.Close();
}
catch (OracleException ex)
{
MessageBox.Show(ex.Message);
}
}
开发者ID:niallstack,项目名称:DBProjectPlayground,代码行数:27,代码来源:EditStudentFrm.cs
示例18: executeDataTable
public DataTable executeDataTable(IDbTransaction transaction, CommandType commandType, string commandText, params IDbDataParameter[] commandParameters)
{
try
{
//create a command and prepare it for execution
OracleCommand cmd = new OracleCommand();
PrepareCommand(cmd, transaction.Connection, transaction, commandType, commandText, commandParameters);
//create the DataAdapter & DataTable
OracleDataAdapter da = new OracleDataAdapter(cmd);
DataTable dt = new DataTable();
//fill the DataTable using default values for DataTable names, etc.
da.Fill(dt);
// detach the SqlParameters from the command object, so they can be used again.
cmd.Parameters.Clear();
//return the datatable
return dt;
}
catch (Exception ex)
{
throw (new Exception(string.Concat(ex.Message.ToString(), "\r\nExecuted SQL Statement:\r\n", commandText.ToString()), ex));
}
}
开发者ID:WeiKein,项目名称:Yamaya-uploader,代码行数:26,代码来源:BYamaya.cs
示例19: run
public void run()
{
OracleDataAdapter oleDBda = new OracleDataAdapter();
oleDBda.SelectCommand = new OracleCommand("",new OracleConnection());
base.DbDataAdapter_FillError((DbDataAdapter)oleDBda);
}
开发者ID:nlhepler,项目名称:mono,代码行数:7,代码来源:OracleDataAdapter_FillError.cs
示例20: run
public void run()
{
OracleDataAdapter oleDBda = new OracleDataAdapter();
oleDBda.SelectCommand = new OracleCommand("",new OracleConnection());
base.DataAdapter_MissingMappingAction((DbDataAdapter)oleDBda);
}
开发者ID:nlhepler,项目名称:mono,代码行数:7,代码来源:OracleDataAdapter_MissingMappingAction.cs
注:本文中的System.Data.OracleClient.OracleDataAdapter类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论