If statement to check if Primary ID excists

[Henningfeld]

This is what i got but what i want it to do is check if foID is null if it is then i want it to assign it a value it is the primary key in SQL database any suggestions?

if (foID = null) cmd.Parameters.Add(new SqlParameter("@foID", foID));
cmd.Parameters.Add(new SqlParameter("@OfficerFirstName", txtoffericerFirstName.text));
cmd.Parameters.Add(new SqlParameter("@OfficerMiddleName", txtofficerMiddleName.text));
cmd.Parameters.Add(new SqlParameter("@OfficerLastName", txtofficerLastName.text));
cmd.Parameters.Add(new SqlParameter("@OfficerSuffix", txtofficerSuffix.text));
cmd.Parameters.Add(new SqlParameter("@OfficerRank", txtofficersrank.text));
cmd.Parameters.Add(new SqlParameter("@DateIncident", txtdateOfIncident.text));
cmd.Parameters.Add(new SqlParameter("@DateDeath", txtdateOfDeath.text));
cmd.Parameters.Add(new SqlParameter("@LiaisonOfficerFirstName", txtliaisonOfficerFirstName.text));
cmd.Parameters.Add(new SqlParameter("@LiaisonOfficerLastName ", txtliaisonOfficerLastName.text));
cmd.Parameters.Add(new SqlParameter("@LiaisonOfficerStreet", txtliaisonOfficerstreet.text));
cmd.Parameters.Add(new SqlParameter("@LiaisonOfficerStreet2 ", txtliaisonOfficerstreet2.text));
cmd.Parameters.Add(new SqlParameter("@LiaisonOfficerCity", txtliaisonOfficerCity.text));
cmd.Parameters.Add(new SqlParameter("@LiaisonOfficerZip", txtliaisonOfficerZip.text));
cmd.Parameters.Add(new SqlParameter("@LiaisonOfficerPhoneNumber", txtliaisonOfficerPhoneNumber.text));
cmd.Parameters.Add(new SqlParameter("@LiaisonOfficerPhoneExtension", txtliaisonOfficerPhoneExtension.text));
cmd.Parameters.Add(new SqlParameter("@LiaisonOfficerPhoneNumber2", txtliaisonOfficerPhoneNumber2.text));
cmd.Parameters.Add(new SqlParameter("@LiaisonOfficerEmail", txtliaisonOfficerEmail.text));

[Freon22]

Its been a while since I have visited this forum. So I am sure you have worked through this by now. But incase you haven't check to see if foID is null if it is assign a value. If its not null go to the else part of the statement.

if (foID = null)
{
foID = assign a value;
cmd.Parameters.Add(new SqlParameter("@foID", foID));
}
else
}
cmd.Parameters.Add(new SqlParameter("@foID", foID));
}
cmd.Parameters.Add(new SqlParameter("@OfficerFirstName", txtoffericerFirstName.text));
cmd.Parameters.Add(new SqlParameter("@OfficerMiddleName", txtofficerMiddleName.text));
cmd.Parameters.Add(new SqlParameter("@OfficerLastName", txtofficerLastName.text));
cmd.Parameters.Add(new SqlParameter("@OfficerSuffix", txtofficerSuffix.text));
cmd.Parameters.Add(new SqlParameter("@OfficerRank", txtofficersrank.text));
cmd.Parameters.Add(new SqlParameter("@DateIncident", txtdateOfIncident.text));
cmd.Parameters.Add(new SqlParameter("@DateDeath", txtdateOfDeath.text));
cmd.Parameters.Add(new SqlParameter("@LiaisonOfficerFirstName", txtliaisonOfficerFirstName.text));
cmd.Parameters.Add(new SqlParameter("@LiaisonOfficerLastName ", txtliaisonOfficerLastName.text));
cmd.Parameters.Add(new SqlParameter("@LiaisonOfficerStreet", txtliaisonOfficerstreet.text));
cmd.Parameters.Add(new SqlParameter("@LiaisonOfficerStreet2 ", txtliaisonOfficerstreet2.text));
cmd.Parameters.Add(new SqlParameter("@LiaisonOfficerCity", txtliaisonOfficerCity.text));
cmd.Parameters.Add(new SqlParameter("@LiaisonOfficerZip", txtliaisonOfficerZip.text));
cmd.Parameters.Add(new SqlParameter("@LiaisonOfficerPhoneNumber", txtliaisonOfficerPhoneNumber.text));
cmd.Parameters.Add(new SqlParameter("@LiaisonOfficerPhoneExtension", txtliaisonOfficerPhoneExtension.text));
cmd.Parameters.Add(new SqlParameter("@LiaisonOfficerPhoneNumber2", txtliaisonOfficerPhoneNumber2.text));
cmd.Parameters.Add(new SqlParameter("@LiaisonOfficerEmail", txtliaisonOfficerEmail.text));