将数据上传到oracle数据库 [英] uploading data to oracle data base
问题描述
我有一个数据表,它包含一行和一列ID类型的int。
oracle数据库中的表有一个名为ID且带有numeric数据类型的列。
代码如下。
cmd.Connection = oracleCon;
cmd.CommandText = @ INSERT INTO Name(ID)VALUES(:p1) ;
cmd.Parameters.Add( :p1, 1236);
cmd.ExecuteNonQuery();
这个工作正常。
但是如果我更改代码或者当我尝试从数据表中插入值时下面
<前lang =c#> cmd.Connection = oracleCon;
cmd.CommandText = @ INSERT INTO Name(ID)VALUES(:p1) ;
cmd.Parameters.Add( :p1,row [ ID]);
cmd.ExecuteNonQuery();
它不起作用。执行后查询系统挂起。
但如果我做了
cmd.Parameters.Add( :p1,Convert.ToInt32(row [ ID]));
然后系统挂起。
任何人都可以帮我解决这个问题。
谢谢
PP
问题是当我从数据库中删除因为它是一个oracle数据库而我没有从oracle数据库提交。所以系统没有响应。
现在任何方式都可以正常工作。
i have an data table and it contains a row and one column ID type of int.
And the table in oracle databse has a column named ID with numeric datatype.
the code is as below.
cmd.Connection = oracleCon;
cmd.CommandText = @"INSERT INTO Name(ID) VALUES(:p1)";
cmd.Parameters.Add(":p1", "1236");
cmd.ExecuteNonQuery();
this works fine.
but if i change the code or when i try to insert the value from the datatable as like below
cmd.Connection = oracleCon;
cmd.CommandText = @"INSERT INTO Name(ID) VALUES(:p1)";
cmd.Parameters.Add(":p1", row["ID"]);
cmd.ExecuteNonQuery();
it does not work. the system hangs after executenonquery.
but if i make it
cmd.Parameters.Add(":p1", Convert.ToInt32(row["ID"]));
then system hangs.
Can any one help me out of this.
Thanks
PP
And again the problem was that when i was deleting from the database as it is an oracle database i was not commiting from the oracle database.So the system was not responding.
Any way things aer now working fine.
这篇关于将数据上传到oracle数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!