| Thread | Last Post | Replies |
|
| Concurrency Issues after a Delete has occurred in Access | 08 Dec 2004 10:24 GMT | 8 |
Hi I get this error below. ------------------- An unhandled exception of type 'System.Data.DBConcurrencyException' occurred in system.data.dll
|
| Can't Open Database from WebService | 08 Dec 2004 09:19 GMT | 4 |
I have a project consisting of a Web application and a Web service. The Web application calls the Web service to do some modifications in a database ( Microsoft Access ) When the OleDbConnection.Open function is called I receive the followin message:
|
| retrirving @@identity using ado.net | 08 Dec 2004 06:45 GMT | 3 |
I am writing an asp.net app, where I insert some data into a table that contains an identity column ID and I need to know after the insert what was the ID value just created. In my Client server development I usually use select @@identity to get this info, but it doesn't work in ado ...
|
| Updatecommand error | 08 Dec 2004 01:12 GMT | 2 |
In wrote this in VB code: DAComent.UpdateCommand.CommandText = "UPDATE coment SET estmensag='P' WHERE nomepess LIKE '%" & Trim(TextBox2.Text) & "%' AND emailpess LIKE '%" & Trim(TextBox3.Text) & "%' AND mensagpess LIKE '%" & Trim(TextBox5.Text) & "%'"
|
| DataSet and Stringbuilder? | 08 Dec 2004 00:11 GMT | 1 |
Hi expert, I received a sample from bank for the header record in the output file (attached at the bottom). I want to use same method to have a stringbuilder to arrange the fix
|
| LoadDatarow DataReader Cast Error | 07 Dec 2004 23:21 GMT | 1 |
Im am trying to load a Data from a DataReader into a DataTable with the following code. I am getting a cast error at the LoadDataRow statement. while(reader.Read()) {
|
| problem declaring SqlParameter of type Decimal | 07 Dec 2004 21:18 GMT | 1 |
Problem: When peforming an update on an SQL (MSDE2000) data field of type DECIMAL my values are being rounded. For example if I enter 1.1 through 1.4 a 1.0 is entered into the table. If I enter 1.5 through 1.9 a 2.0 is entered into the
|
| database Query result in excel spread sheet | 07 Dec 2004 19:45 GMT | 3 |
(Type your message here) -------------------------------- From: krish pat Hi
|
| Connection pooling. A good idea?? | 07 Dec 2004 17:53 GMT | 3 |
I thought the advantage of disconnected data using dataapapters and datasets is that the connection to your SQL server is only open briefly to load the dataset.. But isn't the connection pooling keeping the connection open far beyond the few seconds you needed to load a
|
| DataSet.Merge yielding Constraint Error | 07 Dec 2004 17:25 GMT | 1 |
I have dataset1, do a GetChanges to yield dataset2 dataset2 is saved The keys from dataset2 are used as search parameters to retrieve new data into dataset3.
|
| Excel-like appearance in the datagrid | 07 Dec 2004 16:23 GMT | 2 |
I'd like to give my users the same "empty grid" look of an Excel sheet (at least an empty row to start with). I've thought to mimic this appearance by setting up an empty datatable bound to the grid (columns will be predefined) and then using AddNew to add the first empty row to ...
|
| Reading Excel ranges | 07 Dec 2004 15:19 GMT | 1 |
I have a routine using the OleDb provider to read an Excel worksheet. The code works well, except when I need to read data from non adjacents ranges. In this case I receive all sort of errors. I need to select data from A11:B37 and E11:J37. I tried these expressions but
|
| ADO .NET and Excel ... | 07 Dec 2004 15:15 GMT | 8 |
Frankly speaking, what ever one says, Microsoft technologies will always remain problem-matic.. specially with versions... they don have seamless integration. Deployment is always always an issue. But I still love .NET!! Anyway folks, my problem goes like this...
|
| ADO Connection question | 07 Dec 2004 15:03 GMT | 1 |
I am having trouble opening an Access DB using ADO from VB. I am part of a workgroup, the error message is: Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
|
| How to find Number of Rows in DataReader | 07 Dec 2004 12:12 GMT | 5 |
I am using DataReader to populate my data. I want to find the number of rows in the DataReader. How to go about doing this. Is there any property or method available. I know that, it is a forward only read only cursor. But, I am a situation to find the number of rows.
|