After upgrading from XP SP1 to XP SP2 get "operation is not allowed when the object is open" error messege. the app in production stop working properly. The refresh method is available, but fails. Here is the code: With Adodc1 ..ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Se...more >>

Hi I can't seem to get the code right to sort the parent form, i can get the child form to sort. Can anyone help Thanks A -- Message posted via http://www.dotnetmonster.com...more >>

How can I join 2 bianry files together back to back? Thanks dee ...more >>

Hello, I am having a problem using Scope_Identity() when inserting a row to a sql server (sql server 2000 standard Edition) table using a sql DataAdapter.InsertCommand. The row gets inserted but it does not display on the datagridview on my client app (vb2005). I just get a blank row. Bu...more >>

hi, i have a typed dataset containing two data tables and a data relation which links the two tables in a parent-child manner. i use a sqltransaction to control the insertion of records into the database. here is the code for the insertion. foreach (SeminarData.ActivityRow activity in ds...more >>

When I use the OleDbDataAdapter.Fill to fill a DataSet with a ADODB.Recordset an error occurs ("No error message available, result code: DB_E_BADROWHANDLE(0x80040E04)." If only the .NET Framework 1.1 is installed everything works fine. What's wrong (or changed)? ...more >>

I am trying to implement record level pessimistic locking using ADO.NET and SQL Server 2000. A reduced structure of the table is shown: CarrierName(varchar) CarrierCode(varchar) RefundStatus(int) ------------------------------------------------------------------------ -------- US Pos...more >>

ANybody know how to do a silent install for SQL Express? I need to know if this is possible to make my decision to use SQL Express or Access as a database solution. ...more >>

What is the preferred way to read (not write) the records of a typed dataset in C# without use of a form? thanks, Jeff ...more >>

Why would you choose SQL Express (which requires an installed application to work) over the simplicity of an Access database which has no dependencies? ...more >>

Hi, All How to get the output parameter's value when you use the SQLHelper (Microsoft Data Access Block)? When I try to access my ourput parm I got the following error. System.NullReferenceException: Object reference not set to an instance of an object. I thought it is because there ...more >>

I am trying to figure out if object spaces are included in .net framework 2.0. If so, I am trying to find the dll called System.Data.ObjectSpaces.dll Does anybody know this? ...more >>

Last week we were running some code that connects to two different SQL 7 servers. On Friday, the connection times were normal (almost instananeous). Today, from all of our development boxes, the connections are taking 5-7 seconds to open. The app is written using the 2.0 framework. In our...more >>

Codebase has been in place for 1.5 years. Current version running since 12/2005. First use of a command object that has 14 parameters. Now I get this error on first use, subsequents work fine. sproc work actually completes, but error is raised....more >>

I have a table that I generate the schema for by way of da.FillSchema(ds,schemaType.Source, StringLoadTable) One of my columns (numerous columns actually) are created as System.Boolean however the actual SQL column that the schema is pulled from is of datatype Bit. I can successfully add da...more >>

Hi, What can you do with the Table.DisplayExpression property? I tried to use this as a custom name for my table but only table columns are allowed? Thanks Bart...more >>

I am looking for a small example program which will create, at run-time, a connection to an Access database. I would like the example to have a navigation bar and display a table from the database. Please only post code for a working small program. If necessary explain the code or how it was c...more >>

Hi, I'm using ado.net 2.0 and I have this strongly typed dataset that has this table that has some custom sql update queries. The thing is, my customDataSetTableAdapter.myTable has no generic "Update()" method. It only has some ".myCustomUpdate(param1,param2)" method, that I can't use to sen...more >>

(sorry if this posts twice....I waited several hours and didn;t see it - so here it is again.....) Perhaps I am somewhat dense.....but, I still need to know..... What do you need to do in order to ship a SQL server Express or Developer edition database with your Visual Studio .Net 2005 appl...more >>

Hi I have a datagrid (vb.net) that works from a access database. I configured the datagrid, but now my checkbox has turned into a textbox displaying false. how do i code this column to display the checkbox again. Please help Thanks A From http://www.developmentnow.com/g/7_0_0_0_0_0/dotnet-fr...more >>

Perhaps I am somewhat dense.....but, I still need to know..... What do you need to do in order to ship a SQL server Express or Developer edition database with your Visual Studio .Net 2005 application? Does SQL Server Express need to be installed on the target machines? Or, can the database ...more >>

Ok. So here's my situation. I've created a small database in SQL Server 2005 that looks like this: CREATE TABLE [dbo].[TblB]( [Id] [int] NOT NULL, [Name] [nchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ) ON [PRIMARY] CREATE TABLE [dbo].[TblB]( [Id] [int] NOT NULL, ...more >>

Hi, I have a data table that was generated using the dataset designer. It refers to a table in a database that has a primary key. The primary key constraint is captured by the designer and enforces a value/uniqueness in client dataset. I have added the select, delete, update, insert comm...more >>

I'm looking for some examples of: 1) Loading a DataSet with one dataadapter and connection. 2) Reconnecting that DataSet to another dataadapter / new connection 3) Pushing the DataRows back to the database as if they were new rows. For my application of this... the Tables are identical in desi...more >>

pre-emptive apology: I'm not sure if this is the best place to post about Linq, but I haven't seen a public linq forum, so I figured ado.net would be the closest thing. My apologies if my assertions have failed. Here's the deal: We are just starting work on 2 new applications that aren't s...more >>

This occurs on the first attempt to connect to a database in a web application in release mode only. Solution: - Click "Start." - Right click "My Computer" and select "Manage." - Select "Services and Applications," "Internet Information Service," "Web Sites." - Right click the folder ...more >>

Hello. I am trying to connect to a SQLServer. Now, it takes long time to detect, if the server is available or not. I think, the parameter Connection Timeout from the ConnectionString will be used to set the Time. Now it takes about 15 s (Default of Connection Timeout). When I set this para...more >>

Hello everyone, I have data in XML file, thats generated at runtime. Now i want to load this all data into a PDF file and save that file... can someone suggest me dome way of doing the same. Thanx ...more >>

I have designed some datasets using VS2005 by dragging in tables from a SQL2000 server. When I look at the generated code, it references the SqlClient provider in many places (for example, the command objects and the mappings of datatypes). Is there some way to make these generated datas...more >>

Hi, here is my code: cmd = New ADODB.Command If cnxIQ.State = 0 Then cnxIQ.Open() End If cmd.let_ActiveConnection(cnxIQ) cmd.CommandText = strProcedimiento cmd.CommandType = adCmdStoredProc cmd.Parameters.Append(cmd.CreateParameter("@param1", adInteger, adParamInput, , 200506)) rsResul...more >>

I need a calulated field which formats an integer (another column in the same row) to a certain number of digits (leading zeroes). How to specify the DataColumn.Expression property for this ? ...more >>

Hello, I completed an application as described on the subject line. Now, I have to delete my DataGridView, re-create the DataSet, TableAdapter, BindingSource, and BindingNavigator. I have to set all the properties also that I liked. What is an easier way to do all this? Do you have a s...more >>

We're beginning a major rewrite of a VB6 application that currently uses ADO and an Access database. In this application, we routinely query multiple table through JOINs and place the result in a single connected record set that is often bound to a grid for display and editing by the user. Cha...more >>

We're using ADO.NET and SQl Server 2K. I'm updating an integer column in a seperate table which I use to hold sequence numbers for different reference strings. Together the string and int form a unique code which is we use as user reference for invoices, orders etc, (the PKs are hidden). ...more >>

SQLconn = new SqlConnection(dbConnectionString); has async=true SQLconn.Open(); // SQLcmd = new SqlCommand(SPName, SQLconn); SQLcmd.CommandType = CommandType.StoredProcedure; SQLcmd.CommandTimeout = 0; // And start executing IAsyncResult iaR = SQLcmd.BeginExecuteReader(); waitHandles[SQLEVE...more >>

Hi there! I've parsed the posts in this thread but haven't found answers to my problem. It drives me nuts. I'm newbie at Database app under VS2003 and for now I only do simple things. I fill a table with hundreds of records. I can see the result in a DataGrid. Now I want to save the records ...more >>

Hello, I am just checking if VS2005/VB2005 automatically opens and closes sqlConnections for you. I noticed that if I just invoke the connectin conn = new SqlConnection conn.ConnectionString = "..." cmd.Connection = conn .... dataAdapter.SelectCommand = cmd dataAdapter.Fill(ds, "tbl1")...more >>

Hi, We are working at building a web application using a SQL server database. This DB already contains many tables and many relations ( "one to many" and "many to many"). How should I develop the "write to database" layer in order to make it handle many tables with many relations from the ...more >>

I have a set of datasets that I build in 2.0 that reference a Settings/Connection string called, name="PDS.LSS.Properties.Settings.StateConnectionString". I have a method that allows my users to either create a new MDB or select a existing MDB to reference these database objects. My pro...more >>

I'm writing data to an Access database using OleDb stuff. Everything works fine except when I'm working with dates. Here's what happens: If I write UPDATE SQL with an "@SomeDateTime" parameter and then I create an OleDbParameter object and I set it's Name field to @SomeDateTime and it's Val...more >>

Hi! I have Excel file as the DataSet for my application, which the user uploads and the same is stored into the database. The problem is that user put varied worksheet names for their worksheet. So, how can we read the data from the Excel and upload the data into the dataset?? Thanks in ...more >>

I have my object containing datarow and exposing properties: e.g.: public int Price { get{ return _myRow.Price; } set{ _myRow.Price = value; } } what if i want to set this value to null? Do i have to expose .SetPriceNull() and .Is...more >>

I have a dataset populated from a spreadsheet with 4 columns and I want to fill the dataAdapter for the database that also has 4 columns, but the data types are different. One column holds an INT(32) and I'm trying to put that into the column and holds a string. The question I have is how do I ch...more >>

I wish to do a grid of sales per quarter by Salesman. So, layout like this: SALES PERSON Q1 Q2 Q3 Q4 John 5 6 7 8 Jane 3 2 1 9 There's two things I'd like to do, and let the user c...more >>

Hi, We are using ASP.Net 2 and SQL Server 2005. We are storing sessions in the database. From time to time we get the following exception in the application while the ASP.Net session tries accessing the database. This also happens from time to time when our application is accessing the data...more >>

Hi everyone, I know when you enable paging in a datagrid the entire data is read but only the data that you want is displayed to the end user. Has this changed for Gridview? So if you have 10000 records and you only want 20 records displayed, does it read all 10000 and display 20 or does it o...more >>

Hi. I'm using Command.Parameters.Add() to add parameters to a SQL query that updates an Access table. When I want to pass a NULL value parameter for a DATE column, I'm getting a runtime error that says that there's no default value set for the parameter, but I don't know what that means. ...more >>

Hi, I am having trouble editing bound data in a webform. My textbox is bound to an underlying dataset. The dataset is filled with a single record during the page load event using the Fill() and DataBind() methods. The data appears in the text boxes and all is well up to this point...more >>

Is it advisable to use nchar columns instead of char columns as indices would not be used when parameterized queries are used by the application which are always unicode based? Please advise. Thanks...more >>