Database

strCmd = "SELECT FLAG FROM SongsFlagsContinents WHERE SECT='" + CountryName + "'";
cmd = new OleDbCommand(strCmd, Main.Connection);
cmd.Connection.Open();
rdr = cmd.ExecuteReader();
rdr.Read();
MessageBox.Show(rdr["FLAG"].ToString());
cmd.Connection.Close();

ALTER PROCEDURE dbo.StoredProcedure3

	(
	
	@GetUserType bigint, 
	@GetAccountStatus bit,
	@GetTitle nchar(10),
	@GetFirstName nvarchar(50),
	@GetMiddleInitial nchar(2),
	@GetLastName nvarchar(50),
	@GetEmailAddress nvarchar(125),		
	)

AS

INSERT INTO Customer 
	
  VALUES  (
  
 	@GetUserType, 
	@GetAccountStatus,
	@GetTitle,
	@GetFirstName,
	@GetMiddleInitial,
	@GetLastName,
	@GetEmailAddress,

	EXEC StoredProcedure3	
	RETURN

INSERT INTO Customer 	  
       (
        UserType,
        AccountStatus,
        FirstName,
        MiddleInitial,
        LastName,
        EmailAddress        )
VALUES  (   
	@GetUserType,
 	@GetAccountStatus,
	@GetTitle,           <-------- Where is this parameter going
	@GetFirstName,
	@GetMiddleInitial,
	@GetLastName,
	@GetEmailAddress)

@GetEmailAddress,
EXEC StoredProcedure3 <------
RETURN

JUNEYT wrote:

SetUserType.IsNullable = False

Harvey Saayman wrote:

clients connect to the db with the appropriate username & password