There is one thing that we cannot understand in your Situation, is because we dont see your code, and that means we dotn know what you are talking about, if you can show us your code it would be better Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za

I agree :-D "The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

lvData.SelectedItems(0).Index Never underestimate the power of human stupidity RAH

>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".

You might have Google it before you post it. Anyway here's something that you can use for your purpose. ' Validate a US ZIP code ' Example: ' MessageBox.Show(IsValidUsZip("12345")) ' => True ' MessageBox.Show(IsValidUsZip("12345-1234")) ' => True ' MessageBox.Show(IsValidUsZip("12345-12345")) ' => False Function IsValidUsZip(ByVal zip As String) As Boolean Return System.Text.RegularExpressions.Regex.IsMatch(zip, _ "^(\d{5}-\d{4})|(\d{5})$") End Function - Stop thinking in terms of limitations and start thinking in terms of possibilities -

You're using an Access database as the datastore, correct? In your project, under the Solution Explorer, you should find your .MDB file somewhere. Click on it and, in the Properties window, you should find an option called "Copy to Output Directory". If this is set to "Copy always", Visual Studio is copying your test database to the Debug or Release folder every time you run your app. This copy is what your code is modifying. The next time you to run your app, the original database file you created is copied to the Debug or Release folder again, overwriting anny changes your code made during the previous run. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

AAGTHosting wrote: cboSelectTeacher.SelectedItem = selection.SubItems(4).Text ' this si the line of code to set a pre selected item in the combo box. By setting the Text property of the ComboBox, you're not actually selecting anything. All you're doing is putting text in a TextBox control. To select the item, you have to call the FindString method of the ComboBox to find the text of the item you're looking for. This will return the index of the first item that matches that string. It'll return -1 if the item is not found. Then you can set the SelectedIndex property of the ComboBox to select the item. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

I generally do the opposite of what Ashish recommends. Get each table as data discreet entity (1 table per dataset) I use 2 types of data, static for lookup lists etc and transactional. The static tables I populate the first time they are used and remain in memory. These are in a class called MasterTables eg 'Local var to hold the table Private mvApp As DataTable 'Public property to expose the table Public Property App() As DataTable Get If mvApp Is Nothing Then mvApp = LoadApp() End If Return mvApp End Get Set(ByVal Value As DataTable) 'this allows the system to reload the table when the value is nothing mvApp = Value End Set End Property Private Function LoadApp() As DataTable ' Load the app table from the database Dim oClass As New clsApp Return oClass.GetRecord(cAllRecords) End Function Note if you use a dataview to filter a table (when populating a list) then this can be reflected in the base table unless you copy the table.

Maybe it needs AcceptChanges method for that table. Sourie

I did update the schema of the dataset. In fact, when I tried to change the dataType in the designer it was already text.

I looked in the wizard and I can't find a place to select a dataType. One of my table columns is a UDT named time that I created from dateTime. I did not create an assembly. Also the dateTime datatype that I pass in is a dateTime that adds a timespan to change the startTime. Is it possible that the time dataType could cause this? I also increment startTime with timeSpan which is a dateTime dataType in VB.NET. Could this cause the problem?

you can bind multiple combo boxes to the same dataTable if each has its own binding source

Which grid control are you using? DataGridView (VS2005 and above) or the DataGrid (VS2002 and 2003)?? A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

OK. Again, on what line does the error occur?? A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

how do I format a phone number on output for display in a dataGrid? Lets say I want it like this. (909)554-2574

check for typo's when setting the properties, this will cause the combo to display system.data.datarow

Work with the date object. Get the date value from SQL as a datetime field and display less_time.toshorttimestring. If you are not happy with the format then fiddle with the format, not the data.

What do you mean by "select a ... selected value"?? Are you talking about a ListView setup for multi-select and you want to iterate over the items selected by the user? A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

Well, the code that creates this new table, and adds rows to it, looks OK. The problem may be that the dtLessTime.Rows collection may be empty, or some other problem with it. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

here is my code. Dim dt As New DataTable() Dim dr As Data.DataRow For Each row As DataRow In dtStud.Rows dr = dt.NewRow() dr(0) = row("stud_name") dr(1) = row("stud_par_name") dr(2) = row("stud_id") ' get student instruments Call studentInstruments(Convert.ToInt32(row("stud\_id"))) ' create counter Dim intCount As Integer = 1 For Each row2 As DataRow In dtStudInst.Rows If intCount = 1 Then strInst = Convert.ToString(row2("less\_instrument")) Else strInst += ", " & Convert.ToString(row2("less\_instrument")) End If Next dr(3) = row("stud\_phone") dr(4) = row("stud\_cell") dr(5) = strInst dt.Rows.Add(dr) Next