>When I check the lesson listView the lesson is not there. Is the listview control bound? If it's not then it won't automatically pick up the changes in the db. >How do I find out if the lesson is adding to the database? One way is in VS, in your Data Sources window, right click the table name and click "Preview Data".

Couple of solutions: 1. Use two different connections settings, ex: devConnectionString and ProdConnectionString 2. Make a form that allows user to input settings such as db server name etc and save those settings.

-10 is a int not a string

Just handle the mouse click event and have a counter var in your class, increment it each time the click event happens and call the drawline method, in the drawline method check the counter, if it's the amount you want (2 in your case) reset it back to 0 and return true.

I use VS 2005 and this works: Properties.Settings.Default["name"]

To add, there is a vb.net example that gets installed with the .net connector, it is in C:\Program Files\MySQL\MySQL Connector Net 5.1.6\Samples\Table Editor\vb You can use that as a guide.

No they don't. You would have to run your own compression method on the byte stream before stored into the db and reverse for retrieving them.

It def. seems like your conn string is badly formed. Try a simple app first. Might have luck using this tutorial also: www.vbmysql.com[^]

OK, So how do I have the first item selected by default? I have searched on the workaround since the dgvcmb doesn't have a selectedindex property but haven't found anything I have been able to use or haven't tried. Thanks

I haven't done anything more than what I described. I used camtasia to record the construction of a simple project from scratch. I did the same as last post, datagrid view on form, made a column, added items to column, added column to dgv. Here is the shockwave video from camtasia: http://www.matcmp.ncc.edu/~steve/vb/comboboxproblem/comboboxproblem.html[^]

I think you're misunderstanding my problem. It's not that the data isn't showing up. It's the fact that I have to click the column multiple times in order for the data to show up. My code to initialize the column is the same as you've posted. I made a separate demo app to show what I mean. I put a datagridview on an empty form and in the form's load event I have this code: Dim nameComboBoxColumn As New DataGridViewComboBoxColumn With nameComboBoxColumn .HeaderText = "names" .Items.Add("john doe") .Items.Add("jane doe") .DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing End With DataGridView1.Columns.Add(nameComboBoxColumn) When the app loads the data is not shown in the column until I click the column.

I do have two binding sources. One binding source for orders and one for prices. I used a combobox so user can select a price from available prices but I'm open to suggestions for other controls to use.

Hi, I'm using vb 2005. I'm making a test project to try some things out but having problem that I have a DataGridViewComboBoxColumn binded to a child table and then adding that column to a DataGridView. The column doesn't show the data from the child table until I tripple click the column. The data is the correct data though. Details: I have three tables that are related. Parent table called Customers table with cust_id as PK Orders table with order_id and foreign key being cust_id Prices table with FK of order_id. This is the code I used to bind the DataGridViewComboBoxColumn Dim priceComboBoxColumn As New DataGridViewComboBoxColumn With priceComboBoxColumn .HeaderText = "price" .DataSource = priceBindingsource .DisplayMember = "price" .DataPropertyName = "price" .ValueMember = "price" .DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing .Visible = True ' .DisplayStyle = DataGridViewComboBoxDisplayStyle.ComboBox End With dgOrders.Columns.Add(priceComboBoxColumn) I have two pictures here to show what I mean http://www.matcmp.ncc.edu/~steve/vb/ Any help would be greatly appreciated. Thanks