Troy_Dot_Net

Attached is a stripped down version of the sraclc.mdb (Employees table only). Note that the mdb and ZIP file are both named sraclc_employees--this will need to be changed in the vb.net code. Thanks for your assistance and ideas. :) Troy sraclc_employees.zip

>Can you zip up your project and post it so we can help out? Can do! DataBindingTest.zip

>Make a new text file on your desktop. >Rename it to "WhatEverYouLike.udl" >Double click it and you will get a wizard helping you to connect to your database. I tried that trick but when I double-clicked the desktop file, an error box popped up (labeled "Microsoft Data Link Error") with the following error message: "C:\Documents and Settings\User\Desktop\test.udl : File cannot be opened. Ensure it is a valid Data Link file." Do I need to configure something to enable that trick to work for me? I'm using WinXP Pro if that matters.

>One record? What the hell is the point of the database? One example would be to have a data table ("Counter") with one record of one column to track site visits (if you don't have a web page counter). In any case, he said one record in a data table, not one record in the entire database.

>Not sure if this will help, but try a call to DataRow.EndEdit(). My hunch is that editing in the DataGrid will call BeginEdit() behind the scenes. Clicking on the grid may call EndEdit() behind the scenes. Calling it explicitly may solve this for you. Thanks for your idea. In what method/event do you suggest I put the call to EndEdit()? It seems strange to me that editing the textbox and then clicking on the listbox updates the datagrid but not the listbox, whereas editing the textbox and then clicking on the datagrid updates BOTH the datagrid and the listbox. Troy

Very Basic Data Binding Issue (ListBox updating) Hello All, I went through a video tutorial (via http://www.franklins.net/videos.asp) on basic databinding but am not able to get the same results and it's driving me nuts. I've used databinding before but have no clue about this very simple scenario. Here's the scenario: I created a new vb.net Windows App project in VS.Net 2003 Pro. I then dragged a database table (from Server Explorer) to the form to create a connection and adapter, then generated a dataset (dsEmployees). I then added a ListBox, 2 TextBoxes and a DataGrid to the form. I bound the components to the dataset (listbox & one textbox to emp_lname, other textbox to emp_address or whatever, and datagrid to Employees table). When I edit the emp_lname field in the datagrid and move off the field (i.e. select another row or field), the ListBox and TextBox correctly display the change. Also, when I make a change to the emp_lname field in the TextBox and then click on the *datagrid*, all 3 components correctly display the change. Here's the problem: when I edit the emp_lname field via the textbox and click on the ListBox, the datagrid correctly displays the new value (from the just-edited TextBox) but the last name in the ListBox is not updated. My Question: why is the ListBox correctly updated (after a change has been made to the textbox) *only* when I click on the datagrid and not when I click on the ListBox. In other words, what event is getting triggered when the datagrid is selected and not triggered when the ListBox is selected? Thanks for your expertise on this very simple problem. Troy