请问下,我准备用asp.net 存入oracle表中一些图片内容.
oracle 表PERFCHAR的定义是
CASE_ID NUMBER 12
PROJECT_ID NUMBER 12
CHART_TYPE VARCHAR2 16
CHART_CONTENT BLOB
CREATETIME DATE
UPDATETIME DATE
OWNER_ID NUMBER我采用了OLEDB代码如下
using System.Data.OleDb;
using System.IO;public partial class writeimage : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Submit1_ServerClick(object sender, EventArgs e)
{
int intPID= int.Parse(tbpid.Text.ToString());
int intCID = int.Parse(tbcid.Text.ToString());
string strType = tbtype.Text.ToString();
int intFilelength = myfile.PostedFile.ContentLength;
Byte [ ] bytimage = new Byte[intFilelength];
Stream imagestream = myfile.PostedFile.InputStream;
imagestream.Read(bytimage,0,intFilelength);
string strconn = "Provider='OraOLEDB.Oracle.1';User ID=test;password=pass;Data Source='WEBDB'";
OleDbConnection myConnection = new OleDbConnection(strconn);
// String strCmd = "INSERT INTO PERFCHAR(CASE_ID,PROJECT_ID,CHART_TYPE,CHART_CONTENT) VALUES(@CID,@PID,@CTYPE,@IMAGE)";
String strCmd = "INSERT INTO PERFCHAR(CASE_ID,PROJECT_ID,CHART_TYPE,CHART_CONTENT,CREATETIME,UPDATETIME,WONER_ID) VALUES(@CID,@PID,@CTYPE,@IMAGE,sysdate,sysdate,2)";
OleDbCommand dbcomm = new OleDbCommand(strCmd, myConnection);
dbcomm.Parameters.Add("@IMAGE", OleDbType.Binary, intFilelength).Value = bytimage;
dbcomm.Parameters.Add("@CID", OleDbType.Numeric, 12).Value = intCID;
dbcomm.Parameters.Add("@PID", OleDbType.Numeric, 12).Value = intPID;
dbcomm.Parameters.Add("@CTYPE", OleDbType.Char, 16).Value = strType; myConnection.Open();
dbcomm.ExecuteNonQuery();
myConnection.Close();
}
}
}为什么出现了ORA-00936 缺少表达式的异常??
请问下如何解决,着急等待中
oracle 表PERFCHAR的定义是
CASE_ID NUMBER 12
PROJECT_ID NUMBER 12
CHART_TYPE VARCHAR2 16
CHART_CONTENT BLOB
CREATETIME DATE
UPDATETIME DATE
OWNER_ID NUMBER我采用了OLEDB代码如下
using System.Data.OleDb;
using System.IO;public partial class writeimage : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Submit1_ServerClick(object sender, EventArgs e)
{
int intPID= int.Parse(tbpid.Text.ToString());
int intCID = int.Parse(tbcid.Text.ToString());
string strType = tbtype.Text.ToString();
int intFilelength = myfile.PostedFile.ContentLength;
Byte [ ] bytimage = new Byte[intFilelength];
Stream imagestream = myfile.PostedFile.InputStream;
imagestream.Read(bytimage,0,intFilelength);
string strconn = "Provider='OraOLEDB.Oracle.1';User ID=test;password=pass;Data Source='WEBDB'";
OleDbConnection myConnection = new OleDbConnection(strconn);
// String strCmd = "INSERT INTO PERFCHAR(CASE_ID,PROJECT_ID,CHART_TYPE,CHART_CONTENT) VALUES(@CID,@PID,@CTYPE,@IMAGE)";
String strCmd = "INSERT INTO PERFCHAR(CASE_ID,PROJECT_ID,CHART_TYPE,CHART_CONTENT,CREATETIME,UPDATETIME,WONER_ID) VALUES(@CID,@PID,@CTYPE,@IMAGE,sysdate,sysdate,2)";
OleDbCommand dbcomm = new OleDbCommand(strCmd, myConnection);
dbcomm.Parameters.Add("@IMAGE", OleDbType.Binary, intFilelength).Value = bytimage;
dbcomm.Parameters.Add("@CID", OleDbType.Numeric, 12).Value = intCID;
dbcomm.Parameters.Add("@PID", OleDbType.Numeric, 12).Value = intPID;
dbcomm.Parameters.Add("@CTYPE", OleDbType.Char, 16).Value = strType; myConnection.Open();
dbcomm.ExecuteNonQuery();
myConnection.Close();
}
}
}为什么出现了ORA-00936 缺少表达式的异常??
请问下如何解决,着急等待中
解决方案 »
- ASP.NET 自定义用户控件 怎么动态接收页面的值呢
- 求一个数组中N个数的总和
- Sql 数据库连接失败
- 关于ASP2.0中GRIDVIEW翻页的问题
- 目前在用asp.net开发“网上购物管理系统”,有相关开发经验的筒子能给点经验吗?
- help?原asp中的在asp.net应怎么写?
- select b.class_name,a.* from products as a,productclass as b where b.class_id = a.class_id order by [order] desc,posttime desc
- 急~怎么隐藏DataGrid的列?
- C/S结构的项目改写成B/S结构应该注意哪些问题?
- 新手问题~请看源程序~谁能我给我解释一下是怎么调用的?
- sqldatasource里面的参数,怎样将它的值设置为页面的一个属性,如我定义了一个属性;property abc as string,怎样将它参数的值设为abc?
- 为什么值为空啊
dbcomm.Parameters.Add("@IMAGE", bytimage );如果还不行,估计就是BLOB字段的问题
using System.Text;public partial class writeimage : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Submit1_ServerClick(object sender, EventArgs e)
{
int intPID= int.Parse(tbpid.Text.ToString());
int intCID = int.Parse(tbcid.Text.ToString());
int intUid = 1;
string strType = tbtype.Text.ToString();
Int32 intFilelength = myfile.PostedFile.ContentLength;
Byte [ ] bytimage = new Byte[intFilelength];
Stream imagestream = myfile.PostedFile.InputStream;
imagestream.Read(bytimage,0,intFilelength); string strconn = "Provider='OraOLEDB.Oracle';User ID=test;password=pass;Data Source='WEBDB'";
OleDbConnection myConnection = new OleDbConnection(strconn);
// String strCmd = "INSERT INTO PERFCHAR(CASE_ID,PROJECT_ID,CHART_TYPE,CHART_CONTENT) VALUES(@CID,@PID,@CTYPE,@IMAGE)";
String strCmd = "INSERT INTO tempchart(CASE_ID,PROJECT_ID,CHART_TYPE,CHART_CONTENT,OWNER_ID) VALUES(?,?,?,?,?)";
OleDbCommand dbcomm = new OleDbCommand(strCmd, myConnection);
dbcomm.Parameters.Add("@CID", OleDbType.Integer, 12).Value = intCID;
dbcomm.Parameters.Add("@PID", OleDbType.Integer, 12).Value = intPID;
dbcomm.Parameters.Add("@IMAGE",OleDbType.Binary,intFilelength).Value = bytimage;
dbcomm.Parameters.Add("@CTYPE", OleDbType.Char, 16).Value = strType;
dbcomm.Parameters.Add("@UDI", OleDbType.Integer, 12).Value = intUid;
myConnection.Open();
dbcomm.ExecuteNonQuery();
myConnection.Close();
}
不过还是派分一下.