Are you able to download / install / operate the AVManager software on these two PC's that are acting up?

So your checkbox works up to the point of when you are looking at the data in your datagrid and you manually sort the data, you lose your check mark that was placed in the check box? If that is the case, then you most likely will need to remove the functionality of your data grid (cant be manually sorted or resized etc.etc) and write your own sorting function that scans the check box's to see if they have a check first before you allow your datagrid to resort.

try this: Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click If TextBox1.Text = "" Or TextBox2.Text = "" Or TextBox3.Text = "" Then MsgBox("You Must put something in here first") Exit Sub End If continue on with your program stuff here........ End Sub

Looks interesting! I will have to play with this!

Lets see if I can think this through ... We point / read a dataset (call it dsOne) to a table from your SQL? server. We point / read a second dataset (call it dsTwo) to another table from your SQL server. We point a dataview (call it dvOne) to dsOne We do a sort on dvOne on PLSupplierAccountID We pull the first entry for PLSupplierAccountID in dvOne We point a second dataview (call it dvTwo) to dsTwo We use the entry from dv.One SupplierAccountID to do a dvtwo.Find If we get a match we combine the row entry from dvOne with dvTwo in a DataGrid Once you get all the matches combined in the datagrid, you can make your changes using your form. These changes will be stored on the form until you "submit" them back to your SQL server using a update query. This sound about right to you?

I failed to mention two wonderful classes that you can use to do what you want quickly, one is dataset and the other is dataview and they should not be overlooked because they can help you out. Public Class DataView Inherits System.ComponentModel.MarshalByValueComponent Member of: System.Data Summary: Represents a databindable, customized view of a System.Data.DataTable for sorting, filtering, searching, editing, and navigation. Public Class DataSet Inherits System.ComponentModel.MarshalByValueComponent Member of: System.Data Summary: Represents an in-memory cache of data.

Lets say that you have a form called Form1 and you want to check to see if it is open first so you dont have multiple instances of the form running around on your end user's desktop. First we make a Class statement and define your Form1 as FormNumberOne with events: Dim WithEvents FormNumberOne As Form = Form1 Then under an action like a menu item click or something we drop this if statement: If FormNumberOne Is Nothing OrElse FormNumberOne.IsDisposed Then Dim FormNumberOne As New Form FormNumberOne = Form1 FormNumberOne.Show() ElseIf FormNumberOne.Visible = False Then FormNumberOne.Show() Else MsgBox("You already have the form number one open") End If Give this a try, should be what you are looking for...

so you need to drop the combined dataset into an array, then loop through the array and assign each line to a pre-built internal data table?

Just a thought, but maybe you can set up a text changed event and count how long your text string is. Once the text hits a length = X then run a REGEX to replace the next char with a back space.

Try changing the wild card * in your LIKE statement to a % see if that works. IE: Like '100*')); changes to Like '100%'));

I had problems with adding a resource once for an HTML file. I ended up booting it to the curb and writing my own HTML structure internal. Below is a quick HTML entry you can stream towards your WebBrowser object and it will work just fine. It builds a basic web page with a table and has simple Java script support VIA a text box entry. I also disabled any right click to view source function with the entry in the body section oncontextmenu=return false; Give it a try you may find this easier to deal with. ========================================================================= Dim tik As String = """" TextBox.Text = "Add some internal Java Script stuff here if you want for a pop up window or what not" WebBrowser1.DocumentText = "<%@ Page Language=" & tik & "VB" & tik & "%>" & ControlChars.NewLine & "<html><head><meta http-equiv=" & tik & "content-type" & tik & " content=" & tik & "text/html" & tik & ">" & ControlChars.NewLine & "" & _ "<script language=" & tik & "JavaScript" & tik & ">" & ControlChars.NewLine & "" & _ "<!-- hide" & ControlChars.NewLine & "" & _ "" & TextBox.Text & "" & _ "// -->" & ControlChars.NewLine & "" & _ "</script>" & ControlChars.NewLine & "" & _ "</head>" & ControlChars.NewLine & "<body topmargin=" & tik & "0" & tik & " marginwidth=" & tik & "0" & tik & " marginheight=" & tik & "0" & tik & " bgcolor=" & tik & "#FFFFFF" & tik & " text=" & tik & "#000000" & tik & " link=" & tik & "#000000" & tik & " vlink=" & tik & "#000000" & tik & " alink=" & tik & "#000000" & tik & " oncontextmenu=" & tik & "return false;" & tik & ">" & _ "<font size=" & tik & "2" & tik & " face=" & tik & "Arial, Helvetica, sans-serif" & tik & " color=" & tik & "#000000" & tik & "><table border=" & tik & "0" & tik & " width=" & tik & "610" & tik & " cellpadding=" & tik & "0" & tik & " cellspacing=" & tik & "0" & tik & " bgcolor=" & tik & "#FFFFFF" & tik & ">" & _ "<tr><td><font size=" & tik & "2" & tik & ">•<a href=" & tik & " http://www.codeproject.com" & t

You will need to run a REGEX session on your string before you send it to your XMLWriter. Search GOOGLE for xml unsafe characters and ASCII code to see what you should turn those funny characters into. Since you are making your own server / client application you can set your own REGEX standards for conversion of characters. IE: REGEX finds a "&" in your input string. You replace "&" with a @045; and send that to your XMLWriter.