Hi,
I am trying to insert a record into my database by using parameters, but I
get the error message System.Data.SqlClient.SqlException. Here is my code
below.
TIA
Roy
using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using System.Text;
namespace testing
{
class Class1
{
[STAThread]
static void Main(string[] args)
{
int lnSOBN=900;
int lnBN1=88;
string strConnection = "Server=(local);Integrated
Security=yes;database=royDB";
SqlConnection conn = new SqlConnection(strConnection);
conn.Open();
StringBuilder strInsert = new StringBuilder("insert into tblRoy ");
strInsert.Append("(SOBN, BN1)");
strInsert.Append(" VALUES (@par0, @par1)");
SqlCommand c = new SqlCommand(strInsert.ToString(), conn);
c.Parameters.Add(new SqlParameter("par0", lnSOBN));
c.Parameters.Add(new SqlParameter("par1", lnBN1));
c.ExecuteNonQuery();
conn.Close();
}
}
}