private void button1_Click(object sender, EventArgs e){string cnnstr = "provider=OraOLEDB.Oracle;data source=HWQY;User Id=HWQY;Password=HWQY123;";Ole......
cmd.Parameters.Add("zp", System.Data.OleDb.OleDbType.Binary, imgByte.Length);
cmd.Parameters[0].Value = imgByte;
try
{
cmd.ExecuteNonQuery();
MessageBox.Show("更新成功");
}
catch (System.Exception e1)
{
MessageBox.Show(e1.Message);
}
}
private void button3_Click(object sender, EventArgs e)
{
string strSQL = "select * from test where id = '18' ";
string cnnstr = "provider=OraOLEDB.Oracle;data source=hwqy;User Id=hwqy;Password=hwqy123;";
OleDbConnection con = new OleDbConnection(cnnstr);
try
{
con.Open();
}
catch
{ }
DataTable dt = new DataTable();
System.Data.OleDb.OleDbDataAdapter da = new OleDbDataAdapter("select * from test",con);
da.Fill(dt);
Byte[] fileByte = (byte[])(dt.Rows[0]["zp"]);
FileStream fsForWrite = new FileStream(@"c:\test.txt", FileMode.Create);
fsForWrite.Write(fileByte, 0, fileByte.GetLength(0));
fsForWrite.Close();
}
注意：
连接ORACLE可以有多种形式的字符串，
// HWQY_Task.HWQY_OraHelper.strConn = "Provider=MSDAORA;pools=true;User ID=" LinkUser ";Data Source=" LinkName ";Password=" LinkPassWord ";";
HWQY_Task.HWQY_OraHelper.strConn = "Provider=OraOLEDB.Oracle;pools=true;User ID=" LinkUser ";Data Source=" LinkName ";Password=" LinkPassWord ";";
但用Provider=MSDAORA的形式时，保存到BLOB将出错。只能采用Provider=OraOLEDB.Oracle的形式。
2/2 首页 上一页 1 2 |
