假设工资金额为20000,您可以尝试以下代码:
var commandText = "insert into Emp_table (SL_NO,empane,empid,salaray) values(:SL_NO,:empane,:empid,:salary)";
using (OracleConnection connection = new OracleConnection(connectionString))
using (OracleCommand command = new OracleCommand(commandText, connection))
{
command.Parameters.AddWithValue("SL_NO", 1);
command.Parameters.AddWithValue("empane", "sree");
command.Parameters.AddWithValue("empid", 1002);
command.Parameters.AddWithValue("salaray", 20000);
command.Connection.Open();
command.ExecuteNonQuery();
command.Connection.Close();
}