Search Results - VBForums

Search:

Type: Posts; User: techgnome

Page 1 of 13 1 2 3 4

Search: Search took 0.38 seconds.

  1. VS 2010 Re: how to access an SQL lite database from an online server

    Do you mean use it once you have downloaded it? or use it right off the server w/o downloading it? If it's the former, then you estblish a connection and just use it. If it's the latter, you don't......
  2. Replies
    7
    Views
    266

    Re: Database Design

    Only if it's their home address... but even then people could (theoretically) have more than one... ther'es physical address and mailing address, work, vacation, etc... you'd be amazed at all the...
  3. Re: Bindingsource.addnew not working as I expected.

    What's the field definition for that field? What database system are you using? SQL Server, Access, MySQL? Is the field defined to auto increment? Are you generating the value on the client - this is...
  4. Re: Updating DateTimePicker control to show actual date and time

    Can the user change it? Should the be able to? If not, then don't use a DTP, just stuff the current date/time when you make the call to the save.

    The only reason to use the DTP is to allow the ...
  5. Re: How to replace a dates on a SQL query on Visual Studio (and get the query in ther

    Couldn't tell you. I don't use data sources... I always code everythign by hand. when it comes to data, I'm a bit of a control freak, I don't even use the Entity Framework.

    But either way, step 1...
  6. Replies
    4
    Views
    110

    Re: From VBA to VB.NET

    the words make sense... the requirement doesn't... but then we don't have context... So add 4 years to the date... then check the month portion... if it is 7 or 8 then return 9/1 of that year.
    ...
  7. Replies
    13
    Views
    289

    Re: On Error Goto Fails

    It's only valid in the error handler itself, for those cases where you have an error handler that can go wrong (such as logging to a file that's missing, or unable to write to, or your database...
  8. Re: How to replace a dates on a SQL query on Visual Studio (and get the query in ther

    Of course it's possible... many of us do this all the time... that's what the code in post #3 does...


    you create the sproc with parameters that are then used in the query... from the vb code,...
  9. Replies
    3
    Views
    133

    Re: Is This an Interpreter

    Ain't that the truth. And we still get the occasional post trying to squeeze every available last minuscule microsecond out of a process. I was working on a financial query yesterday - result set was...
  10. Replies
    13
    Views
    289

    Re: On Error Goto Fails

    No... it didn't go away, you're simply ignoring it... I think it was Si that said "VB is trying to tell you what the error is but you've chosen to stuff your fingers in your ears and not listen."
    ...
  11. Replies
    11
    Views
    219

    VS 2012 Re: Function as a Case

    Apparently the source that it is bound to isn't a list... or supports the IBindingList interface.... but it was converted to a list with this line:
    dgvBooks.DataSource = query.ToList

    Hmmm... no...
  12. VS 2013 Re: Flicker-free ListView Refresh - possible?

    It's too simple of a tool to have to inherit the LV just to get at the doublebuffering... why it's not publicly exposed, I don't know...

    Threading isn't going to be any help - all the UI updates...
  13. VS 2013 Flicker-free ListView Refresh - possible?

    I've got a listview that I'm using as part of a tool I built. the tool sets up some SystemFileWatchers to check for changes to files that are a result of a build. When the app starts, it scans the...
  14. Replies
    11
    Views
    219

    VS 2012 Re: Function as a Case

    Personally, I think you've got a bad design there...You've stuffed too much into the one sub... you need at least 2... one for the filtering by type, and one for the ordering. the process that does...
  15. Replies
    11
    Views
    219

    VS 2012 Re: Function as a Case

    Don't... sort the Grid using DataGridView.Sort

    -tg
  16. Re: remote connection to server (IIS especially) using Microsoft.Web.Administration

    Went spelunking through the documentation, I don't see ANY method to use to pass credentials, or that take any kind of credentials as a parameter.

    For a moment I thought this would help but it's...
  17. Re: Creating Lotus notes account using VB6

    There's VB6, and there's VBScript... but there is no VB6 Script ... So what do you want? VB6 code? a VBScript? or VBA?

    -tg
  18. Replies
    4
    Views
    123

    Re: Just loving the irony

    Need one that reads "Except no accuses"

    -tg
  19. Replies
    7
    Views
    173

    Re: Help With Visual Basic

    I just saw this as I posted... since Interg.TryParse is only in VB.NET... we now know where to move the thread...





    -tg
  20. Replies
    7
    Views
    173

    Re: Help With Visual Basic

    Also what version of VB are you using? Currently your thread is in the Office Development section, but it doesn't sound like your issue has much to do with Office, but I don't know if it should be in...
  21. Replies
    7
    Views
    143

    Re: Combo Box Values issue

    Yeah, unfortunately debugging is turning into something of a lost art form.

    -tg
  22. Re: How to determine the presence of a child form

    the same way you can simulate it in VB... drop a webbrowserr onto a form... size it to fill the entire form, remove the border, the max, min and clsoe buttons, make it titleless, no border and...
  23. Replies
    7
    Views
    143

    Re: Combo Box Values issue

    I'm sorry, I forgot where I was... didn't see 1) the DataEnvironment and 2) that this was VB6... so .Show and .ShowDialog will not apply.

    I think I spotted the problem... it's simple logic...

    ...
  24. Replies
    7
    Views
    143

    Re: Combo Box Values issue

    My two centavos - put the code to load the data into a public (or at least a Friend sub) ... remove it from the load event. From the calling form, create an instance of the form, call the...
  25. Replies
    5
    Views
    122

    VS 2012 Re: Textbox value

    Saying it doesn't work is like walking into the doctor's office and saying "it hurts" and expecting him to know what you're talking about... no one does that (as far as I know)...
    We're not...
  26. Replies
    8
    Views
    145

    Re: Detect empty "double" datafields

    took me a while to pull out my wayback hat... but
    Null is the ABSENCE of a value... so it canNOT be equal to anything... It's like asking if the ground is equal to the vacuum of space. It's a...
  27. Replies
    5
    Views
    113

    VS 2012 Re: ArgumentNullExeption was unhandled ????

    That's your prerogative. I've been doing this too long to give a fig. The crack about the image was a general observation and gripe .... We used to call it paying attention to detail. People post...
  28. Replies
    7
    Views
    113

    Re: VB SQL Problem

    Oh, to mark it resolved, use the Thread Tools menu at the top... top right of post #1... it may or may not be an option for you as a new user though.

    -tg
  29. Replies
    7
    Views
    113

    Re: VB SQL Problem

    I always plan from the start to use parameters... even in one-off prototypes... simply because it's just so much easier for me to do so since I build all my SQL in SSMS - more often than not it's...
  30. Replies
    7
    Views
    113

    Re: VB SQL Problem

    Use parameters or do not. There is no try... actually use parameters. Always... there should be no argument for not using parameters. Ever.
    I'm not surprised it doesn't work - "'@Picture')" you...
  31. VS 2013 Re: Speed Up Reading in Arrays from Excel

    Stop working with the arrays... or at least stop reading from Excel using arrays... instead open it with ADO.NET and suck the data into a DataTable... then close the connection and work with the data...
  32. Re: How to determine the presence of a child form

    There is no hWnd because it isn't a window... it's being run through the browser, that's why you're not getting the handle. It may look like a form but it's jsut HTML being rendered in the browser....
  33. Replies
    1
    Views
    70

    VS 2010 Re: execute command line

    well, you can use Process.Start to start the mysql console... but after that... it becomes a bit trickier ... your best bet would be to put everything into a .sql file (which it looks like you...
  34. Replies
    3
    Views
    122

    Re: sqlserver connection string?

    Sounds like you have two issues... in one case you supplied the code, but not the exception text... which will go a long way in determining the problem, and in the other, you gave the error message,...
  35. Replies
    5
    Views
    113

    VS 2012 Re: ArgumentNullExeption was unhandled ????

    Does any one look at their post after submitting it? Apparently not. Those screenshots are horrible - admittedly it's due to the resizing the forum does, but still...

    Well, if you're getting a...
  36. Re: App settings isn't stored in config file

    Configuration settings are a layering of multiple files from multiple locations... their scope determines where the file is located.

    The first configuration that gets loaded is the Machine.Config...
  37. Replies
    2
    Views
    142

    2.0 Re: Convert code C# 2008 to code C# 2005 ?

    It's using LINQ which isn't supported in 2005 ...

    Why are you trying to downgrade it in the first place?

    -tg
  38. Re: [RESOLVED] "Analog" gauge from DotNetBar, trouble accessing items

    Access them by name... if you access them by index (number) and then later remove or add one, or re-arrange them, their indexes will change, breaking your code. Better to access them by name.

    -tg
  39. Replies
    2
    Views
    102

    Re: Alternative data access methods

    I wouldn't add each line to the string builder... open the file, start your loop, call your method to create the line, then write the line out to the file... repeat until the end of the loop, then...
  40. Re: Creating an .MSI file with Visual Basic with InstallShield Limited Edition

    1) what's wrong with a setup.exe? Why does it need to be an MSI file?
    2) I don't know that InstallSheild can make MSI files... - correction according to TechNet, it can... hmmm... don't know then....
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.