I want to show the id of table in other table using C#

Question

0.00/5 (No votes)

See more:

i have a database and i am using c# to build wpf app
the database has 6 table and every one of them have a id,
so in my application, i have insert button, when i click it
the data goes to database but the id of other in the table i execute is
null so i want to use sql connection when i insert all the data
i also insert the id of other table in my table.

What I have tried:

i tried to select the id of the table to my table but it did not work

Posted 17-Mar-23 12:04pm

islam ahmed 2023

Updated 17-Mar-23 19:45pm

Add a Solution

Comments

PIEBALDconsult 17-Mar-23 19:26pm

You should know the IDs before you write the data.

1 solution

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)

OriginalGriff · Answer 1 · 2023-03-17T19:45:00

I'm going to assume that you are using IDENTITY columns for your ID's so that SQL generates them for you - if not then you are using UNIQUEIDENTIFIER / Guid ID (in which case you could generate them when you do the INSERT and then you wouldn't need to ask this question).

So you need to fetch the value of the IDENTITY column that was just INSERTED - and SQL lets you do that with the @@IDENTITY value or SCOPE_IDENTITY function[^] value - you can retrieve that into your C# code by adding a SELECT command to your INSERT and replacing the call to ExecuteNonQuery with ExecuteScalar.