I would like to use a dataset as a data file (like a database). However, I didn't find a way to use SQL on the Dataset (except on a DataView, but then Dataset is all loaded.). I also noted that I must flush the whole dataset to disk and load it all to read it. I wonder, if there is a better way t...more >>

Hi, I have an asp.net application and am facing a problem while closing my datareader object. I am using Active reports for dotnet for generating reports. I create a datareader object in my data access layer and then pass it to the calling function ( I know this isnt a good practice, but I ...more >>

I have a vb.net application. Using ado.net, I create/open a connection, create a transaction object, and go through a loop. In each interation of the loop, I create a SqlClient.SqlCommand (using this transaction object) and perform a cmd.ExecuteNonQuery using a SQL Update statement. After everyt...more >>

Hi, I am trying write a web application using ASP.Net to load an Excel file from client site and save all the data in the file to a table in SQL Server 2000. My current assumption is: load Excel data to an ADO.Net dataset, or a datareader, then pull the data out from them and insert the data...more >>

I ran my code against my LOCAL SQL Server database -- all works. I run the code against a remote SQL Server providing the correct uid and password, and I get Login failure. What is more bizarre, if I step thru the code in VS.NET (exact same code with same connection values), I don't get th...more >>

How to apply a DataView.RowFilter with numeric values. I always get exception from the System.Data.SyntaxErrorException: Syntax error: Missing operand after '=' operator. Any Ideas would be good Thanks...more >>

Hi All, I read in a book that a program can connect to a database using two different types of connections to a database. In case the program can maintain a direct connection, classes such as OleDbConnection, OleDbCommand and OleDbDataReader can be used. The other option is to create a dis...more >>

Hello, Anybody know where the Data Access Application Block is located on the MSDN site? The Data Access and Storage Developer Center is located here: http://msdn.microsoft.com/data/default.aspx On that page is a link to the app block, but clicking it redirects to MSDN's 404 error page. ...more >>

I have a dataset with data retrieved from an Access2K database and I am trying to change the MaxLength property of one of the text fields. The code executes fine (e.g. myDataset.Tables(0).Columns(x).MaxLength = 50), but the value of MaxLength doesn't change! Can anyone explain why this is happe...more >>

I have a stored procedure that has a couple of DateTime parameters that are used to update nullable DateTime columns in one of my tables. When I call the stored procedure using ADO.NET in C# from an OdbcCommand object and attempt to set the DateTime parameters to null, I am getting the foll...more >>

Greetings! My application uses a simple source control system implemented in SQL Server 2000. The file is contained in an image field in a table. When a user wants to edit the file, the a new file is created on the user's hard drive using data from the image, and a foreign key into the users...more >>

Hi, I have a question about inserting records into Multiple tables in both a dataset and database. Currently I have a dataset created from a database with 3 tables. The Database (ClientName) generates the ClientID and the other two tables (Address, Misc) have ClientID as their primary k...more >>

My app running under iis was experiencing crashes when I started using ODP.NET 9.2.0.4.01, with the Oracle client 9.2.0.1.0 to replace legacy ADO calls. (I also tried with the new 10 client and ODP.NET 10 with the same behavior). After a couple of weeks of painfully unfruitfull debugging and hel...more >>

I need to write the contents of a dataset to a comma delimited csv file that includes the field names? Does anyone have a sample of how to do this? Thanks...more >>

While using the DataView.RowFilter, if the RowFilter is set to an integer value, say: c# MyValue = 123; dataview.RowFilter = "MyField = " + MyValue; vb MyValue = 123 DV.RowFilter = "MyField = " + MyValue Any of the preceding code throws a Missing operand after '=' operator error. ...more >>

My application uses ADO .NET to access SQL Server and when running on my development machine will throw a SqlException if I try to do something bad (e.g. SELECT from a table that does not exist). However, when running the same application on another machine, although a SqlException does see...more >>

Hi First of all, sorry for my english if is not very well, I am spanish. My problem is these: I have an DataSet1.xsd, contain two tables, one is "order" and the other is "order_detail" and between this tables exist one relation, one to many, if I want to import the information of one tabl...more >>

When using SqlCommandBuilder, if one of the columns, of the subject table referenced in the SELECT query, has a column name that is an T-SQL reserved word, such as User, the T-SQL command text for the adapter will be incorrect and an SqlException will be thrown. This is because the comman...more >>

In my vb.net module, I used the script to generate a client side javascript function. as Private Sub disablePostedFileInout(ByVal n As Integer) Dim jScript As String jScript = "<script language='javascript'>" jScript = jScript & " function disableInput(" & n & " ...more >>

Hi, I need to add a datacolumn into a datatable which points to another datacolumn in another datatable. I have come across this article but forget from where. Anyone help would be very appreciated. Thanks in advance....more >>

Hi I have complicated select query how to get prior number of records returned from this query. One number, to decide if records should be loaded. Thanks Konrad ...more >>

I'm trying to open an Access database using OleDb. The database opens fine, but when I try to open the database using a workgroup file with a name and password, I always get the same error: "Cannot start your application. The workgroup information file is missing or opened exclusively ...more >>

Hi, I get a "Data type mismatch in criteria expression" error when attempting to write to an Access database in my C#.NET Windows Forms application. This only occurs when the OS regional settings are set to French. When they are set to English, the write query works fine. I use System.Da...more >>

Hi to all I have a data set "dsTest" with one table "Sample" having next fields: ID1 int (primary key) Name string ID2 int. I created a recursive relationship between ID1 and ID2, named "SampleRel". The problem is the depth of relationship. This relationship...more >>

Here's my simple stored procedure: ALTER PROCEDURE GetMemberIDByEmail @Email EmailAddress, @ID int OUTPUT AS SELECT @ID = ID FROM tbl_Member WHERE Email=@Email RETURN Here's my C# code (using Microsoft Data public int GetMemberIdByEmail(string email) { SqlParameter[] ar...more >>

Hi, I got a problem updating MDB file thru ASPX. error : "System.Data.OleDb.OleDbException: Operation must use an updateable query." I update it with this way : (when I updated data in datagrid everything is perfect) dbconn = New OleDbConnection(ConfigurationSettings.AppSettings("cn"...more >>

I have an expression DataColumn which combines "First Name" + "Last Name" to display in the list box to select the name, who's record comes up. But when I use the daDataAdapter.Update(dsDataSet, tblTableName); It gives me an exception saying cannot update readonly expression type. How d...more >>

Hello all, I have an ASP.net page that uses an "asp:DataGrid" tag that is populated by a System.Data.DataSet object. Data is sorted via a "sort_value" field in the SQL table. Until now, this page has just been for the display of data. Data entry is handled via a separate system. Now...more >>

Hi, Does anyone know how to control another program that is running? Eg: I would like to control the outlook express and tells it to minimize. Thanks. ...more >>

Hello Few things to remove the cloud: 1) Can a DataView be a subset of a DataSet ? 2) DataSet consists of tables, is that different from a DataTable object ? 3) In IDE, when you create a DataSet it also generates update, add, delete code, if you have controls bound to the DataView (whic...more >>

I have column color, which describes color of something ..Ths paramete I use to set color of some windows forms, which willr epresents data in records... what is the simplest way to storare inforamations about colors in database ?? ...more >>

The application is developed in ASP.Net with a SQL Server database. Essentially, the application uses a single shared Connection object for all users logged into the system. The connection object is opened/closed for each transaction. The error - System.IndexOutOfRangeException: Cannot find...more >>

Why do I get the following error message. If I click on a datagrid after clicking addnew, an unhandled exception has occured in your application. If you click continue, the application will ignore this error and attempt to continue. If you click quit, the aplication will be shut down immed...more >>

Hi I have the block of code below which is supposed to determine the number of rows affected with an update statement (ASP.Net, Access, C#, ADO.Net, OleDB) to determine if the update was successful or if a concurrency error occurred. There is an enumeration defined called DBResult where 1 is...more >>

Hello, Can you recommend a tool for making XSLT schemas. Let's say I have one XSD scheme, and I want to make another XSD scheme from the scheme 1, containing generally the same elements, but groupped in another way, omitting some fields, adding some others, making attributes from what was elem...more >>

I have SQL parameter that looks like this: cmdUpdate.Parameters.Add ("@invoicedate", SqlDbType.NVarChar, 40).Value = dr["invoice date"].ToString(); IT is updating a field in a SQL2K database. The database field is of type char and not date. The data in dr["invoice date"] looks like th...more >>

Hi there, I just set up my VStudio 2003 and tried to run a test of reading a character from database by using SqlDataReader.GetChar, but it failed. I got the following error message: ----------------------------------------------------------------------------------------------- An unhandled ...more >>

I'm adding a row to a table. The table has some columns with expressions. When I add the row I get an error: Additional information: Cannot perform '-' operation on System.String and System.String. Now the catch is I ONLY get this error when I call my server via remoting. If I call the same s...more >>

Can't add more than one row to table I am attaching a sample application The schema is based upon Chapter 13 of ADO.NET Core reference. It uses a currency manager for it's binding context. Here is the problem. The first form that opens includes a listbox of authors. There is a button...more >>

I'm using this code in VS .NET 2003 [code] Me.SqlCmd_BlacklistUpdateStatus.CommandText = "dbo.[SpamUpdateReport_blacklist]" Me.SqlCmd_BlacklistUpdateStatus.CommandType = System.Data.CommandType.StoredProcedure Me.SqlCmd_BlacklistUpdateStatus.Connection = Me.cn2 Me.SqlCmd_BlacklistUpdate...more >>

Hi, I use OleDbCommand to insert a new row to Access database. We reuse = instance of OleDbCommand more than one times.=20 =20 example: - The value of the first record is QueryID =3D 1 and = BooleanOperator =3D "And"; Add to database correctly; - The value of the...more >>

Hi, SqlCommand cmd = new SqlCommand("my_storedprocedure",con); cmd.CommandType = CommandType.StoredProcedure; The error is : type or namespace name 'CommandType' could not be found(are you missing a using directive or an assembly reference) I have included the following namespaces u...more >>

I am using ForeignKeyConstraints so that when I change a parent row's key, the child rows are updated with the appropriate key. The problem that I am running into is that I would like to be able to add a row to a table with a value that would not fit a stated constraint. So, I could add a ...more >>

Hi! I am trying to improve the speed of the app. Can you tell me if i need to use AddWithKey or not? Thanks. if (base.OpenDB() != System.Data.ConnectionState.Open) { throw new Exception("Unable to open DB connection!"); } string sSQL = "SELECT * FROM PROCESSCONTROLVIEW WHERE GROUP_ID = '...more >>

I am having an OleDBDataAdapter and a dataset. I fill the dataset with a row and execute Adapter.update(dataset,"Table Name"); Adapter.fill(dataset,"Table Name"); For the database table, my primary key is an auto number. Currently, I am fetching the key using: dataset.Tables["Table Nam...more >>

Hello, I've created a Dataset in code on my form based on an OLEDB provider also created in code. I want to be able to use this dataset in a Crystal Report, but the dataset is not listed in the report designer? I'm not sure how to resolve this problem, any ideas are helpfull. Thank yo...more >>

I have developed my web module project at my test machine under a different web path ex. c:\inetput\wwwroot\myProject and tested it. After it work find there I coped it to my real web site under the d:\inetput\wwwroot\script\myProject. How can I continue the develop the project under the n...more >>

We have a production web site that's data intensive (save user input to DB and query for displaying) with the ASP.NET app part on one W2K server and SQL 2000 DB on another W2K server. I have set up performance logs to log # of pooled database connections on the web server every 60 seconds (.NET ...more >>

I have a large SP that has various print messages throughout. I want to view these print messages from .Net. As such I wire up an infoMessage event handler to the connection. If executed using executeNonQuery it will return all messages fine. Using executeScalar, I only ever get the first ...more >>

Hello, I have a made client application that adds records to a database on a domain. Every now and then the database will create duplicate records. I have closely checked the code and have not seen anyreason for this to be. I am using parameters and using ExecuteNonQuery to update the da...more >>