Hi
I have a Typed DataSet.
I've databinded it to some text controls on my form, controls show data
when I show record.
But now I would like to create a new record with this form, controls and
dataset. A add new row to dataset:
<C#>
dokNaglowki1._DokNaglowki.AddDokNaglowkiRow(
dokNaglowki1._DokNaglowki.NewDokNaglowkiRow() );
</C#>
then alter data in controls and click save.
I save it like this:
<C#>
Database connection = DatabaseFactory.CreateDatabase();
//
// create adapter
//
using( DbDataAdapter adapter = connection.GetDataAdapter() )
{
//
// assign commnand to adapter
//
if( createText != null && createText.Length > 0 )
{
// dok_numer, dok_seria and dok_data are
// columns from DB and DS
// numer, seria, data are parameters of
// stored procedure used to add new records
// createText = DokNaglowkiDodaj - stored proc
adapter.InsertCommand =
connection.GetStoredProcCommand( createText );
connection.AddInParameter( adapter.InsertCommand,
"numer", DbType.Int32, "dok_numer", DataRowVersion.Current );
connection.AddInParameter( adapter.InsertCommand,
"seria", DbType.String, "dok_seria", DataRowVersion.Current );
connection.AddInParameter( adapter.InsertCommand,
"data", DbType.DateTime, "dok_data", DataRowVersion.Current );
adapter.InsertCommand.Connection =
connection.CreateConnection();
}
if( updateText != null && updateText.Length > 0 )
{
adapter.UpdateCommand =
connection.GetStoredProcCommand( updateText );
adapter.UpdateCommand.Connection =
connection.CreateConnection();
}
if( deleteText != null && deleteText.Length > 0 )
{
adapter.DeleteCommand =
connection.GetStoredProcCommand( deleteText );
adapter.DeleteCommand.Connection =
connection.CreateConnection();
}
//
// update target
//
return connection.UpdateDataSet( target, "DokNaglowki",
adapter.InsertCommand,
adapter.UpdateCommand, adapter.DeleteCommand,
UpdateBehavior.Standard );
</C#>
Everything looks ok. I've mostly copied it from Enterprise Library Demo.
But it won't work. Parameters' values are not set so I get Exception
from database because fields cannot have null value.
What am I doing wrong?
best regards
Mateusz [PEYN] Adamus
http://adamus.home.pl