CODEWITHSUNDEEP
c#asp.net.netwebforms
Rahul Anand
Rahul Anand

Reputation: 33

Unable to import data to database from web form

I am unable to import user entered data from .cs to tables. I got 2 tables one taking all user details while other takes the username(First name) and Password. Except the password and username the data gets into the details table. Here is the code from .cs

public partial class signUp : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) {

    }

    protected void btnReg_Click(object sender, EventArgs e)
    {
        string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;


        using (SqlConnection con = new SqlConnection(cs))
        {

            //string encryption = FormsAuthentication.HashPasswordForStoringInConfigFile(txtPassword.Text, "SHA1");
            SqlCommand cmd2 = new SqlCommand("sp_PasswordStorage", con);
            SqlCommand cmd = new SqlCommand("sp_procedure", con);
            cmd2.CommandType = CommandType.StoredProcedure;
            cmd.CommandType = CommandType.StoredProcedure;

            if (Page.IsValid)
            {
                cmd.Parameters.AddWithValue("@Fname", txtFname.Text);
                cmd2.Parameters.AddWithValue("@uname", txtFname.Text);
                cmd2.Parameters.AddWithValue("@pswd", Encryption(txtPassword.Text));
                cmd.Parameters.AddWithValue("@Lname", txtLname.Text);
                cmd.Parameters.AddWithValue("@Age", txtAge.Text);
                cmd.Parameters.AddWithValue("@eid", txtEmail.Text);
                cmd.Parameters.AddWithValue("@pno", txtPhone.Text);
                cmd.Parameters.AddWithValue("@city", txtCity.Text);
                cmd.Parameters.AddWithValue("@country", txtCountry.Text);
                cmd.Parameters.AddWithValue("@gender", dropGender.SelectedItem.Value);
                cmd.Parameters.AddWithValue("@role", dropRole.SelectedItem.Value);

                con.Open();
                cmd.ExecuteNonQuery();
                //MessageBox.Show("Registration successfully");
                Server.Transfer("MainPage.aspx", true);
            }
            else
            {
                MessageBox.Show("Registration Failed");
                MessageBox.Show("Please Try Again Later");
                Server.Transfer("MainPage.aspx", true);
            }
        }
    }
    public string Encryption(string value)
    {
        SHA1 algorithm = SHA1.Create();
        byte[] data = algorithm.ComputeHash(Encoding.UTF8.GetBytes(value));
        string sh1 = "";
        for (int i = 0; i < data.Length; i++)
        {
            sh1 += data[i].ToString("x2").ToUpperInvariant();
        }
        return sh1;
    }

}

}

Any help would be appreciated, thank you :)

Upvotes: 0

Views: 100

Answers (1)

Anar Iskenderov
Anar Iskenderov

Reputation: 46

I think, it just to execute both command.

cmd.ExecuteNonQuery();
cmd2.ExecuteNonQuery();

Upvotes: 2

Related Questions