是varchar2 大小为50,不知道为什么报错:非法的变量名/编号,请帮忙。
解决方案 »
- Efs frame框架中,grid导出,导入Excel
- 网站上传问题
- 请问一个<script>里函数结果怎么让一个PHP页面得到????
- (特急,在线等!!)郁闷了一天(高手帮忙)ASP.NET创建Excel时出错,不能访问只读文件xx.xls
- Session为什么会莫名其妙地丢失?
- <% %>在a.aspx使用问题???
- 我寫了一個datagrid的codebehind文件,為什么什么都沒有顯示?
- 如何在页面里面实现定时向数据库里面添加数据啊???例如每隔3分钟向数据库里面添加一篇回复的内容
- 谁给我写个简单直接的,DataSet和SqlDataAdapter的例子
- 请问如何从dataTable A中读取满足一定条件的数据到另一个DataTable B中?(B数据记录小于等于A)
- 帮忙看看几行代码,插入数据库的
- 高分求救,master/detail页面,当从Detail页面操作后返回到Master页面,怎样保持Master页面以前状态
OracleCommand myCommand = new OracleCommand("INSERT INTO UFILE(ufiletitle, ufiletype) VALUES (:imgtitle, :imgtype)");
myCommand.Connection = new OracleConnection("Data Source=OA;User ID=jack;Password=dian;Integrated Security=no;");
myCommand.CommandType = CommandType.Text; OracleParameter paramTitle = new OracleParameter("imgtitle", OracleType.VarChar, 50 );
paramTitle.Value = imgtitle;
myCommand.Parameters.Add( paramTitle); OracleParameter paramType = new OracleParameter( "imgtype", OracleType.VarChar, 50 );
paramType.Value = imgtype;
myCommand.Parameters.Add( paramType );
myCommand.Connection.Open();
myCommand.ExecuteOracleScalar();
myCommand.Connection.Close();
......
OracleCommand myCommand = new OracleCommand("INSERT INTO UFILE(ufiletitle, ufiletype, ufiledata) VALUES (@imgtitle, @imgtype, @imgdata)");
myCommand.Connection = new OracleConnection("Data Source=OA;User ID=jack;Password=dian;Integrated Security=no;");
myCommand.CommandType = CommandType.Text; OracleParameter paramTitle = new OracleParameter("@imgtitle", OracleType.NVarChar, 50 );
paramTitle.Value = imgtitle;
myCommand.Parameters.Add( paramTitle); OracleParameter paramType = new OracleParameter( "@imgtype", OracleType.NVarChar, 50 );
paramType.Value = imgtype;
myCommand.Parameters.Add( paramType ); OracleParameter paramData = new OracleParameter( "@imgdata", OracleType.LongVarChar );
paramData.Value = imgdata;
myCommand.Parameters.Add( paramData );
myCommand.Connection.Open();
myCommand.ExecuteOracleScalar();
myCommand.Connection.Close();
新的问题又出来了,麻烦再看一下。下面是错误报告:
Server Error in '/MyOa' Application.
--------------------------------------------------------------------------------Object must implement IConvertible.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.InvalidCastException: Object must implement IConvertible.Source Error:
Line 76:
Line 77: myCommand.Connection.Open();
Line 78: myCommand.ExecuteOracleScalar();
Line 79: myCommand.Connection.Close();
Line 80: // Response.ContentType = imgtype;
Source File: e:\website\wwwroot\myoa\upload.aspx.cs Line: 78 Stack Trace:
[InvalidCastException: Object must implement IConvertible.]
System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider) +122
System.Data.OracleClient.OracleParameter.SetCoercedValue(Type coerceType, Type noConvertType) +136
System.Data.OracleClient.OracleParameterBinding.PrepareForBind(OracleConnection connection, Int32& offset) +138
System.Data.OracleClient.OracleCommand.Execute(OciHandle statementHandle, CommandBehavior behavior, Boolean isReader, Boolean needRowid, OciHandle& rowidDescriptor, ArrayList& refCursorParameterOrdinals) +1937
System.Data.OracleClient.OracleCommand.Execute(OciHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciHandle& rowidDescriptor) +32
System.Data.OracleClient.OracleCommand.ExecuteScalarInternal(Boolean needCLStype, Boolean needRowid, OciHandle& rowidDescriptor) +438
System.Data.OracleClient.OracleCommand.ExecuteOracleScalar() +59
MyOa.upload.Button1_Click(Object sender, EventArgs e) in e:\website\wwwroot\myoa\upload.aspx.cs:78
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1277
====>
myCommand.ExecuteNonQuery();
Stream imgdatastream = File1.PostedFile.InputStream;
int imgdatalen = File1.PostedFile.ContentLength;
string imgtype = File1.PostedFile.ContentType;
string imgtitle = TextBox1.Text;
byte[] imgdata = new byte[imgdatalen];
int n = imgdatastream.Read(imgdata,0,imgdatalen);
OracleCommand myCommand = new OracleCommand("INSERT INTO UFILE(ufiletitle, ufiletype, ufiledata) VALUES (@imgtitle, @imgtype, @imgdata)");
myCommand.Connection = new OracleConnection("Data Source=OA;User ID=jack;Password=dian;Integrated Security=no;");
myCommand.CommandType = CommandType.Text; OracleParameter paramTitle = new OracleParameter("@imgtitle", OracleType.NVarChar, 50 );
paramTitle.Value = imgtitle;
myCommand.Parameters.Add( paramTitle); OracleParameter paramType = new OracleParameter( "@imgtype", OracleType.NVarChar, 50 );
paramType.Value = imgtype;
myCommand.Parameters.Add( paramType ); OracleParameter paramData = new OracleParameter( "@imgdata", OracleType.LongVarChar );
paramData.Value = imgdata;
myCommand.Parameters.Add( paramData );
myCommand.Connection.Open();
myCommand.ExecuteOracleScalar();
myCommand.Connection.Close();help。弄了一个下午都不清楚原因在哪