Search results for query: *

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...

I found the following info last night, and it seems to explain the problem. The link to the original post is: BindingSource.Find() Problem - MSDN Forums I tried the suggestion and the code in my previous post works. Now to check it didn't break something else...

I think the way to do it will be using the CustomersBindingSource.Find The problem is, the DataSource for CustomersBindingSource is ADifferentBindingSource. I keep getting the error: DataMember property 'CustomerID' cannot be found on the DataSource. Does anyone know what it means? I'm using...

But you slag it off at every opportunity! :eek: Well, yes I am :o. I'm comfortable with it. I know it's not supposed to be a *real* database but it's just a database - I'm not doing anything complicated with it. Surley, what I'm trying to do, doesn't depend on which database I use - the fact...

Are you saying, the only time you ever fill a dataset is when you first start the program? You just couldn't resist it could you? ;) I'm doing it because the dataset also includes calculated fields based on dates. When these dates are changed, the order the data is presented in needs to be...

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...

I should rephrase: This seems like a ridiculous amount of space (to get my app to run) - which is basically an MS Access database frontend. I didn't even want to use FW 3.5 but the project was saved using it, and as far as I can work out, there's no easy way of going back to 3.0 (not that it...

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...

Sorry, I didn't realise this was strictly for Q&As :rolleyes: I thought my question would help discover areas in which I might be doing the wrong thing. While you may have a very good understanding in these areas cjard, you don't need to make others feel they are time-wasting idiots for taking...

Shouldn't you be doing it the other way round? Like, importing into the database, then populating the DataGrid?

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...

It seems, all that's required is to clear the child table before filling the parent table:Me.MyDataSet.tbJobs.Clear()

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...

Thanks - that's what I've decided to do. 'Set DefaultValue for DateColumn Me.MyDataSet.Tables!MyTable.Columns("MyDateColumn").DefaultValue = Now It seems to work OK.

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

I found a solution! I don't know if this will be helpful to anyone, but here's a snippet of the code I used. (after filling an array with the values I want to check): While sourceReader.Read() 'for each row from source For i As Integer = 0 To sourceReader.FieldCount...

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...

I'd give VBOLock a try. http://www.moonlight-software.com/vbolock.htm Very reasonable price. Good customer support.

Are you referring to *my* DB or Access in general?

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...