Type: Posts; User: happyme
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
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?
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
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, 10: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, 09: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, 07: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, 09:42 AM
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.
December 8th, 2006, 06:30 AM
Assuming your datagrids displays the contents of datatable1 and datatable2, could you use:
where i the the selected row in the datagrid
December 8th, 2006, 06:08 AM
have a look at this excellent post by aniskhan:
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.
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.
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.
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