error when inserting unique values

[Muhammad Usman]

hi,

I have a table of student which contain four fields that
are id(primary key number) , name(text),seme ster(text)and
corse(text), When I insert values in a student
table.Explorer Show the follwing exception string.

"The changes you requested to the table were not
successful because they would create duplicate values in
the index, primary key, or relationship. Change the data
in the field or fields that contain duplicate data, remove
the index, or redefine the index to permit duplicate
entries and try again."

I am using different values in the code that are not
already exist in table.

The code for insertion is given below.

try
{
OleDbConnection con=new
OleDbConnection (@"provider=mic rosoft.jet.oled b.4.0 ; data
source=D:\Inetp ub\wwwroot\ado_ net\test.mdb");
string isql="INSERT INTO
student VALUES(14,'sam' ,'4th','ACCP')" ;
OleDbCommand ins=new
OleDbCommand(is ql,con);
ins.Connection. Open();
ins.ExecuteNonQ uery();
ins.Connection. Close();
}
catch(Exception ec)
{
Response.Write
(ec.Message.ToS tring());
}
Please solve my problem, i am using c# as code behind.
Thanks

Muhammad Usman.

[Srini]

What is the hardcoded 14 . Check in the database if a 14
already exists in the database or not. I think if you
change the database field as type auto it should suffice
your purpose.

-----Original Message-----
hi,

I have a table of student which contain four fields that
are id(primary key number) , name(text),seme ster(text)and
corse(text), When I insert values in a student
table.Explor er Show the follwing exception string.

"The changes you requested to the table were not
successful because they would create duplicate values in
the index, primary key, or relationship. Change the data
in the field or fields that contain duplicate data, removethe index, or redefine the index to permit duplicate
entries and try again."

I am using different values in the code that are not
already exist in table.

The code for insertion is given below.

try
{
OleDbConnection con=new
OleDbConnectio n(@"provider=mi crosoft.jet.ole db.4.0 ; data
source=D:\Inet pub\wwwroot\ado _net\test.mdb") ;
string isql="INSERT INTO
student VALUES(14,'sam' ,'4th','ACCP')" ;
OleDbCommand ins=new
OleDbCommand(i sql,con);
ins.Connection. Open();
ins.ExecuteNonQ uery();
ins.Connection. Close();
}
catch(Exception ec)
{
Response.Write
(ec.Message.To String());
}
Please solve my problem, i am using c# as code behind.
Thanks

Muhammad Usman.
.