primary key forigen key refernce

Question

1.00/5 (2 votes)

See more:

C#

string ConnectionString = "User ID=SYSDBA;Password=masterkey;" + "Database=localhost:C:\\Documents and Settings\\manyam\\Desktop\\ITAS.FDB; " + "DataSource=localhost;Charset=NONE;";

Posted 4-Mar-12 22:14pm

2011999

Updated 5-Mar-12 1:14am

v5

Add a Solution

Comments

Oshtri Deka 5-Mar-12 4:27am

Can you please write your table schema?

amolpatil2243 5-Mar-12 4:29am

is your table contains LVE_ID as primary key??

2011999 5-Mar-12 4:34am

yes

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wayne Gaylard · Answer 1 · 2012-03-04T22:34:00

You are obviously either trying to enter a value into LVE_ID that is already in the database (duplicate value) or you are trying to enter a value into this field where the field is meant to be auto generated. I will also mention that you should be using parameterised values instead of concatenating strings to produce your sql query. This will, first of all prevent you from entering values of the wrong type for the field as well as prevent you from suffering an sql injection attack. Here is a sample of what I mean by parameterised query

SQL

INSERT into ATT_LVE (LVE_ID,LVE_EMP_ID,LVE_TYP_ID,LVE_BGNAT,LVE_ENDAT,LVE_REASON,LVE_BGN,LVE_END,LVE_STATUS,LVE_APPLIEDON)Values (@LVE_ID,@LVE_EMP_ID,@LVE_TYP_ID,@LVE_BGNAT,@LVE_ENDAT,@LVE_REASON,@LVE_BGN,@LVE_END,@LVE_STATUS,@LVE_APPLIEDON)

C#

cmd.Parameters.AddWithValue("@LVE_ID", txtLeaveID.Text);
cmd.Parameters.AddWithValue("@LVE_EMP_ID", txtEmpID.Text);
cmd.Parameters.AddWithValue("@LVE_TYP_ID", ddlLeaveType.Text);

etc

Hope this helps

amolpatil2243 · Answer 2 · 2012-03-04T22:40:00

Solution 2

hi,

If you are having
LVE_ID as primary key. then make as auto increment true. and do not pass the text box value to LVE_ID. I think it will work.

hope this may help you

Posted 4-Mar-12 22:40pm

amolpatil2243

chandrasen singh · Answer 3 · 2012-03-04T22:46:00

Solution 3

It seems your primary key LVE_ID is integer(or non string ) ,and you pass string by ' txtLeaveID.Text' so you must have to coverty txtLeaveID.Text to integer (by using SqlDbType class) or whatever the datatype of LVE_ID is.
like

command.Parameters.Add("@ LVE_ID", SqlDbType.Int);

Hope this will help

Posted 4-Mar-12 22:46pm

chandrasen singh

Updated 4-Mar-12 22:58pm

v3

Comments

2011999 5-Mar-12 5:06am

not working

chandrasen singh 5-Mar-12 5:09am

would you write table structure ???

2011999 5-Mar-12 5:17am

above posted