Hello, I have 2 datasets I am trying to update. The parent table seems to update fine but when I go update the chiled table I get an error message that says I need a related record in the parent table. However I put some code in to display the key field of each parent table record (pa...more >>

I have a parent and a child datagrid, both linked to tables in a dataset with the appropriate relationship. If I add a new record in the parent table and then click directly in the child table (which at this stage have no records), I can add a child value but the parent value is NULL. If ...more >>

Hi, I have a problem regarding clear method of the listview control. In my application sometimes the "listview1.Items.clear()" method is giving me a "null reference exception". All I could thought of it is related to the no. of items in the listview but it is not the case. Even if my listv...more >>

I very new to Visual Studio/Visual Basic programming. I have done a lot of VBScript in ASP pages, but that is it. I'm using Visual Studio .NET 2003 (Visual Basic .NET) and an Access Database, the data adapter I'm using is Oledb. I am trying to create an application to allow someone to up...more >>

All I want to do is write a simple app that takes a user-entered character and gives me the 1 - 4 bytes that represent it in UTF-8. Common sense indicates that this should be easier than fissioning uranium atoms with sheer mental power. I'd have thought the active code should be about 1 line lon...more >>

VS2003. Have datagrid with drop down list, who's selectedindex property is bound to an int32 column in an ODBC dataset. Problem is that many rows in this dataset have (incorrectly) a null value in this column, which is causing an invalid cast error upon binding. Is there a way to force the b...more >>

Hi everybody, i´m working on an application that loads different modules (dll files) via an assembly. I check the build version in that dll file and if a newer version exists, i want to update the file. There´s only one problem: once loaded the library, i´m not able to delete it while the ...more >>

Hi! I have a main application here and developed 2 modules as DLL files, which will be updated from time to time. The main application ships without the modules so i want to be able, to put the module DLLs in application folder and call them from the main application. My question: is it...more >>

My application does and HTTP transaction with a web service provider that returns an XML document to me that includes a big bag 'o' bytes that is supposed to be a bitmap (a GIF or a PNG, my choice) of a label to print. So when I parse this XML doc, I have a string with a bunch of bytes - how...more >>

I'm trying to bring in a tab delimited file and dump it into SQL. I'm currently using an ODBCDataAdapter to fill a dataset: WriteSchemaFileForODBCImport(importType, filePath) Dim importConnection As System.Data.ODBC.OdbcConnection Dim importDataAdapter As System.Data.O...more >>

I decided to try using relations and untyped datasets for syncing a datagrid (child records)with a combobox (parent rows). Also put in stuff I thought I needed to set up dataviews for filtering. Now the ds won't load objects (tables) it seems like. I took out the tablemappings and schema actions ...more >>

Hi all During the course of a procedure a want to make a copy of an Access = database hopefully without closing it. I have noted that Windows = Explorer has no trouble copying an open file. I am using VB6 with all = the service packs. I have included the following code in the procedure large...more >>

Hi I have a simple form with a DataGrid My datagrid can display different tables from the database, depending on the user actions I.e. user click 'Customers - my grid displays 'Custemers'. DataGrid1.SetDataBinding(DsRptTable1, sDataMember) Depending on sDataMembers my grid displays different ta...more >>

Hi! I am designing an application that stores A LOT of hi-res picture into a database. The capacity of a db being 2gig, I will definately have to use multiple database. I would like to know whether it's possible or not to have relationship between database? is it possible to populate a dataset...more >>

-First I add and relate the tables A and B. Create a new instance of TableA Add TableA to DataSetX Create a new instance of TableB Add TableB to DataSetX Create a relation between TableA and TableB At this point I can connect the DataSet to a DataGrid and everything works fine, I can browse...more >>

It looks like this is a very popular subject, but all the previous messages have been deleated from the server. In my application, I need to export a table in my MSAccess database to an Excel 2003 spreadsheet. I have no trouble with individual ranges, but am having trouble finding a good exa...more >>

I am trying to add records to a table with a date field (access-database) where some of the records have a date and some haven't. I use dim dteReturDate as Date If IsDate(RsMem("Returdato").Value) Then dteReturdato = RsMem("Returdato").Value Else dteReturdato = Nul...more >>

I have 2 tables which separately exists on Access mdb (Customer) and SQL server 2000 (Orders) Is there a way for me to join these 2 tables in one query? Thanks ...more >>

When I try to run this through my form, SQL Server I says "Incorrect syntax near 's'. Unclosed quotation mark near ')'." I see that whenever I have a ' in any text field, it screws up my sql syntax. (look at Harrel's Ferry Rd in the insert statement). How can I fix this? Sometimes I need to ha...more >>

Hi, I am trying to change column orders on a datagrid where I have used an array as the datasource for the datagrid (added programatically) Please could you let me know if applying the mapping for the tablestyle is any different when using an array than it would be for a normal table. e....more >>