Search results for query: *

  • Users: PhillD
  • Content: Threads
  • Order by date
  1. P

    Windows Service Error/Log File Location.

    Before I post about my problem, please consider the following: If you are having problems with a windows application (especially a commercial app that run's as a service on a server), where would you look for the error/log file? Ok, so yes, I have written a windows service that run's on a...
  2. P

    Combobox will NOT update dataset value to NULL\Blank

    Is it a known issue that the combobox will not save changes to the dataset if the entry in the combobox is blank? This problem is driving me insane! Here's the scenario. The user open the form, the record loads, they make a selection from a combobox and save the record. The user then...
  3. P

    Combobox Validating - on value changed?

    Hi, Is it possible to only validate a combobox if it's value is changed? I'm looking for something similar to the .modified property of the textbox countrol. Private Sub txtCheckNumber_Validating(sender As System.Object, e As System.ComponentModel.CancelEventArgs) Handles...
  4. P

    Problem saving new record in a form. Do I need a binding source?

    I have built a form which is used to input sales expenses. It consists of a few text boxes (for Expense Header information) and the DevExpress DataGrid (for Expense Details entries). The Textboxes are bound to the ExpenseHdr table in the ExpenseTickets Dataset and the grid is bound to a table...
  5. P

    My greatest critics (the users) have spoken - the DataGridView is CRAP

    After completing my latest form in .NET, I decided to submit it for testing to the intended end users. This was the first in-house developed .NET app they have seen and the results were not good. They use .NET every day via our ERP system, so they have a good handle on what to expect and how a...
  6. P

    Trap TSQL Errors in .NET form

    Hi, I am triggering a stored procedure from code inside a form and I am wanting to return any TSQL errors back to the form. I have written code to do it but when I force an error in TSQL for testing, my vb.net code drops to debug mode with "SQL Exception was unhandled" error. Here is the code...
  7. P

    3rd Party DataGrid(View) control

    Can anybody recommend a 3rd party DataGrid control similar to the MS DataGridView. I would like something that can handle null vales without throwing Object reference errors. Decent hosted controls support (for things like Type-In Combo Boxes, date time picker) Similar Data Binding options as...
  8. P

    Showing Primary Keys in Lookup/Combo Boxes

    In a lot of older developed systems, I see a lot of Textual based Primary keys used for lookup values in tables. E.G. Order Status R = Ready, S = Shipped, C = Complete or in our product codes table CF = Cage, OBS = Barrel etc. In today’s programming world, is it necessary to use textual keys...
  9. P

    Gray Out Entire Grid

    Does anyone have any code that would effectively cause a datagridview to appear though it is disabled. I have a situation where I enable/disable the grid and need to provide visual indication to the user. I have been playing with it but there seems like a lot of options that need to be...
  10. P

    SQL Constraints

    I am fairly new to .net development but I have worked with Access and SQL for over 14 years. Hence to say, I should know at least a few things about database development. I just ran into a situation where I had to remove a constraint within the SQL database because VB.net could not process...
  11. P

    Master / Detail Data - major issue/Bug?

    I have made several posts on here lately regarding master/detail or parent/child data setups but no one has been able to help. It seems like a subject people don't like to tackle BUT I really need help. I'm having a real hard with the DataView.RowFilter functionality and it is driving me...
  12. P

    Combo Box in DataGridView auto-selects?

    I have setup a form with a single datagridview with a combobox column. I have set the combo box data source to some SQL data. When I run the project and single left click in the combo box (not the drop down arrow), the box is populated with the first available value in the dropdown list...
  13. P

    Update Statement Syntax?

    Hi. I have a DataGridView which is bound to a DataSet. The data comes from multiple tables with join statements, therefore, I am unable to use the SQLCommand builder to automatically update the data. When the data is loaded in the grid, it will contain multiple rows (with a hidden primary key...
  14. P

    works like a combo box?

    For a combo box that works like a combo box? I need to add a combo box to a DataGridView that is bound to data. I need to be able to display multiple columns within the combo box (like you would find in any other normal program). I need the combo box to drop down without having to click it 4...
  15. P

    Database design question

    I am designing an sales expense tracking system and I would like some opinions on a design decision. In my expense lines table, I need to have an expense type code. E.g. 1 = Meals, 2 = auto expense etc. I can create a lookup of expense types but I also need to store an general ledger account...
  16. P

    Table Adapter Insert Help

    Can someone please help me. What I am trying to do should be very simple but I can't figure it out. I have a parent child form (Orders and Order Lines). I have 2 table adapters. The Order details are in the first and the order lines are in the 2nd. When I save, I need to save a value from the...
  17. P

    Using Identity Field in Forms

    I have setup a simple table in SQL 2005 with 2 fields, EmployeeID and EmployeeName. EmployeeID is an identity field. A created a new form and setup a data source added the 2 fields to the form by clicking and dragging from the data source. Visual studio setup the TableAdapter, DataSet and...
  18. P

    Question Auto Increment as ID Column

    I am developing a form that is linked to a single table. I am using an auto increment field as the record ID the users are given to identify their record. If 2 users open the form at the same time, they are given the same ID number. When the first user saves, they will keep the number...
  19. P

    Question Thrown In At The Deep End

    I am really hoping someone can help me. I am a complete noob to VB 2008 though I have worked with MS Access, VBA and VB for 15 years. I have been asked to write a system for employee to enter expenses. I’ve setup 2 tables in SQL, first the ExpenseHdr for employee, date etc… then ExpenseLines...
  20. P

    Question Dim Noob as object If noob.idiot = true then MsgBox("HELP!", MsgBoxStyle.Critical)

    Dim Noob as object If noob.idiot = true then MsgBox("HELP!", MsgBoxStyle.Critical) First a little about me, I have been a programmer for 15 years, started in MS Access & Macros and soon discovered VBA. Eventually that led to VB6 with Access Backend. I am completely self taught which is...
Back
Top