Search:

Type: Posts; User: kmoorman

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Re: Change Field Names in SQL Statement Using VB.NET

    The_Grudge,

    If that Select statement with alias needs to follow oracle conventions then an alias with spaces will require double-quotes around it.

    Kerry Moorman
  2. Replies
    2
    Views
    527

    Re: [2008] Multiple Combos with one list

    Psychlotron,

    One way to make the comboboxes independent of each other is to assign each combobox a new binding context. For example:

    ComboBox1.BindingContext = New BindingContext

    Do that for...
  3. Replies
    1
    Views
    4,901

    Re: convert jpg to bmp in memory

    etac,

    You should be able to save the jpg image to a memory stream as a bmp, and then load it from the memory stream:



    Dim myJpgImage As Image = Image.FromFile("Abstract3.jpg")
    ...
  4. Re: Can't remove substring from string with Remove() ??

    patricio2626,

    If you read the documentation for Remove you will see that it returns a new string with the characters removed. So:



    endFileName = endFileName.Remove(slashIndex, 1)


    Kerry...
  5. Replies
    1
    Views
    439

    Re: [2008] For Each Loop - Couple Questions

    Max,

    From your message, you know the folder. So you can use Directory.GetFiles and supply a pattern to match the files in the folder.

    You will get back an array containing the file names:


    ...
  6. Re: ComboBox SelectedItem returns System.Data.DataRowView (WIndows Form VB 2005)

    sweizone,

    Each item in a combobox bound to a dt.DefaultView is of type DataRowView, so that is exactly what you should expect to get back from SeletedItem.

    What is it that you were hoping to...
  7. Replies
    3
    Views
    688

    Re: String matching with filenames?

    patricio2626,

    I don't think you will need a DirectoryInfo object.

    Just supply the complete path to your folder as the first argument to Directory.GetFiles, and the filename pattern as the...
  8. Replies
    3
    Views
    688

    Re: String matching with filenames?

    patricio2626,

    You could use Directory.GetFiles to retrieve all the files in a particular folder that match a pattern. For example:



    Dim myFiles As String ()
    Dim myPattern As String = year +...
  9. Replies
    6
    Views
    624

    Re: Visual 2005 Framework v2

    nabbster,

    If framework version 1.1 is definitely available on the target machine, re-writing the app using VB2003 would be much easier than re-writing in VB6.

    Kerry Moorman
  10. Replies
    6
    Views
    624

    Re: Visual 2005 Framework v2

    nabbster,

    What framework version is available on the targe machine?

    Kerry Moorman
  11. Re: [URGENT] OledbCommand Parameters Not Working - HELP!

    Wesley008,

    You are never executing the Insert command.

    After you have added all the parameters and before you close the connection:

    Command.ExecuteNonQuery()

    Kerry Moorman
  12. Re: [2005] Unable to copy directory

    MrNorth,

    Does this do what you need?



    Dim myPath As String = Application.StartupPath

    myPath = Directory.GetParent(myPath).FullName
    myPath =...
  13. Replies
    8
    Views
    766

    Re: [2008] Problem with path for project...

    BCyber,

    Your only options are to go back to the lab computer and retrieve the form or create it again from scratch.

    In the future you need to be very careful to save all files in the project as...
  14. Re: My solution won't target the 2.0 framework

    FunkyDexter,

    Does this article help you at all?

    http://www.codeproject.com/KB/dotnet/targetnet2fromvs2008.aspx

    Kerry Moorman
  15. Re: [2008] The best way to allow controls to interact with each other

    DeanMc,

    It is not clear to me what you mean when you say that a "control preforms event X" and "triggers group events for certain controls".

    Are you just looking for a way to have one handler...
  16. Re: [2008] Running a method 5seconds after last keystroke?

    ashlewis,

    You might want to describe what you are trying to do after each keystroke. You might get suggestions on other ways to accomplish the task.

    Kerry Moorman
  17. Replies
    7
    Views
    754

    Re: Multiple User help....

    Stogie03,

    Well, it says in all your posts: "VB version: Visual Studio 2008-Professional", which is .Net, not VBA.

    You might get more appropriate responses in a VBA newsgroup.

    Kerry Moorman
  18. Replies
    7
    Views
    754

    Re: Multiple User help....

    Stogie03,

    You probably already know this, but ADO.Net represents the data access classes used natively in .Net.

    The ADO you are using is the "classic" version for pre-.Net solutions.

    Kerry...
  19. Re: [2005] how to read items in ArrayList and show it in DataGridView..

    sfaiz,

    When you are processing the data in your datareader you are placing values into an object you are referencing with the Me keyword and then adding that object to the arraylist:



    ...
  20. Re: [2005] how to read items in ArrayList and show it in DataGridView..

    sfaiz,

    One option would be to use a criteria similar to this:

    where OpeningDateTime >= #9/13/2008# And OpeningDateTime < #9/14/2008#

    This should select all rows with a date portion of...
  21. Re: [2005] how to read items in ArrayList and show it in DataGridView..

    sfaiz,

    You should supply your criteria values, AuctionStatus and OpeningDateTime, using parameters instead of concatenating them into an sql string.

    Also, if the database is keeping the...
  22. Re: [2005] how to read items in ArrayList and show it in DataGridView..

    sfaiz,

    One option would be to bind the arraylist to the datagridview:

    ReportDGV.DataSource = resultList

    Kerry Moorman
  23. Re: MS Access Database - How to Prevent File Locking

    Kal2219,

    Normally, opening a connection to an Access database does not lock the database, since you would usually want your app to be multi-user.

    I don't see any settings in your connection...
  24. Re: [2005] Help with polymorphism of UserControl

    dbassettt74,

    You could place the common functionality in an interface and have both controls implement the interface.

    Kerry Moorman
  25. Re: [2005] Multiple paramaters with one control

    mrmojorisin,

    Your question is not clear to me.

    But if you have two parameter placeholders, the "?" characters, then you will need to supply two parameters for the query, even if both...
  26. Replies
    4
    Views
    787

    Re: [2005] Reading the text on an image?

    noahssite,

    You are describing OCR software, optical character recognition.

    You might Google for that term. I think there may be one or more open source ocr projects that you could look at.
    ...
  27. Re: What the hell is ioibmurhynrxkw0zxkyrvfn0boyyufow?!!!

    FunkyDexter,

    I don't have a solution to your particular problem.

    But I will point out that with VS2008 you can target a particular framework. It sounds like your app could target the 20.0...
  28. Replies
    10
    Views
    1,024

    Re: [02/03] Help changing my coding.

    Aspnot,

    All the newer versions of SQL Server cache adhoc queries right along side stored procedures. Its not that stored procedures got slower, its that adhoc queries got faster.

    Here are a...
  29. Replies
    10
    Views
    1,024

    Re: [02/03] Help changing my coding.

    techgnome,

    But my comment about performance pertained to stored procedures, not parameters. Here is my original comment:

    "Although there are good reasons to use stored procedures, performance...
  30. Replies
    10
    Views
    1,024

    Re: [02/03] Help changing my coding.

    techgnome,

    Assuming you meant stored procedures, not parameters, why do you think that there is a performance reason for using them?

    Kerry Moorman
  31. Replies
    10
    Views
    1,024

    Re: [02/03] Help changing my coding.

    Aspnot,

    Although there are good reasons to use stored procedures, performance in SQL Server is not one of them.

    Kerry Moorman
  32. Re: finding maximum value using sql....

    si_the_geek,

    Very nice, and definitely the way to go.

    Kerry Moorman
  33. Re: finding maximum value using sql....

    sfaiz,

    Probably the easiest way would be to query the database again, selecting userid where bid equals the max bid you previously retrieved and auction id equals the appropriate value.

    Kerry...
  34. Re: finding maximum value using sql....

    sfaiz,

    Seems like it should be something like:

    SELECT MAX(BidAmount) from Bid Where AuctionID='" & AucID & "'

    Of course, you should use a parameter for AuctionID instead of building the sql...
  35. Thread: [2008] AddNew

    by kmoorman
    Replies
    6
    Views
    766

    Re: [2008] AddNew

    penno90,

    If customerID is an autonumber or identity column then it is not possible for the datatable to generate and display the "actual ID that will be assigned in the database", since that value...
  36. Replies
    4
    Views
    563

    Re: array help

    RockStarEnergy,

    What does your documentation say about the argument to GetUpperBound?

    Kerry Moorman
  37. Replies
    5
    Views
    573

    Re: [2008] Date format issues

    Nitesh,

    Try:



    DateTime.TryParseExact(strETD, "yyyy/MM/dd hh:mm:ss tt", Nothing, Globalization.DateTimeStyles.None, ETD)


    Kerry Moorman
  38. Replies
    3
    Views
    584

    Re: Display records from a table

    afshin_tt,

    You could wrap those assignment statements in an If statement that checks the row count:

    If dsMon.Tables(0).Rows.Count > 0 Then

    Kerry Moorman
  39. Re: [2008] complex sort function (lambda)

    .paul.,

    Untested, but maybe something like:



    If (x.number = y.number, x.display.CompareTo(y.display), x.number.CompareTo(y.number))


    Kerry Moorman
  40. Replies
    14
    Views
    1,817

    Re: [2008] MDIparent tabbing help

    TetovaBoy,

    What do you mean, "so if some one can help"? Two different responses have given you links to examples that do exactly what you say you want to do.

    If you are too much of a beginner...
Results 1 to 40 of 110
Page 1 of 3 1 2 3



Click Here to Expand Forum to Full Width