Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trouble in parameters
Message
From
13/10/2005 09:01:28
Keith Payne
Technical Marketing Solutions
Florida, United States
 
 
To
13/10/2005 05:10:23
Glenwell Andal
Pdc Software Philippines
Quezon, Philippines
General information
Forum:
ASP.NET
Category:
ADO.NET
Environment versions
Environment:
VB.NET 1.1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Jet/Access Engine
Miscellaneous
Thread ID:
01058178
Message ID:
01058635
Views:
6
>Actually we do that way wherein we assume the size co datatype base on how they create. But the problem is we have some datatype with different size. Example sometimes the default value of nVarChar = 50, but there was a case like in "comment" we make it more than to that value. Regarding GetSchemaTable, im not familiar to used that. Can u give me some example of using that in datagrid wherein we can update, insert, and delete direct to the grid..
>
>If you have some tips of making parameters in datagrid except using commandbuilder, (we have a complex datatable) please send it to me. It will help me a lot. Thank you. Good day

GetSchemaTable is not a part of the DataGrid. It is a method of the OleDbDataReader that returns a new DataTable containing the names, data types, lengths, etc.. of the columns in the base table. If you haven't used it before, I suggest reading over the documentation on it. The samples are clear and easy to integrate into your own code.

In VS2003 help, the link is
ms-help://MS.VSCC.2003/MS.MSDNQTR.2005JAN.1033/cpref/html/frlrfSystemDataOleDbOleDbDataReaderClassGetSchemaTableTopic.htm
Concerning the command builder, the only tip that will make any sense at this point is to start with a simple one-table dataset and work through the sample code in the help files. Once the relationship between DataAdapters, OleDbCommands, DataTables, and DataGrids become clear to you, the rest will fall into place.
Previous
Reply
Map
View

Click here to load this message in the networking platform