for each student_id threre should be unique question_id in my answer table

Question

1.00/5 (1 vote)

See more:

i have table Answer colums are
ans_id identity key //primary key
question_id foreign key
student_id foreign key
answer varchar(500)

so how to query or any kind of setting needed
i am developing application ASP.Net with C#

Posted 19-Mar-14 19:14pm

swati gapat

Add a Solution

Comments

syed shanu 20-Mar-14 1:46am

so what you want .In your Answer thble you have question_id and student_id .And i belive that you will be having question Table and Student table.And i think you will have student details tabel where you will have each student matching question with question id.After student enter the anser in save you will insert the student_id,Question_id and answer to Anser table and create one answer_id for that.During save you need to check the answer table weather for that student already question id is inserted or not if not then do save.Whats problem in this .

swati gapat 20-Mar-14 4:47am

yes i want to do this but i don't know how to do it

swati gapat 20-Mar-14 4:52am

yes i want to do this but don't know how to do?
if student double click on insert button question_id will store two times in Answer table but this should not happen..so how can I overcome this problem..please reply

syed shanu 20-Mar-14 5:02am

you should create a stored procedure for insert and in SP you should check the table which already has qustion id or not .if question id not exist then insert else dont insert .google about creating Stored procedure and check eixiting record

swati gapat 20-Mar-14 9:03am

thanks

swati gapat 20-Mar-14 9:54am

but i don'r know where to write in my program
when i am writing on click f button
program like create procedure it giving me an error of missing namespace or directive.

OriginalGriff 20-Mar-14 2:44am

This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind.
Use the "Improve question" widget to edit your question and provide better information.

2 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)

Anudeep Jaiswal - MCA · Answer 1 · 2014-03-20T00:16:00

Solution 2

In Table Designer
Select question_id
And student_id
And Right Click on Left Side Of Designer With Your Mouse
To Open Context Menu To Set Primary Key.

Once You Set Primary Key,
Now Only Distinct Value Can Be Save .

Posted 20-Mar-14 0:16am

Anudeep Jaiswal - MCA

sankarsan parida · Answer 2 · 2014-03-20T00:45:00

Solution 3

See I have written a storeprocedure it should something like this I don't know your table name, I just studied your conversation and procedure something like this

create procedure usp_QuestionAnswer
{
@question_id int=0 ,
@student_id int =0,
@answer varchar(500)=null
}
AS BEGIN
//Check if data exists or not
if not exists(select question_id from tblQuestionAnswer where question_id = @question_id  and  student_id =@student_id  ) begin
   insert into tblQuestionAnswer(question_id ,student_id,answer)
   values(@question_id ,@student_id,@answer)

end

END

Posted 20-Mar-14 0:45am

sankarsan parida

Comments

swati gapat 20-Mar-14 9:57am

but i don't know where to write in my program
when i am writing on click of button,
program like create procedure it giving me an error of missing namespace or directive.
tell how to write i am using C#

[no name] 20-Mar-14 12:59pm

if you don't know uses of storeprocedure. And you want use only c# code behind then do it like something below
string query="if not exists(select question_id from tblQuestionAnswer where question_id =@question_id and student_id =@student_id ) begin insert into tblQuestionAnswer(question_id ,student_id,answer) values(@question_id ,@student_id,@answer)";
SqlCommand newCommand=new SqlCommand(connection,query);

Hope so other things you know it very well

swati gapat 20-Mar-14 14:44pm

but if record exist .. how to show error message
how to show output text as answers are already inserted

swati gapat 20-Mar-14 14:47pm

thanks..code is working

but how to show message that record is already exist
in procedure or any othre way

[no name] 21-Mar-14 1:35am

great! And you can mark me as your answer.
if exists(select question_id from tblQuestionAnswer where question_id = @question_id and student_id =@student_id) begin
select * from tblQuestionAnswer where question_id = @question_id and student_id =@student_id end

You can do like this