Search results for query: *

I am building a DataGridView to maintain employee rostered shifts e.g., Code, Name, ShiftStart_DT, ShiftEnd_DT I have not been able to find a good method of editing the DateTime fields in the Datagridview. If you have used a DataGridView to allow editing of datetime in a column could you share...

I have a spreadsheet developed in Excel 2007 which has conditional filtering displaying data in Pivot Tables. I want to have users who do not have excel to view the spreadsheet including being able to filter the data. My problem is that the excel viewer whilst allowing the spreadsheet to be...

Has anyone got any VB .NET code to read an Access MDB file and determine what the version of the MDB is. i.e., Access 97, Access 2000, Access XP, Access 2003 or Access 2007. regards Kieran

Hello, I need some tips/solution on creating an SQL statement that selects each row(record) in a table when a particular column value changes. Some code follows to create an example table and also to insert some basic data with an example of the output that I need to achieve. (This is for a...

I am developing an application and using the VS2008 DataGridView control. I have a bound DataGridView using a binding source etc. I need to provide sorting within the DataGridView control on a column using the ‘Display Value’ of the cells rather than the value from the bound datasource. The...

Hi In Visual Basic does anyone have details on grouping data from a dataset or dataview to another dataset or even a dataview. ie. As an example only - I have data as such: Pink, 10 Green, 20 Pink, 1 Red, 12 Red, 1 Blue, 50 Pink, 1 in a dataset (7 records). What I want to do is have a simple...

Hello I am planning to develop an application that will be N-Tier (3-Tier} using Visual Basic in Visual Studio 2008 (VS 2008). By 3 tier I mean: Tier 1) Handles User Interface/Presentation, Tier 2) Applies Business Rules/Logic (Validation of data etc) and Tier 3) Data management (retrieve...

Hi, I want to read an Access Database to establish the tables in the database then read each tables structure including each field in the table, field type and size. I would also like to read the attributes such as primary key, foreign keys etc. Does anyone have any Visual Basic 2005 code to do...

I am wanting to use SQL Compact Edn database for a single user application being written in Visual Studio 2008. I can programatically create the Database as such: Private Sub CreateDatabase() Protected Const SQLDBfullfilename = "C:\Users\KGM\Documents\Visual Studio...

I am trying to update an Access database. I am attempting to do the update via a Dataview The record to be edited is found and the Dataview data is edited OK. My problem occurs when I try to save this to the database. I don't get an error but the dataview has the updated data and this data is...

'My Base form (which I inherit in new update forms) has a toolbar which has buttons for Add, Edit, Delete etc. This form always has a tabcontrol and at least 1 tabpage. I have code (see below) that iterates through the controls on this forms Tabcontrols Tabpage (first one) and sets the control...

'I can iterate through controls on my form and set the .text and .enable property (see below). However, when I try to set the .READONLY property I get an error. How can this be done. 'Code Dim i As Integer For i = 0 To Me.Controls.Count - 1 If Me.Controls(i).GetType() Is...

I have a Variable with a list of items (see @a) below. I need to be able to check the variable to see if an item is in the list and the perform relevant action. How can you do this in T-SQL. eg something like below code - but that doesn't work. declare @a varchar(80) set @a = 'xxx' + ',' +...