Update Query generated by the CommandBuilder

Abbasi

Member
Joined
Nov 2, 2005
Messages
17
Location
Pakistan
Programming Experience
3-5
I tried the expected GetUpdateCommand method of the CommandBuilder object to retrieve the Update Query generated by the object. But, it just returns the fully qualified name of the object ("System.Data.OleDb.OleDbCommand").
I could not find any other way. If anyone can let me know, how can I get the required result.
Thanks in anticipation.
R. A. Abbasi
 
VB.NET:
[SIZE=2][COLOR=#0000ff]Dim[/COLOR][/SIZE][SIZE=2] oledemo [/SIZE][SIZE=2][COLOR=#0000ff]As[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2][COLOR=#0000ff]New[/COLOR][/SIZE][SIZE=2] OleDb.OleDbCommandBuilder([/SIZE][SIZE=2][COLOR=#0000ff]Me[/COLOR][/SIZE][SIZE=2].OleDbDataAdapter1)
MessageBox.Show(oledemo.GetUpdateCommand.CommandText)
[/SIZE]
Is this what you were looking for?
 
Back
Top