Search:
Type: Posts; User: happyme
Search:
Search took 0.01 seconds.
-
January 14th, 2013, 08:25 AM
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
-
January 14th, 2013, 08:06 AM
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
-
January 14th, 2013, 08:00 AM
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? ...
-
January 14th, 2013, 06:43 AM
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...
-
January 14th, 2013, 06:11 AM
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...
-
December 14th, 2010, 07:23 AM
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...
-
July 27th, 2010, 09:19 AM
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...
-
July 15th, 2010, 08:02 AM
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...
-
July 12th, 2010, 06:30 AM
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...
-
April 2nd, 2009, 08:42 AM
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...
-
December 8th, 2006, 10:41 AM
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
-
December 8th, 2006, 08:33 AM
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...
-
December 8th, 2006, 06:30 AM
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...
-
December 8th, 2006, 06:08 AM
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...
-
November 25th, 2006, 09:05 AM
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?
-
November 24th, 2006, 09:26 AM
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...
-
November 16th, 2006, 08:01 AM
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...
-
November 13th, 2006, 02:12 PM
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...
-
November 12th, 2006, 04:11 PM
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....
-
November 11th, 2006, 01:30 PM
Thank you very much for your time.
this bit:
Imports System.Drawing.Printing
Imports System.IO
-
November 11th, 2006, 08:59 AM
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 :
|
Click Here to Expand Forum to Full Width
|