Insert Error:System.Da ta.NoNullAllowe dException

[Rich]

I've used VS2003 Wizard to create sqlDataAdapter, stored procedures, and
dataset on my application. I can search and update fine but Insert has error
unless I perform a search or update prior to my insert. Any ideas on how to
work around this without rewriting the database?

Code Snippet =============== =============== =============== ========

static void Main()
{
Application.Run (new Form1());
}

private void menuItem2_Click (object sender, System.EventArg s e)
{
//Initialize Staff Physician Screen
SetupStaffPhysi cian();
menuItem2.Enabl ed = false;
}

private void menuItem3_Click (object sender, System.EventArg s e)
{
//Exit Application
Application.Exi t();
}
private void SetupStaffPhysi cian()
{
panel1.Visible = true;
this.comboBox1. DataBindings.Ad d(new
System.Windows. Forms.Binding(" SelectedIndex", this.dsStaffPhy sicians1,
"tblStaffPhysic ians.docLicense State"));
}
private void ClearStaffPhysi cians()
{
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox5.Text = "";
comboBox1.Selec tedIndex = 0;
}

private void btnSearch_Click (object sender, System.EventArg s e)
{
sqlDataAdapter1 .SelectCommand. Parameters["@Param2"].Value = textBox3.Text;
dsStaffPhysicia ns1.Clear();
sqlDataAdapter1 .Fill(dsStaffPh ysicians1);
}

private void btnReset_Click( object sender, System.EventArg s e)
{
this.dsStaffPhy sicians1.Clear( );
ClearStaffPhysi cians();
}

private void btnUpdate_Click (object sender, System.EventArg s e)
{
this.BindingCon text[dsStaffPhysicia ns1,
"tblStaffPhysic ians"].EndCurrentEdit ();
sqlDataAdapter1 .Update(dsStaff Physicians1);
sqlDataAdapter1 .Fill(dsStaffPh ysicians1);
}

private void btnInsert_Click (object sender, System.EventArg s e)
{
//Get error here
this.BindingCon text[dsStaffPhysicia ns1, "tblStaffPhysic ians"].AddNew();
ClearStaffPhysi cians();
}

private void btnCommit_Click (object sender, System.EventArg s e)
{

this.BindingCon text[dsStaffPhysicia ns1,
"tblStaffPhysic ians"].EndCurrentEdit ();
sqlDataAdapter1 .Update(dsStaff Physicians1);
}
}
}