If you want to add an item to a listview... If i understand your question right:-D

'Single Entry at the end of the list

Dim _ListViewItem AS ListviewItem = New ListViewItem(New String() {Column1Data, Column2Data, ...ColumnXData}, -1) _ListView.Items.Add(ListViewItem)

'Multible Entry
Dim _ListViewItems(X) as ListViewItem Dim _ListViewItem AS ListviewItem

' The loading loop
_ListViewItem = New ListViewItem(New String() {Column1Data, Column2Data, ...ColumnXData}, -1) _ListViewItems(_ListViewItems.Lengt-1) = ListViewItem
'Loop ends

_ListView.Items.AddRange(ListViewItems)

This is A easy why to add items to a listview...:) VB6 = :doh:

Do a select statement using this: SELECT IDENT_CURRENT('table_name') This will return the last inserted PK in the table or SELECT @@IDENTITY Try sql help on these two functions and see how they work exacly:-D

I wrote a very simple program that has a sort off similarity. I made custom controls that access background files that are changeable by another part of the program to more languages or correct spelling mistakes.

Control <----->Class <-------> File: XML/DB(Any type that u can use):confused:

In the Database the tables will look something like this

Language 1:Many Caption Many:1 Words(Default Language) :confused: X|

I linked the captions to the system settings file for faster and user diffraction settings for different users and machines. Hope it helps; Basic fast and relaible:-D

I am testing the connection string by opening it and then closing the connection which has been assigned the function of testing. The problem comes in when u open the connection and the server is not there. It stalls the whole system for 30 seconds (Default Time out).

Try
	_conn.ConnectionString = ReconfigConnString() 

I am looking for an idea where the system can test the connection AND do the other functions that needs to be complete before the form close. In multi threading the connection thread will over power the other threads and will cause one of two things. Deadlocks or either full system stalling until time out.:cool: System complete...bug free? I'll find a bug. :zzz:

I hope this is usefull.:-D

    Private Function Search(ByVal _Listbox As ListBox, ByVal SearchText As String)
        Dim i As Integer

Very simple, but it Works.... sometimes;P :zzz:

I have a scenario where the program needs to have a variable connection string for the SQL server. The string is combined a collection of: • ServerName • SqlDatabase Name • User Name • Password • Connection Timeout Value Every time the connection string change it needs to validate the string and other operations needs to run. The problem comes in when the connection string has incorrect information. I have tried multi threads as I want the users to continue working on other functions while the system test the connection, but if the connection string generate an error it overpower all the threads and stall the system in any case… Is there a better why and faster why to test the connection, with out letting the user/system wait for response SQL connection timeout? PS: Reducing the timeout doesn’t help as the network has at certain times slow response times. This all happens in RunTime... **************************************************************************** I am not english so leave my grammer and spelling alone... :Mad: :Cool: ****************************************************************************