private void InsertAddress() { string addType = GetAddressType(); string columnName = "Type,fCustomerMasterID,Name1,Name2,AddrLine1,AddrLine2,City,State,PostCd,Country,PhoneNo,EntryDt,EntryID"; string updateString = "'" + addType + "'," + "'" + newCustID + "'," + "'" + txtCustName.Text.Replace("'", "''") + "'," + "'" + txtCustName2.Text.Replace("'", "''") + "'," + "'" + txtAddress1.Text.Replace("'", "''") + "'," + "'" + txtAddress2.Text.Replace("'", "''") + "'," + "'" + txtCity.Text.Replace("'", "''") + "'," + "'" + txtState.Text.Replace("'", "''") + "'," + "'" + txtPostCode.Text.Replace("'", "''") + "'," + "'" + txtCountry.Text.Replace("'", "''") + "'," + "'" + txtPhone.GetPhoneNumber.Replace("'", "''") + "'," + "'" + DateTime.Now.ToShortDateString() + "'," + "'" + Session["UserName"].ToString().Replace("'", "''") + "'"; AddressID = customerDetails.InsertAddressDetails(columnName, updateString); }