String user = Convert.ToString(Page.User.Identity.Name); String address = Convert.ToString(txtStreet.Text); String name = Convert.ToString(txtName.Text); String city = Convert.ToString(txtCity.Text); String state = Convert.ToString(txtState.Text); int zip = Convert.ToInt32(txtZip.Text); int phone = Convert.ToInt32(txtPhone.Text); int ccnum = Convert.ToInt32(txtCCN.Text); int usersRemaining = 0; OleDbConnection objConnection = null; OleDbCommand objCmd = null; OleDbCommand objCmd1 = null; OleDbCommand objCmd2 = null; String strConnection, strSQL; strConnection = "Provider=Microsoft.Jet.OleDb.4.0;"; strConnection += @"Data Source= |DataDirectory|FinalProj.mdb"; objConnection = new OleDbConnection(strConnection); objConnection.ConnectionString = strConnection; objConnection.Open(); strSQL = "SELECT username FROM Users WHERE username = '" + user + "'"; objCmd = new OleDbCommand(strSQL, objConnection); usersRemaining = objCmd.ExecuteNonQuery(); Label10.Text = Convert.ToString(usersRemaining); if (usersRemaining == 1) { strSQL = "UPDATE Users SET name = '" + name + "', address='" + address + "', city = '" + city + "', state = '" + state + "', zip = '" + zip + "', phonenumber = '" + phone + "', ccnumber='" + ccnum + "' WHERE username = '" + user + "'"; objCmd1 = new OleDbCommand(strSQL, objConnection); objCmd1.ExecuteNonQuery(); } if (usersRemaining == 0) { strSQL = "INSERT INTO Users (username, name, address, City, state, zip, phonenumber, ccnumber) VALUES('" + user + "','" + name + "', '" + address + "', '" + city + "', '" + state + "', '" + zip + "', '" + phone + "', '" + ccnum + "')"; objCmd2 = new OleDbCommand(strSQL, objConnection); objCmd2.ExecuteNonQuery(); }