Search results for query: *

  1. D

    problems with datagridview saving currently highlighted row

    hi there. i have a windows forms app which displays a bunch of records from my sql database. when i modify records in the grid and click on save, all changes are saved EXCEPT the changes made to the currently highlighted row - they aren't written out the database until i exit the actual...
  2. D

    windows forms, oracle backend

    Hi there. i have created a form that is bound to a table in oracle. all data loads properly until i do the following: each field that is populated presents answers to questions on the form. so for example, i have the following label: question 1: how are you today? Beside the label, i...
  3. D

    scroll bars not appearing despite property being set!!

    dock property hi. the dock property is currently set to none. is that what you're referring to?
  4. D

    scroll bars not appearing despite property being set!!

    argh. not sure what i'm doing wrong, but i have a datagrid control embedded in a user control. i've set the "scrollbars" property to both, but for some reason, only the vertical one appears and i can't figure out why. i'm not overwritting it programmatically.... ??
  5. D

    Checking value of empty cell in dgrid gives error

    I'm looping through all cells in a selected row, trying to check for emtpy (either null or just empty string), but i'm getting the following error: System.NullReferenceException was unhandled My code looks like: For Each cell As DataGridViewCell In row.Cells If...
  6. D

    determining where the user clicked on a picture...

    hi. i need to display a graphic in a windows or web form. this graphic / image will have several regions. each region will be assigned a value from 0 - 6. depending on where they click, i want to capture the region value. in order to do something like this, what type of an image object...
  7. D

    bulding excel to sql server interface

    thank you I got my basic code to start off from other posts... like Import Excel Data into SQL Server with VB.NET - .NET. this is just a prototype to see how things work... so i apologize for the confusing names...
  8. D

    bulding excel to sql server interface

    i'm building an import routine for my application - the goal is to have the user be able to select an excel spreadsheet that looks identical to my sql server database table. so far, i've built a small prototype and the code looks like this: Private Sub btnImport_Click(ByVal sender As...
  9. D

    error editing datagridview

    that fixed it! Thank you! i changed the selection mode like you said and used the for each and now everything is working. what's the difference between the for each and the for i had? the for next loop i had was kinda of working... just want to understand the fix. also, the error message...
  10. D

    creating a flexible search

    hi there. i'm just a newbie at data access with .net & sql. i've managed to build forms that have datagrids bound to various data sources. but now i want to create a search form that allows a user to create dynamic sql statements instead of running a canned sql statement. so far i have the...
  11. D

    error editing datagridview

    Hi there. I have a datagridview control that i populate with records from my database. i'm now working on a feature where the user can select multiple records to remove from the datagridview. I do this by setting a certain value to NULL. It works only if the user selects no more than 2...
  12. D

    DataAdapter / Datagridview question.

    attempted solution.... So far, i've come up with the following SQL Update command: UPDATE Contact SET register= @reg, Moved = @Moved, TerritoryID = @territoryID FROM Contact INNER JOIN Territory ON Contact.TerritoryID = Territory.TerritoryID...
  13. D

    DataAdapter / Datagridview question.

    I have a question which might sound silly but I'm new to datagrids and data binding in vs 2005. I have successfully created a datagridview which gets its data from a datatable / table adapter. The sql being executed in the fill method looks like this: SELECT Contact.FName, Contact.LName...
  14. D

    newbie messing around with windows services & threads

    Calling a .refresh method on the service controller before checking status. seems to be fine now. DOH! Thanks anyways.
  15. D

    newbie messing around with windows services & threads

    Ok. So I removed the threads to make things less complicated. However, there is still a bug where the custom service doesn't seem to notice a refresh on the status of the three 3 monitored services. EG) If I stop one of the three services, let the timer elapse, get notification and then...
  16. D

    newbie messing around with windows services & threads

    Hi there. i'm trying to create a windows service that: 1. monitors 3 other windows services. 2. sends an email if any of the 3 services stop / die. I have two problems: 1. I dunno which event to use to code my main logic. THe main logic is pretty simple: For each service I'm watching, I do...
  17. D

    unhandled system error when i call this function

    Can you explain why I'm geting the following error message: An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll It occurs when i try to fill the adapter........ PublicFunction GetWorkEffortRatios() AsBoolean gstrSQL = "Select W.WorkEffortRequired...
  18. D

    Syntax for creating PreparedStatements (SQL) in vb

    How do I create a prepared statement in vb.net? been doing some reading and i understand that using ps are better than regular SQL statements because Oracle is able to reuse the execution plan / hence speeding up the application. Also, related.. how to use bind variables in asp / vb ? Thanks.
  19. D

    Upgrading vb6.0 project to .net using wizard

    Sorry, I guess I wasn't clear in the first message. I did upgrade the source code. My question is why would the system give a message that it didn't upgrade one particular class? In the upgrade report, there aren't any serious errors - just warnings. However, inside the code, the wizard...
  20. D

    Upgrading vb6.0 project to .net using wizard

    Hi. I have a vb DLL that I just attempted to upgrade using the wizard. Although there were no errors, for one particular class, the system didn't upgrade it. How can I figure out what happened / why it won't upgrade it?
Back
Top