Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cannot write to the physical database
Message
De
26/03/2008 13:58:46
 
 
À
26/03/2008 11:56:48
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Versions des environnements
Environment:
VB 9.0
OS:
Windows XP SP2
Database:
MS SQL Server
Divers
Thread ID:
01305661
Message ID:
01305819
Vues:
8
>>Can you post the code where you save your data? My first guess is that you are using a transaction but not committing it.
>
>Well, I'm not using transactions. The application is based on a DataGridView with a bunch of additional buttons. When you click on the Add button, the following code is executed:
>
>
>Dim frmMemberForm As New frmMember
>
>' dv_Member is a DataView of the underlying DataTable we are working with.
>Dim NewRow As DataRow = dv_Member.Table.NewRow()
>
>' this is my way of passing the new row to the data entry form.
>frmMemberForm.Tag = NewRow
>
>If frmMemberForm.ShowDialog() = Windows.FOrms.DialogResult.OK
>	dv_Member.Table.Rows.Add(NewRow)
>	NewRow.AcceptChanges()
>End If
>
>
>I'm not sure it's this code, since it works on the surface, so much as it is the connection between the DataSet and the SQL database itself. Especially since there are no SQL commands in the data adaptors. But when I tried putting commands there, the system threw a fit...

You're right. There's no "connection" between the Dataset and the Database. You must code the updates yourself.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform