SQLCommandBuilder ignoring fields?

[JarHead]

Ok, very frustrating problem...I am adding a new row to a database, using SQLCommandBuilder to construct the SQL statement for me, but as it does so, its ignoring one of the fields! please help... here the code...

 

objNewRow("Username") = UN

objNewRow("Password") = PWD ' <----- IGNORING THIS FIELD

objNewRow("FName") = FName

objNewRow("LName") = LName

objDataTable.Rows.Add(objNewRow)

 

Dim objInsertCommand As New SqlClient.SqlCommandBuilder(objAdapter)

objAdapter.InsertCommand = objInsertCommand.GetInsertCommand

 

objAdapter.Update(objDataSet)

 

I have read objAdapter.InsertCommand.CommandText, and there is no password field. Anyone know a way to help?