So you've "bound" the datasource to the text box. I've never done that. I've always done all my ado updates manually. I suggest you look into doing all the ADO work on the backend, and manually update your text boxes. I've never had any problems doing that. Binding isn't very good practice. At 04:48 PM 1/11/2001 +0100, Vladimir Novakovic wrote: > > Are you binding the datasource to the text box? Or using are you using > ado > > to manually update it? >Well I tried to bind the datasource to the text box. > >I used as model MSDN advice to ADO. It look like: > >To create a simple front-end database application > * Draw an ADO Data Control on a form. (The icon's ToolTip is "ADODC.") > If the control is not available in the Toolbox, press CTRL+T to display > the Components dialog box. In the Components dialog, click Microsoft ADO > Data Control. > * On the Toolbox, click the ADO Data Control to select it. Then press > F4 to display the Properties window. > * In the Properties window, click Use ODBC Data Source Name to display > the Use ODBC Data Source Name dialog box. > * Choose sample-MySQL > * In the Autentication put username and password > * In the RecordSource choose command type: 8 - adCmdUnknown > * For Command Text (SQL) put: SELECT * FROM tblsites WHERE fldSITEId = > 12 (fldSITEId is number format in MySQL). > * Create Textbox > * For DataSource choose: Adodc1 > * For DataField choose: fldSITEName (fldSITEName is text format field > in MySQL). > * Run program (F5) > Maybe this will help you to understand what did I do. > > > Regards, > Vladimir ------------------------------------- Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] "Always bear in mind that your own resolution to success is more important than any other one thing." - Abraham Lincoln --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
