Visual C# Winforms Database Problem

Question

I am having a problem with my database problem.. errr..

INSERT INTO Customer (CustomerName)
VALUES ('Joe Schmoe'); LAST_INSERT_ID();

I used something like that in my winform so this statement:

  INSERT INTO Customer (CustomerName)
  VALUES ('Joe Schmoe'); LAST_INSERT_ID();

-shows me the last inserted id in my customer column

I want to store the value that I can get into a variable so that whenever I put a value to its child table (foreign key) I will use what value that I have stored in my variable to my insert statement.

How can I store it in a variable or a control?

Community · Accepted Answer · 2017-05-23 12:19:03Z

2

Look at below examples. Cannot give the exact SQL without knowing your database.

SQL Server and C#: get last inserted id

Get inserted id.

How to get last inserted id?

Getting the identity of the most recently added record

C# Code Snippet - Get Identity Column Value from SQL Server

EDIT

If it is MySQL Database, you could use LAST_INSERT_ID() built in function.

Here is a code sample.

edited May 23, 2017 at 12:19

CommunityBot

11 silver badge

answered Sep 13, 2011 at 2:54

CharithJ

47.8k20 gold badges126 silver badges137 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Visual C# Winforms Database Problem

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related