using System.Data.OracleClient; OracleParameter[] orcleParameters = new OracleParameter[datatable1.Columns.Count]; OracleParameter a = new OracleParameter(); a.ParameterName = dr.Table.Columns[i].ColumnName; orcleParameters[i] = a; orcleParameters[i].Value = "haha";