DataAdapter1.InsertCommand.CommandText = "INSERT INTO Customers (CustomerID, FirstName, LastName, Address, City, State, Zip, Password) VALUES (@CustomerID, @FirstName, @LastName, @Address, @City, @State, @Zip, @Password)"
DataAdapter1.InsertCommand.Parameters("@CustomerID").SqlDbType = SqlDbType.Int
DataAdapter1.InsertCommand.Parameters("@CustomerID").Value = mCustomerID
DataAdapter1.InsertCommand.Parameters("@FirstName").SqlDbType = SqlDbType.NVarChar
DataAdapter1.InsertCommand.Parameters("@FirstName").Size = 64
DataAdapter1.InsertCommand.Parameters("@FirstName").Value = mFirstName
' etc...