刚开始用C#,不好意思了。
解决方案 »
- 老是报错说当前上下文找不到dt
- 怎么把后台上传的图片在前台轮显
- C# 在notifyIcon如何实现左击菜单
- window.close()窗口关闭问题
- WinForm中datagridview问题. 同样的 this.dataGridView1.BeginEdit(false); 在按键事件和Form_load事件中执行的效果却不一样.为什么?
- 字符转换问题
- 使用C#获取设备的GUID,该如何获取?
- System.Windows.Forms.UserControl 可序列化否
- 新手提问,帮我看看这个是怎么实现的
- 为什么说我没有权限?
- 这样的分级汇总如何做????(C#+Sql server2000)
- 请帮我推荐一本C#的书,本人有些C++的基础,最好不要只解语法,多些实例的,谢谢!
/// 从配置文件获取Oracle连接
/// </summary>
/// <returns>Oracle连接</returns>
private OracleConnection GetConnection()
{
string connstring = System.Configuration.ConfigurationSettings.AppSettings["OracleConnection"];
OracleConnection conn = new OracleConnection(connstring);
return conn;
}
/// <summary>
/// 从CommandText和Connection生成OracleCommand
/// </summary>
/// <param name="CommandText">CommandText</param>
/// <param name="conn">已经打开的Oracle连接</param>
/// <returns>OracleCommand</returns>
private OracleCommand GetCommand(string CommandText, OracleConnection conn)
{
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = CommandText;
cmd.CommandType = CommandType.StoredProcedure;
OracleCommandBuilder.DeriveParameters(cmd);
return cmd;
}
public DataSet GetApplications()
{
if(CurrentUser == null)
{
return null;
}
DataSet ds = new DataSet();
OracleConnection conn = this.GetConnection();
try
{
conn.Open();
OracleCommand cmd = this.GetCommand("UPGRADEPACK.GETAPPLICATIONS",conn);
cmd.Parameters["V_USER_ID"].Value = CurrentUser.UserID;
OracleDataAdapter ada = new OracleDataAdapter(cmd);
ada.Fill(ds);
}
finally
{
conn.Close();
}
return ds;
}
其他的和SQL SERVER一样,只是换个名称,如SQL SERVER用SqlConnection,而oracle用OracleConnection 等.
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;namespace 数字公路
{
/// <summary>
/// DragForm 的摘要说明。
/// </summary>
public class DragForm : System.Windows.Forms.Form
{
private System.Data.OracleClient.OracleDataAdapter oracleDataAdapter1;
private System.Data.OracleClient.OracleCommand oracleSelectCommand1;
private System.Data.OracleClient.OracleCommand oracleInsertCommand1;
private System.Data.OracleClient.OracleConnection oracleConnection1;
private 数字公路.DataSet1 dataSet11;
private System.Windows.Forms.DataGrid dataGrid1;
/// <summary>
/// 必需的设计器变量。
/// </summary>
private System.ComponentModel.Container components = null; public DragForm()
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent(); //
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
} /// <summary>
/// 清理所有正在使用的资源。
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if(components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
} #region Windows 窗体设计器生成的代码
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.oracleDataAdapter1 = new System.Data.OracleClient.OracleDataAdapter();
this.oracleSelectCommand1 = new System.Data.OracleClient.OracleCommand();
this.oracleInsertCommand1 = new System.Data.OracleClient.OracleCommand();
this.oracleConnection1 = new System.Data.OracleClient.OracleConnection();
this.dataSet11 = new 数字公路.DataSet1();
this.dataGrid1 = new System.Windows.Forms.DataGrid();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
this.SuspendLayout();
//
// oracleDataAdapter1
//
this.oracleDataAdapter1.InsertCommand = this.oracleInsertCommand1;
this.oracleDataAdapter1.SelectCommand = this.oracleSelectCommand1;
this.oracleDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "A0LJDATA71", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("路线代码", "路线代码"),
new System.Data.Common.DataColumnMapping("起点桩号", "起点桩号"),
new System.Data.Common.DataColumnMapping("止点桩号", "止点桩号"),
new System.Data.Common.DataColumnMapping("右边坡高度", "右边坡高度"),
new System.Data.Common.DataColumnMapping("右边坡坡度", "右边坡坡度")})});
//
// oracleSelectCommand1
//
this.oracleSelectCommand1.CommandText = "SELECT 路线代码, 起点桩号, 止点桩号, 右边坡高度, 右边坡坡度 FROM A0LJDATA71";
this.oracleSelectCommand1.Connection = this.oracleConnection1;
//
// oracleInsertCommand1
//
this.oracleInsertCommand1.CommandText = "INSERT INTO A0LJDATA71(路线代码, 起点桩号, 止点桩号, 右边坡高度, 右边坡坡度) VALUES (:路线代码, :起点桩号, :止点桩" +
"号, :右边坡高度, :右边坡坡度)";
this.oracleInsertCommand1.Connection = this.oracleConnection1;
this.oracleInsertCommand1.Parameters.Add(new System.Data.OracleClient.OracleParameter(":路线代码", System.Data.OracleClient.OracleType.VarChar, 10, "路线代码"));
this.oracleInsertCommand1.Parameters.Add(new System.Data.OracleClient.OracleParameter(":起点桩号", System.Data.OracleClient.OracleType.Double, 0, "起点桩号"));
this.oracleInsertCommand1.Parameters.Add(new System.Data.OracleClient.OracleParameter(":止点桩号", System.Data.OracleClient.OracleType.Double, 0, "止点桩号"));
this.oracleInsertCommand1.Parameters.Add(new System.Data.OracleClient.OracleParameter(":右边坡高度", System.Data.OracleClient.OracleType.Double, 0, "右边坡高度"));
this.oracleInsertCommand1.Parameters.Add(new System.Data.OracleClient.OracleParameter(":右边坡坡度", System.Data.OracleClient.OracleType.Double, 0, "右边坡坡度"));
//
// oracleConnection1
//
this.oracleConnection1.ConnectionString = "user id=sss;data source=szgl";
//
// dataSet11
//
this.dataSet11.DataSetName = "DataSet1";
this.dataSet11.Locale = new System.Globalization.CultureInfo("zh-CN");
//
// dataGrid1
//
this.dataGrid1.DataMember = "";
this.dataGrid1.DataSource = this.dataSet11.A0LJDATA71;
this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid1.Location = new System.Drawing.Point(80, 96);
this.dataGrid1.Name = "dataGrid1";
this.dataGrid1.TabIndex = 0;
//
// DragForm
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(292, 266);
this.Controls.Add(this.dataGrid1);
this.Name = "DragForm";
this.Text = "DragForm";
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
this.ResumeLayout(false); }
#endregion
}
}
下载 oracle数据库提供程序
先引用 using System.Data.OracleClient;
string str ="Password=aptech;User ID=user01;Data Source=oemrep;Persist Security Info=True";
OracleConnection mycon=new OracleConnection(str);
mycon.Open();
Standard:"Data Source=MyOracleDB;Integrated Security=yes;"
This one works only with Oracle 8i release 3 or later
Specifying username and password:"Data Source=MyOracleDB;User Id=username;Password=passwd;Integrated Security=no;"
This one works only with Oracle 8i release 3 or later
Declare the OracleConnection:C#:
using System.Data.OracleClient;
OracleConnection oOracleConn = new OracleConnection();
oOracleConn.ConnectionString = "my connectionstring";
oOracleConn.Open();
Standard security:"Provider=msdaora;Data Source=MyOracleDB;User Id=UserName;Password=asdasd;"
This one's from Microsoft, the following are from Oracle
Standard Security:"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=Username;Password=asdasd;" Trusted Connection:"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;"