Search results for query: *

  1. F

    Anyone interested in taking over my project?

    I have been developing an application in VB.NET over the past few years, which I no longer have time to develop. If anyone is interested in taking over this project (at a price!) get in touch. The application is currently being sold here: Round Management System by Snowdream Software for...
  2. F

    Re-select current record after TA refill.

    Hi all, I'm using a DataGridView to show a list of customers from an AccessDB. When I save any changes, the TableAdapter is re-filled and the currently selected customer is reset to the first in the list. What is the best way to ensure I go back to re-select the customer I previously...
  3. F

    .NET Framework 3.5 takes 456MB?????

    I have used dotNetFx35setup.exe in my Setup.exe to install .NET Framework on XP without any Framework previously installed. (I'm not using ClickOnce) This setup then goes to download and install FW 2.0 & FW 3.0 & FW 3.5 which takes 456MB of disk space on the users PC. (Vista isn't a problem as...
  4. F

    Parent - Child SELECT query

    I have 3 tables: tbCategory, tbCustomers & tbInvoices. I want to show in a DataGridView, a list of the invoices in a particular category, including the Customer Name. InvoiceNumber CustomerName CategoryDescription -------------------------------------------------- 123456789012 Mr Jones...
  5. F

    Re-Fill a dataset with FK constraints

    I have a parent table (tbCustomers) with child table (tbJobs) in my Access DB :eek: Everything was working well, until I decided to add a Foreign Key Constraint. This is what basically happens when I add a new customer: Me.Validate() Me.TbCustomersBindingSource.EndEdit() Dim CustomersTable...
  6. F

    Default value for Date fields in table

    Is it possible to set the default value for a Date field in the DataSet Designer to always be "today's date"?
  7. F

    Validating data coming in from Streamreader

    I am importing spreadsheet data using StreamReader. Is there any way to check the data being imported is valid? The first column in my spreadsheet is an integer which I need to check against a valid range of numbers before accepting the data - if it's invalid I will use a default value (the...
  8. F

    SQL to SELECT Invoices with InvoiceDetails

    I am trying to generate a report showing a list of Invoices using Access DB. I want to SELECT all Invoices in the table, but also include a total from the InvoiceDetails. As long as I don't try to ORDER BY the InvTotalAmount, it works as expected: Date Inv No. Total...
  9. F

    SQL for Lookup tables

    In my Expenses table (Access DB), I have fields Category, Payee & Method I also have a Category, Payee & Method table which are LOOKUP tables, all with ID and Description. I need a SQL statement which will collect the descriptions of these three fields. I can get the results from the...
  10. F

    UPDATE TableAdapter when query has INNER JOIN

    I want to be able to fill a dataset with information from two tables (Customers & Orders) This dataset then fills a datagridview which will show order details (from Orders Table), along with the customer name (from Customer Table) - This I can do. I also have another Dataset which contains the...
  11. F

    TableAdapter Configuration Wizard - Advanced Options

    Hi all, I'm using MS Access DB with VS2008. In the TableAdapter Configuration Wizard, the default Fill query looks like the pic below. The problem is, I want to create a new query, but when I do, the Advanced Options button is missing (I need to generate Insert, Updates & Delete statements)...
  12. F

    Minimum install for SQL Express?

    I have quite a small application (5MB installation) which uses SQL DB. Is there any way I can install a bare minimum SQL Express? At the moment, it takes up about 200MB!! Not to mention the 38MB it adds to my Setup.exe I'm sure there's loads of stuff installed which isn't being used by my app...
  13. F

    Passing date variables in SELECT statement

    I've been struggling with this for a few days, and now have to ask for help. I am trying to pass a date variable (taken from a DateTimePicker) in a SELECT statement. Dim FromDate As Date = FromDateDTP.Value Dim command1 As New SqlCommand command1.Connection = sqlConn command1.CommandText =...
  14. F

    Move DB to DataDirectory

    Hi all, does anyone know how I would move my database from the .\SQLEXPRESS directory to the Application Folder ?
  15. F

    Has anyone tried this to hide tabs?

    Came accross this while trying to find a solution for hiding tabs:Beth Massi Can anyone explain (simply) how and where to put this code so I can hide tabs? I don't know much about classes...
  16. F

    How to delete all data in SQL database?

    I found the following query and tried to execute in Management Studio, but has a problem with one of the tables: -- disable referential integrity EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL' GO EXEC sp_MSForEachTable 'TRUNCATE TABLE ?' GO -- enable referential integrity...
  17. F

    Where is BindingNavigator automatic code?

    I am trying to prevent users from deleting the last row in a table, but cannot find the code for the Delete button in BindingNav. Anyone know where the code is? (Not the Designer Generated Code) Or maybe there's something in the SQL database to prevent it?
  18. F

    Update dataset without using datagridview

    I want to update a field in SQL database to hold a NULL value. I can do this using a DataGridView control, with the code: OrdersDataGridView.CurrentRow.Cells(0).Value = DBNull.Value Which works fine, but I don't need the DataGridView on the form. I could hide it behind another control, but...
  19. F

    Fill TableAdapter with Stored Procedure?

    Hi all, first of all, I should explain what I'm trying to do since I may be going about it the wrong way... I have a Dataset which contains 3 related tables - CustomerType: CustomerTypeID CustomerTypeDescription Customers: CustomerID CustomerTypeID CustomerName Jobs: JobID CustomerID...
  20. F

    IIf IsNull using SQL

    Previously I have been using MSACCESS databases, but have now changed to SQL. I was able to use the following to calculate a Due_Date based on the Last_Done date: SELECT Manual_Due, Last_Done, Last_Done + Freq * 7 AS Calculated_Due, CVDate(IIf(IsNull(Manual_Due), Calculated_Due...
Back
Top