How to insert in 2 tables with recent id using command parameter

Question

0.00/5 (No votes)

See more:

Hi Expert,

I am uday Satardekar,

I am developing asp.net website and i have to insert in 2 table in MySql.

First table is tbl_login and 2nd Table is tbl_user_role
Both tables are autoincremanted.

tbl_user_role contains user_id which will be last inserted id from tbl_login

My code for inserting in tbl_login is following

C#

string queryStr = "INSERT INTO tbl_login(username,password,name,designation,category_assign,email) VALUES (?username,?password,?name,?designation,?categoryAssign,?email)";


command1 = new MySqlCommand(queryStr, connect);
command1.Transaction = transaction;

command1.Parameters.AddWithValue("?username", username);
command1.Parameters.AddWithValue("?password", EncrptPwd);
command1.Parameters.AddWithValue("?name", name);
command1.Parameters.AddWithValue("?designation", designation);

command1.Parameters.AddWithValue("?categoryAssign", categoryAssign);
command1.Parameters.AddWithValue("?email", email);

command1.ExecuteNonQuery();

Now i have to insert in 2nd table tbl_user_role and I have to insert autoincremented id from tbl_login into table <b>tbl_user_role</b>

How To insert in 2 table with transaction?

Please Help me.

Thankssssssss in adv.

Posted 17-Oct-11 0:14am

udusat13

Add a Solution

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)

_Tushar Patil · Answer 1 · 2011-10-17T00:40:00

Hi Uday,
you want to insert last inserted user_id from tbl_login table into user_role table..?

you can write Trigger here to this.....

<pre lang="SQL">set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

CREATE TRIGGER [Trigger_Insert_IWO_ID] ON [dbo].[tbl_login]
FOR INSERT
AS

INSERT INTO user_role
        -- (col1, col2    , col3, user_id, user_name)
             (iwo_no)
    SELECT
        user_id
 
        FROM inserted

_Tushar Patil · Answer 2 · 2011-10-17T19:22:00

Solution 2

Refer Below Link..........................
http://www.google.co.in/#hl=en&sa=X&ei=QwydTr_6GYXSrQegoeyqCQ&ved=0CDkQvwUoAQ&q=how+to+crack+gsm+modem+to+use+with+pic+controller&spell=1&bav=on.2,or.r_gc.r_pw.,cf.osb&fp=2ca78f87d9791422&biw=1024&bih=649

Posted 17-Oct-11 19:22pm

_Tushar Patil