The Lounge - CodeProject

David Crow29-Jul-20 10:27

29-Jul-20 10:27

No, but if the mouse is not sensing the surface correctly, it won't communicate correctly regardless of how its connected (wired or wireless).

"One man's wage rise is another man's price increase." - Harold Wilson

"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons

"You can easily judge the character of a man by how he treats those who can do nothing for him." - James D. Miles

passing UserID into other columns

Georgeakpan1329-Jul-20 6:12

Georgeakpan13

29-Jul-20 6:12

I am trying to insert record into two tables and fetch the UserId of first table and insert into another column of the same table and also into another table but it appears that when I insert data into the tables, the Id of the user is returned and inserted into the second table but inserted a different interger into another column of same first table.
For example, I have UserTable and WalletTable and I want to insert records simultaneously into the two tables and at the same time fetch the Id of UserTable and insert into columns of both tables.
Here is the structure of the first Table: I want to fetch “UserID” in UserTable and insert into “CreatedBy” of UserTable and UserID of WalletTable. But after inserting I discovered that interger “-1” is inserted in CreatedBy column of UserTable and on WalletTable the correct UserID is inserted. How can I correct this please?
UserTable:
UserID | email | pass | con_pass | UserRole | Name | CreatedBy | image | CreateDate |
WalletTable:
Id | UserID | email | Name | amount |
Here is my Insert code (C#)

if (mailtxtbx.Text != "" & pass.Text != "" & conpass.Text != "" & txtname.Text !="")
{
    if (pass.Text == conpass.Text)
    {
        if (Filedoc.PostedFile.FileName != "")
        {
            if (check1.Checked)
              {
                int Uid = -1;

                byte[] image;
                Stream s = Filedoc.PostedFile.InputStream;
                BinaryReader br = new BinaryReader(s);
                image = br.ReadBytes((Int32)s.Length);
                // define query to be executed
                string query = @"INSERT INTO Users (email, pass, con_pass, UserRole, Name, CreatedBy, image, CreateDate) VALUES (@email, @pass, @con_pass, @UserRole, @Name, @CreatedBy, @image, @CreateDate);
                SELECT SCOPE_IDENTITY();";
                // set up SqlCommand in a using block
                using (SqlCommand objCMD = new SqlCommand(query, con))
                {
                    // add parameters using regular ".Add()" method
                    objCMD.Parameters.Add("@email", SqlDbType.VarChar, 50).Value = mailtxtbx.Text.Trim();
                    objCMD.Parameters.Add("@pass", SqlDbType.VarChar, 100).Value = pass.Text.Trim();
                    objCMD.Parameters.Add("@con_pass", SqlDbType.VarChar, 50).Value = conpass.Text.Trim();
                    objCMD.Parameters.Add("@UserRole", SqlDbType.VarChar, 50).Value = 'A';
                    objCMD.Parameters.Add("@Name", SqlDbType.VarChar, 50).Value = txtname.Text.Trim();
                    objCMD.Parameters.Add("@CreatedBy", SqlDbType.Int, 50).Value = Uid;
                    objCMD.Parameters.Add("@image", SqlDbType.VarBinary).Value = image;
                    objCMD.Parameters.Add("@CreateDate", SqlDbType.DateTime, 100).Value = DateTime.Now;
                    // open connection, execute query, close connection
                    con.Open();
                    object returnObj = objCMD.ExecuteScalar();

                    if (returnObj != null)
                    {
                        int.TryParse(returnObj.ToString(), out Uid);
                    }
                    cmd.ExecuteNonQuery();
                }
                con.Close();

                if (Uid > 0)
                {
                    query = @"INSERT INTO UserWallet (Uid, email, Name, amount) VALUES (@Uid, @email, @Name, @amount)";
                    using (SqlCommand objCMD = new SqlCommand(query, con))
                    {
                        // add parameters using regular ".Add()" method
                        objCMD.Parameters.Add("@Uid", SqlDbType.Int, 50).Value = Uid;
                        objCMD.Parameters.Add("@email", SqlDbType.VarChar, 50).Value = mailtxtbx.Text.Trim();
                        objCMD.Parameters.Add("@Name", SqlDbType.VarChar, 50).Value = txtname.Text.Trim();
                        objCMD.Parameters.Add("@amount", SqlDbType.Float, 100).Value = 0; //Change type here accordingly
                        con.Open();
                        object returnObj = objCMD.ExecuteScalar();

                        if (returnObj != null)
                        {
                            int.TryParse(returnObj.ToString(), out Uid);
                        }
                        cmd.ExecuteNonQuery();
                        lblsuccess.Visible = true;
                        Div1.Visible = true;
                        lblsuccess.Text = "Successfully Signed Up";
                        lblsuccess.ForeColor = System.Drawing.Color.Green;
                        lblMessage.Visible = false;
                        dvMessage.Visible = false;
                        mailtxtbx.Text = "";
                        pass.Text = "";
                        conpass.Text = "";
                        txtname.Text = "";
                        // Response.Redirect("Default.aspx");
                    }
                }
                con.Close();
            }

Welcome to the Lounge