Hello all!
This is my first post to this list and here's some environment
information before asking my first question.
.NET 2.0, FirebirdClient 2.0, Visual Basic 2005 Express
I use the following code to fill a dataset from an dataadapter and
connect the table "CATEGORY" from the dataset to a datagridview:
Dataset_MIODB = New System.Data.DataSet()
Me.FbDataAdapter_CATEGORY.Fill(Me.Dataset_MIODB, "CATEGORY")
Me.DataGridView1.DataSource = Me.Dataset_MIODB
Me.DataGridView1.DataMember = "CATEGORY"
The datagridview shows the data from the table - now I edit the values,
add a few rows and to the following:
Me.Dataset_MIODB.AcceptChanges()
Me.FbDataAdapter_CATEGORY.Update(Me.Dataset_MIODB, "CATEGORY")
Me.FbConnection_MIODB.Close()
Me.FbConnection_MIODB.Open()
Now I reread the content of the database and nothing has changed. And I
really don't know why - do I use the dataset and the adapter as it
should be?
Thanks for your help!
Regards,
Daniel
Oh, here are the commands of the dataadapter:
'
'FbDataAdapter_CATEGORY
'
Me.FbDataAdapter_CATEGORY.DeleteCommand =
Me.FbCommand_CATEGORY_Delete
Me.FbDataAdapter_CATEGORY.InsertCommand =
Me.FbCommand_CATEGORY_Insert
Me.FbDataAdapter_CATEGORY.SelectCommand =
Me.FbCommand_CATEGORY_Select
Me.FbDataAdapter_CATEGORY.UpdateCommand =
Me.FbCommand_CATEGORY_Update
'FbCommand_CATEGORY_Select
'
Me.FbCommand_CATEGORY_Select.CommandText = "SELECT * FROM
CATEGORY;"
Me.FbCommand_CATEGORY_Select.CommandTimeout = 30
Me.FbCommand_CATEGORY_Select.Connection = Me.FbConnection_MIODB
'
'FbCommand_CATEGORY_Delete
'
Me.FbCommand_CATEGORY_Delete.CommandText = "DELETE FROM
CATEGORY WHERE ((ID = @p1))"
Me.FbCommand_CATEGORY_Delete.CommandTimeout = 30
Me.FbCommand_CATEGORY_Delete.Connection = Me.FbConnection_MIODB
Me.FbCommand_CATEGORY_Delete.Parameters.Add(New
FirebirdSql.Data.FirebirdClient.FbParameter("@p1",
FirebirdSql.Data.FirebirdClient.FbDbType.[Integer], 4,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "ID", System.Data.DataRowVersion.Original,
CType(resources.GetObject("FbCommand_CATEGORY_Delete.Parameters"), Object)))
'
'FbCommand_CATEGORY_Insert
'
Me.FbCommand_CATEGORY_Insert.CommandText = "INSERT INTO
CATEGORY (ID, NAME) VALUES (@p1, @p2)"
Me.FbCommand_CATEGORY_Insert.CommandTimeout = 30
Me.FbCommand_CATEGORY_Insert.Connection = Me.FbConnection_MIODB
Me.FbCommand_CATEGORY_Insert.Parameters.Add(New
FirebirdSql.Data.FirebirdClient.FbParameter("@p1",
FirebirdSql.Data.FirebirdClient.FbDbType.[Integer], 4,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "ID", System.Data.DataRowVersion.Current,
CType(resources.GetObject("FbCommand_CATEGORY_Insert.Parameters"), Object)))
Me.FbCommand_CATEGORY_Insert.Parameters.Add(New
FirebirdSql.Data.FirebirdClient.FbParameter("@p2",
FirebirdSql.Data.FirebirdClient.FbDbType.[Char], 100,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "NAME", System.Data.DataRowVersion.Current,
CType(resources.GetObject("FbCommand_CATEGORY_Insert.Parameters1"),
Object)))
'
'FbCommand_CATEGORY_Update
'
Me.FbCommand_CATEGORY_Update.CommandText = "UPDATE CATEGORY SET
ID = @p1, NAME = @p2 WHERE ((ID = @p3))"
Me.FbCommand_CATEGORY_Update.CommandTimeout = 30
Me.FbCommand_CATEGORY_Update.Connection = Me.FbConnection_MIODB
Me.FbCommand_CATEGORY_Update.Parameters.Add(New
FirebirdSql.Data.FirebirdClient.FbParameter("@p1",
FirebirdSql.Data.FirebirdClient.FbDbType.[Integer], 4,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "ID", System.Data.DataRowVersion.Current,
CType(resources.GetObject("FbCommand_CATEGORY_Update.Parameters"), Object)))
Me.FbCommand_CATEGORY_Update.Parameters.Add(New
FirebirdSql.Data.FirebirdClient.FbParameter("@p2",
FirebirdSql.Data.FirebirdClient.FbDbType.[Char], 100,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "NAME", System.Data.DataRowVersion.Current,
CType(resources.GetObject("FbCommand_CATEGORY_Update.Parameters1"),
Object)))
Me.FbCommand_CATEGORY_Update.Parameters.Add(New
FirebirdSql.Data.FirebirdClient.FbParameter("@p3",
FirebirdSql.Data.FirebirdClient.FbDbType.[Integer], 4,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "ID", System.Data.DataRowVersion.Original,
CType(resources.GetObject("FbCommand_CATEGORY_Update.Parameters2"),
Object)))
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
