Search results for query: *

Hello Glenn, Thanks for the link. It explains what needs to be done. Has allowed me to come up with a solution and basically that is to develop the spreadsheet in Excel 2007, before developing save the spreadsheet in compatibility mode to Excel 2003 format then develop and it appears to do what...

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

I am looking for some sample code to achieve the finding of an access MDB files version. I don't want to get the version of the Access version running I need to open the Access MDB file and establish what version the MDB file is. The sample code would need to be any version of VB.NET. I can...

Thank you PVH (MIS), but can you give me just some example code in vb.NET. Thanks in advance

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

Hello RiverGuy, Thanks for your reply and code example. I have adjusted it slightly to depict my situation. What I need to happen is when the user clicks on column header to sort the column I need to have the displayed values sorted in Ascending or Decending order. The example code sorts on...

Hello RiverGuy, Thanks for your response. The DataGridView in question is bound via a binding source to a datatable in a dataset which gets its data from an SQL Database Table. The data that the SORT is required on is the datagrid column 'Display Value' of a 'ComboBox', not the value in the...

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 Rick, No I didn't receive an answer. I haven't spent too much more time on it but I have persisted with using the WCF service, I could not get it to work any other way (ie using 3 tier and data designers with data binding). I didn't want to add another layer of complexity to the new...

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

I would leave the table adaptor in VB for that column as DBNULL (providing the column in the SQL Database allows NULL values), then I would implement the solution in SQL via a TRIGGER. You can set a TRIGGER in SQL to Update the field after the Save, when the identity value is known. cheers...

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

Hello I am planning to develop an application that will be 3-tier (N-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...

Excellent, thanks to all those that replied. Alexcus post has set me on the right path. I will post the VB code here in case others are also seeking such. Don't forget to add a reference to System.Dat.SqlServerCE [Compact Database v3.5 which comes with SQL2008] in your project. It is so simple...

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

The code to create Dataset is as follows Dim strSQL As String = "SELECT * from Master" ' A OleCommand object is used to execute the SQL commands. Dim scmdBirds As New OleDbCommand(strSQL, scnnNW) ' A OleDataAdapter uses the SqlCommand object to fill a DataSet. Private sdaBirds As...

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