uploading data to oracle data base

See more:

C#

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