Search:

OK fixed it:

SELECT * FROM
(table1 LEFT OUTER JOIN (SELECT * FROM table2 WHERE (colb = 8)) xx
ON
table1.cola = xx.cola)

Thanks for the tip VictorN, I didn't know you could use IIF in access

I'm having some trouble with VB.NET Database Explorer Query Designer and wondered if any documentation exists on this? I've googled and found nothing.

Any pointers on where to look?

ta

H

I need to get a set of rows with null values if the join conditions aren't met, which is why I've selected a left outer join.

in respoinse to VictorN's question,

Is it a xx.colb or xx.cola? ...

If I use an outer join
'on table1.cola = xx.cola AND
xx.colb = 8'

then I get a row for every row in table1 that satisfies the where clause. if there are rows where table2.colb = 8 I get those...

Hi All,

I am using VB.NET 2010 Express to query an access mdb database.

I need to join a table like this:

SELECT * FROM
table1 LEFT OUTER JOIN table2 xx ON
table1.cola = xx.cola AND...

I have a datatable called dt which includes a column called type
I have a string array called typestringarray with about 15 members

I want to create a new datatable from the rows where type is a...

OK, I know using GOTO is ugly old programming, but what is a better solution?

I give my user an OpenFileDialog and allow them to choose a file.
If I don't like the file they have chosen I give...

I am using .ToString("#,##0.00") to format a number.
I'm sure I have used this before but today it doesn't work.

I want to format a System.Double value from the datatable like this 12345.6789...

Thank you so much, problem solved

I have a datatable which has a number of rows containing data

Then I need to add some empty datacolumns which I do like this:



Dim OT_Hours As New DataColumn("OT_Hours")...

solved, using streamreader and Split:



Public Function Read_CSV(ByVal FileName As String, ByVal FilePath As String) As DataTable
'----------------------------------------------------
...

I have written some code to get the data from a number of text boxes all named in the style txb_[column name]

I want to write this data to a datatable.

The text boxes were initially filled...

I want to load a csv file (A comma delimited text file) into a datatable. I found the OdbcDataAdapter Class which looks perfect, but it says it is supported only in version 1.1 of the .NET...

Hi,

I have written a short piece of code to validate a UK NI number.

The format is 2 upper case letters, followed by 6 digits followed by A,B, C or D

eg AB123456A is OK

This code does...

I've found a work around solution:

I disable the print button until a successful print preview (where everything fits of the page) has been completed

I'm printing a datatable and once the user has pressed the print button, the QueryPageSettings event handler checks the width of the document and adjusts the paper to landscape if needed.

That bit...

Assuming your datagrids displays the contents of datatable1 and datatable2, could you use:

datatable2.ImportRow(datatable1.Rows(i))


where i the the selected row in the datagrid

then...

have a look at this excellent post by aniskhan:

http://www.codeguru.com/forum/showthread.php?t=405863

he sets out how to print a data table. You can use loops to print pages in blocks of 5...

Thank you aniskhan, your code creates the correct column headings for me, but no data. Do I need to add the data row by row too?

I've got a couple of listboxes which the user can move items from one to the other. When they're done moving the items, which are column names from a datatable, I want to show only the columns which...

I would look for a low tech solution: print a line down the edges of your page with a known margin, then measure the actual location with a ruler, and compensate accordingly.

Obviously this...

Thank you aniskhan for coming to my aid again. Unfortunately I've falled at the first hurdle as I don't have the System.Data.Odbc namespace which I suspect I need. I'm using .net version 1.0.

I...

I'm planning to print the contents of a csv text file

The data is in a number of rows and columns and I've put the whole lot into a 2 dimensional array, and found out which are the widest columns....

Thank you very much for your time.

this bit:



Imports System.Drawing.Printing
Imports System.IO

I'm trying to print a few lines of text using PrintDocument

I'm using VB.NET version 1

the following line:

Dim prn As New PrintDocument

causes this error :