Search:

Type: Posts; User: Philly0494

Page 1 of 13 1 2 3 4

Search: Search took 0.07 seconds.

  1. Replies
    2
    Views
    581

    VS 2010 Using MySqlDataReader

    I have crafted this simple query to return the data I need:
    SELECT * FROM EVENTS AS E1 INNER JOIN Events AS E2 ON E1.Source_Event = E2.Event_Id WHERE E1.PU_Id = 108 AND E1.TimeStamp > '1/1/2014'...
  2. Replies
    14
    Views
    3,212

    VS 2010 Re: MySqlDataReader Pool Size Limit Reached

    So Shaggy, all of my connection strings are identical, would it be okay to create one SQLConnection and modify the .getReader() function to use that SQLConnection each time and then close that...
  3. Replies
    14
    Views
    3,212

    VS 2010 Re: MySqlDataReader Pool Size Limit Reached

    Here is the function I am calling in a loop (just in case you are curious):

    Private Function getProductionInfo(varId As String, codeId As String, code As String) As List(Of String)
    Dim...
  4. Replies
    14
    Views
    3,212

    VS 2010 Re: MySqlDataReader Pool Size Limit Reached

    Just to add on, I am populating tables of data by calling functions in a loop and each iteration starts either 1 or 2 SqlConnections. I don't notice it slowing down but I am wondering if I port this...
  5. Replies
    14
    Views
    3,212

    VS 2010 Re: MySqlDataReader Pool Size Limit Reached

    Thank you very much, right now I am calling SqlConnection.ClearAllPools() before I attempt to make any connection to the database. It does not appear to slow down the program, is there any risk or...
  6. Replies
    14
    Views
    3,212

    VS 2010 MySqlDataReader Pool Size Limit Reached

    I am writing a program that requires me to run a lot of different SQL queries so I create a new MySqlDataReader object for each query I run and when I am finished with it I call the .Close() method...
  7. Re: [RESOLVED] HtmlElement InnerText is incomplete

    Thanks your method works great and it is really easy.
  8. Re: HtmlElement InnerText is incomplete

    I am going to plop it into an Excel file using Gembox along with some other information. I will not be reading the data as text at any point in the future so if there is a way to save a picture of...
  9. Re: HtmlElement InnerText is incomplete

    Thank you for replying. I think I resolved that issue by executing the code well after the page loads (which is fine for what I am doing) but I overlooked another problem with my method. I am left...
  10. [RESOLVED] HtmlElement InnerText is incomplete

    I am trying to collect information from the table below (which may change in size) that I have loaded in a WebBrowser control.

    http://i.imgur.com/GRQotxL.jpg

    I have tried the following code:
    ...
  11. Replies
    9
    Views
    1,271

    Re: Linking/Referencing Another Table

    I was out of my office for the day so I wasn't able to try it at that time. When I change the joins to LEFT then I still do not get results.
  12. Replies
    9
    Views
    1,271

    Re: Linking/Referencing Another Table

    Thats probably it, Reason_Level3 is often blank and sometimes Reason_Level2 is as well. so if I change the INNER to LEFT it should work?
  13. Replies
    9
    Views
    1,271

    Re: Linking/Referencing Another Table

    That seems like it would work but when I try this query I get zero rows returned:


    SELECT PU_Desc, Start_Time, T1.Event_Reason_Name,
    T2.Event_Reason_Name,T3.Event_Reason_Name,Duration
    FROM...
  14. Replies
    9
    Views
    1,271

    Linking/Referencing Another Table

    I have a SELECT query which works fine and it looks something like this:
    "SELECT PU_Desc, Start_Time, Reason_Level1,Reason_Level2,Reason_Level3, etc etc

    The problem is that the Reason_Level is...
  15. Re: how to calculate the difference of 2 days in the textbox?

    Dim ts As TimeSpan = DateTime.Parse("4/7/2014") - DateTime.Parse("4/5/2014")
    txtResult.Text = ts.Days.ToString()
  16. Replies
    1
    Views
    1,145

    VS 2010 Re: Connect to OLEDB database connection

    Hey guys I have an update, it turns out that in VB.NET that escape character \n was not recognized and it assigned a data source name of "ustcaXXX\nabi".

    I fixed this by changing the connection...
  17. Re: How to highlight a radiobutton after it has been reset to false in tab order sequ

    Have you tried modifying the TabIndex property of the controls on the form? The lowest TabIndex will be selected first. You can also call the CONTROLNAME.Focus() method to set focus to a control...
  18. Replies
    1
    Views
    1,145

    VS 2010 Connect to OLEDB database connection

    I am trying to pull data from a PivotTable in Excel but I would imagine the best way to do this would be to access the data source directly.

    In Excel, it appears that the connection string is:
    ...
  19. Re: NEED HELP! How Do I Get Hex Values To Show up in a TextBox??

    FF0E is hexadecimal but 7HTS is not a hexadecimal value
  20. Re: Users getting an error when starting my application

    The DLL you are using is a .NET wrap the original devIL.dll, which is a COM dll I believe. You need to have devIL.dll in the folder as well because devIL.NET.dll references it, I believe.
  21. Re: Help with a potential threat on my system.

    I don't think so in this case. Red Gate is a respected company and a widely used tool. Any software written in .NET is very easy to "reflect", even more so than Java. This is so that the...
  22. Re: Help with a potential threat on my system.

    If the original application is, in fact, a .NET application I recommend you use .NET Reflector from Red Gate. It will actually fully decompile the program if you want it to.
  23. Replies
    12
    Views
    1,332

    Re: Size and Size on disk problems.

    System restores and Recycle Bin reserve space that they haven't used yet. In addition files that are beginning their download reserve enough space on the disk so that the download can be completed...
  24. VS 2012 Re: [RESOLVED] Can't Open Batch File in VS 2012?

    Perhaps try "Dim executepath As String = Application.StartupPath + "\" + getfiles.bat""
  25. Replies
    4
    Views
    1,436

    VS 2010 Re: Block Websites

    Stopping applications from running is different than blocking websites. You have a few options here.

    You could create a covert application that closes all webBrowsers that open - using the code...
  26. Replies
    6
    Views
    10,373

    Re: vbCrLf not working?

    Yeah if you are viewing it from an email it may be reading it in html, in which case the carriage return will not render a new line.
  27. Replies
    5
    Views
    5,290

    VS 2010 Re: Adblock in VB.net?

    If it's a client-sided block then an IP or SOCKS proxy will not have any effect against your defense.

    You could always do things to detect the content of the page, just in case a HTTP proxy is...
  28. Replies
    19
    Views
    1,915

    VS 2008 Re: Condensing code

    Dim data As New List(Of String)
    For x = 1 To ultragrid.activerow.cells.length-1
    data.Add(ultragrid.activerow.cells(x).text)
    Next
  29. VS 2005 Re: Insufficient security permissions to set the system time

    Just right-click the executable and choose Run As and then supply the credentials of a non-admin account.
  30. VS 2005 Re: Variable Question: Use variable value to set another variable of that values name

    Look at his first post again, if it returns Pet he would actually want the text to read "Dog" since that is what corresponds with the variable name Pet.
  31. VS 2008 Re: project says built successfully but doesn't write to Release folder

    If you want to build to the Release folder you should be clicking Build->Build [project name]

    If you want to check where it built to just take a look at the Output window it should show something...
  32. Re: Want to allow my application to be run from a command line?

    Didn't you want the application to be invisible if it was executed via batch?
  33. Re: Want to allow my application to be run from a command line?

    If My.Application.CommandLineArgs.Count > 0 AndAlso My.Application.CommandLineArgs(0) = "-batch" Then
    btnStart.PerformClick()
    End If
    something along those lines on form load?
  34. Re: Want to allow my application to be run from a command line?

    You could modify your definition of "batch mode" to resemble something like this:

    start myApp.exe -hidden

    and then you could quite easily detect when the command line argument "-hidden" was...
  35. VS 2005 Re: Insufficient security permissions to set the system time

    I'm pretty sure he is asking how to replicate the error on Windows XP.

    Just run the .exe as a restricted user.
  36. Replies
    2
    Views
    596

    VS 2008 Re: ProgressBar

    Set it to different values at various checkpoints or just do a simple Marquee to let them know that stuff is happening.
  37. Thread: Hey Guys

    by Philly0494
    Replies
    19
    Views
    1,673

    Re: Hey Guys

    http://www.mathsisfun.com/definitions/whole-number.html
    http://www.answers.com/topic/integer-1
    Merrian Webster: "any of the set of nonnegative integer"

    o.o
  38. Thread: Hey Guys

    by Philly0494
    Replies
    19
    Views
    1,673

    Re: Hey Guys

    Keep in mind for question 1 a simple Integer will not suffice as a correct answer since it will allow for negative numbers (which are not whole numbers), therefore the correct declaration would be
    ...
  39. Replies
    43
    Views
    3,542

    Re: Prevent from closing a program.

    Antivirus programs do this all the time, not to mention if he wants to install some sort of security system or monitoring software he may not want the user to be able to use the computer without it...
  40. Replies
    11
    Views
    3,547

    VS 2010 Re: Is LINQ faster than for-loops?

    Well intuitively the for loop should most certainly outperform the LINQ approach

    But in case that isn't enough for you:
    http://ox.no/posts/linq-vs-loop-a-performance-test

    The LINQ method...
Results 1 to 40 of 492
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width