Insert (Save) value into two columns of same table using C# and VB.Net in ASP.Net

Hi George616,

Refer below code.

C#

int id = txtUserId.text;
string email = txtEmail.Text;
string password = txtPassword.Text;
string userType = ddlUserType.SelectedValue;
int createdBy = Convert.ToInt32(Session["Id"]); // Set after login.

string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
    using (SqlCommand cmd = new SqlCommand("INSERT INTO SignUp VALUES(@Id,@Email,@Pass,@UserType,@CreatedBy,@CreateDate)"))
    {
        cmd.Connection = con;
        cmd.Parameters.AddWithValue("@Id", id);
        cmd.Parameters.AddWithValue("@Email", email);
        cmd.Parameters.AddWithValue("@Pass", password);
        cmd.Parameters.AddWithValue("@UserType", userType);
        cmd.Parameters.AddWithValue("@CreatedBy", createdBy);
        cmd.Parameters.AddWithValue("@CreateDate", DateTime.Now);
        con.Open();
        cmd.ExecuteNonQuery();
        con.Open();
    }
}

VB.Net

Dim id As Integer = txtUserId.text
Dim email As String = txtEmail.Text
Dim password As String = txtPassword.Text
Dim userType As String = ddlUserType.SelectedValue
Dim createdBy As Integer = Convert.ToInt32(Session("Id")) ' Set after login.
Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
Using con As SqlConnection = New SqlConnection(constr)
    Using cmd As SqlCommand = New SqlCommand("INSERT INTO SignUp VALUES(@Id,@Email,@Pass,@UserType,@CreatedBy,@CreateDate)")
        cmd.Connection = con
        cmd.Parameters.AddWithValue("@Id", id)
        cmd.Parameters.AddWithValue("@Email", email)
        cmd.Parameters.AddWithValue("@Pass", password)
        cmd.Parameters.AddWithValue("@UserType", userType)
        cmd.Parameters.AddWithValue("@CreatedBy", createdBy)
        cmd.Parameters.AddWithValue("@CreateDate", DateTime.Now)
        con.Open()
        cmd.ExecuteNonQuery()
        con.Open()
    End Using
End Using