Ofcourse it is. It's like a Paint routine on a Form, Panel, etc. Therefore it is not a good idea to put a messagebox in there, just do your coloring.

1. True. 2. True. 3. Not True.

That's because you got a bounded datagridview. If you want colors, you'll need to put it in a CellFormatting Sub, like so:

Public Sub DataGridView1_CellFormatting(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellFormattingEventArgs) Handles DataGridView1.CellFormatting

'...do your coloring thing

End Sub

I could say 'That is horrible', but I won't. Ooops, just did it.

Use the REPLACE function. Check here.

Since your DataSet1 contains 2 Tables, you'll have to set the table you'll want to show. So use:

DataGridView1.DataSource = DataSet1.Tables("TableName")

You could try this:

select * from Table
where (xfield like '[,/%:]%' OR xfield like '_[,/%:]%' OR xfield like '__[,/%:]%')

Try this:

select * from FireArmsTD_View
where FrireArms_date between to_date('&DateFrom','mm-dd-yyyy') and to_date('&DateTo','mm-dd-yyyy')

Btw, is better to use the 'Database Board' for these kind of questions.

The combobox only handles a single column of displayed data. It has a displaymember and a valuemember property for binding to the datasource. But if you must display multicolumn in a combobox then you can concatenante your column values, like Eddy's shown in SQL. In VB this works like:

Dim FnLn As String
Dim drRow As DataRow
For Each drRow In DataSet.Rows 'or DataSet.Tables("Table1").Rows
FnLn = drRow("Lastname") & " , " & drRow("Firstname")
cb1.Items.Add(FnLn)
Next

- Create e.g. a DialogBox. - Open the DialogBox on clicking the Button. - Let the user put in data on the DialogBox. - Validate the data. - Add/Insert this data in the GridView. - Update/Sort the GridView.

The ComboBox is thoroughly explained [here].

Then probably your row contains no (actual) data. But why use a checkboxcolumn for this and not .SelectedItems ?

You mean like this?

Normally this should work, even if your datatable (rows) is empty. How did you work things out, exactly?

Alas, this won't work, since .DisplayMember and .ValueMember are string based which refer to a corresponding (table)column name of the bonded data.

Simia est simia et si aurea gestet insignia.

Yes, makes sense. Why don't you use an ArrayList in conjuction with your ComboBox and make the indexes correspond to one another? E.g.

ComboBox1.Items.Add("Drive Time")
ComboBox1.Items.Add("......")
...
Array1.Add("002302")
Array1.Add("......")
...

Public Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged

value = Array1.Item(ComboBox1.SelectedIndex).ToString

End Sub

Wrong forum. Try the 'General Database' forum.

What do you need exactly? What have done so far? Nobody is gonna do your homework for ya. Furthermore, a teacher that wants you to create something with VB 6.0? Tell this dinosaur he's a decade behind facts.

In a 20 step nutshell :wtf: : 1) Click 'File' -> 'Add' -> 'New Project'. 2) Goto 'Other Project Types' and 'Setup and Development'. 3) Choose 'Setup Project'. 4) In the 'Solution Explorer' rightclick on your setup project. 5) Choose 'Properties'. 6) Click 'Prerequisites...' button. 7) Choose your prerequisites (e.g. .NET Framework, Windows Installer). 8) Press 'OK', press 'Apply'. 9) Rightclick on 'Application Folder' in the left File System window. 10) Choose 'Add' -> 'Project Output' 11) When done, rightclick in the Right File System window. 12) Choose 'Add' and whatever you want to add to the application directory during installation. 13) Rightclick on 'Project output from ....' 14) Select 'Create shorcut to Primary output from ...' 15) Rightclick on 'Shorcut to Primary output from...' 16) Choose 'Rename' 17) Name it after your application. 18) Select it and drag it to the left to 'User's Program Menu'. 19) (Build solution) Build your setup project. 20) In the setup project directory you'll find the .exe and .msi file to install your application.