Search Results - CodeGuru Forums
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com

Search:

Type: Posts; User: happyme

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    7
    Views
    2,056

    Re: vb.net access SQL joins

    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
  2. Link to documentation for VB.NET Database Explorer Query Designer

    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
  3. Replies
    7
    Views
    2,056

    Re: vb.net access SQL joins

    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? ...
  4. Replies
    7
    Views
    2,056

    Re: vb.net access SQL joins

    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...
  5. Replies
    7
    Views
    2,056

    [RESOLVED] vb.net access SQL joins

    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...
  6. Replies
    3
    Views
    2,405

    Filter datatable using an array of values?

    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...
  7. Replies
    27
    Views
    3,168

    Good Programming practice- using goto

    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...
  8. Replies
    2
    Views
    1,616

    ToString format causes InvalidCastException

    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...
  9. Re: Datatable - creating new columns ignores datatype?

    Thank you so much, problem solved
  10. [RESOLVED] Datatable - creating new columns ignores datatype?

    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")...
  11. Replies
    2
    Views
    5,108

    Re: csv to datatable, vb.net 3.5

    solved, using streamreader and Split:



    Public Function Read_CSV(ByVal FileName As String, ByVal FilePath As String) As DataTable
    '----------------------------------------------------
    ...
  12. Replies
    1
    Views
    571

    text boxes reverting to pre edit values?

    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...
  13. Replies
    2
    Views
    5,108

    [RESOLVED] csv to datatable, vb.net 3.5

    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...
  14. Replies
    2
    Views
    586

    Regex code not working

    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...
  15. Replies
    1
    Views
    491

    Re: Escape from Printing

    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
  16. Replies
    1
    Views
    491

    Escape from Printing

    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...
  17. Re: how passing the data from one datagrid to another ????? help !!!

    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...
  18. Thread: Print Grid

    by happyme
    Replies
    1
    Views
    617

    Re: Print Grid

    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...
  19. Replies
    5
    Views
    2,648

    Re: problem copying columns

    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?
  20. Replies
    5
    Views
    2,648

    problem copying columns

    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...
  21. Replies
    7
    Views
    793

    Re: Difficulty Printing

    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...
  22. Replies
    5
    Views
    759

    Re: format text for printing

    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...
  23. Replies
    5
    Views
    759

    format text for printing

    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....
  24. Replies
    2
    Views
    3,259

    Re: Problems with PrintDocument

    Thank you very much for your time.

    this bit:



    Imports System.Drawing.Printing
    Imports System.IO
  25. Replies
    2
    Views
    3,259

    Problems with PrintDocument

    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 :
Results 1 to 25 of 28
Page 1 of 2 1 2


Azure Activities Information Page

Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center