[Help] SQL Query

Please support our C# advertiser: Intel Parallel Studio Home
Reply

Join Date: May 2009
Posts: 7
Reputation: follow33 is an unknown quantity at this point 
Solved Threads: 0
follow33 follow33 is offline Offline
Newbie Poster

[Help] SQL Query

 
0
  #1
Jun 6th, 2009
Hello to everyone !!!

I have a problem with query in sql.
Look in the photo and you will find details about my problem.

Why i cant add a new record.
When i will add ID, Emri and Cmimi i want to show them automatically...

Does any one have idea about it ???

Click image for larger version

Name:	fotoja.jpg
Views:	8
Size:	67.9 KB
ID:	10377
Reply With Quote Quick reply to this message  
Join Date: Feb 2002
Posts: 898
Reputation: Tekmaven is a glorious beacon of light Tekmaven is a glorious beacon of light Tekmaven is a glorious beacon of light Tekmaven is a glorious beacon of light Tekmaven is a glorious beacon of light 
Solved Threads: 27
Moderator
Tekmaven's Avatar
Tekmaven Tekmaven is offline Offline
The C# Man, Myth, Legend

Re: [Help] SQL Query

 
0
  #2
Jun 6th, 2009
You need to do an INSERT query to add data. You gave us a screenshot of a SELECT query. Since you have two tables with a relationship, when you go to insert a row in both tables with the same ID.
-Ryan Hoffman

.NET Specialist / Webmaster, Extended64.com.
Please do not email or PM me with support questions. Please direct them to the forums instead.
Reply With Quote Quick reply to this message  
Join Date: May 2009
Posts: 7
Reputation: follow33 is an unknown quantity at this point 
Solved Threads: 0
follow33 follow33 is offline Offline
Newbie Poster

Re: [Help] SQL Query

 
0
  #3
Jun 6th, 2009
I write the same code in Acces and there it works ok but here in C# it doesnt work... In acces after i make that query then i just have to put the ID, Emri and Cmimi are shown automatically.
Now do you understand me ???
Reply With Quote Quick reply to this message  
Join Date: May 2009
Posts: 7
Reputation: follow33 is an unknown quantity at this point 
Solved Threads: 0
follow33 follow33 is offline Offline
Newbie Poster

Re: [Help] SQL Query

 
0
  #4
Jun 6th, 2009
Here when i put the ID , Emri and Cmimi are shown automatically
Click image for larger version

Name:	fotoja1.jpg
Views:	3
Size:	107.0 KB
ID:	10379
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC