Hi, I need to export the contents of a DataTable in a Dataset to a text file in a particual row order. I guess I need to use the DefaultDavaView but I think I am doing something wrong since traversing the rows in the table doesn't show them in the correct order. Thanks Jeronimo Bertr...more >>

Dear All, i have establish a connection to Oracle 10g using ODP.net , i could populate data in a listbox/combo box, but i need to display these data in one by one , i mean navigation using |< < > >| these buttons , plshelp me blw is the code i'm using to populate data in c...more >>

Hi, The Asc or Desc functions work well on the sql server, but when I try to use the parameters collection through ASP.NEt . The SQL statements doesn't execute the same way. Ex: I'm trying to sort months say as 1-Jan,2-Feb etc. on ASP page I get is as 1 Apr, 8 Aug etc. The sql stmt ends ass O...more >>

In the UI, there are some optional field but in the DB I want tto store NULL instead of empty string. Do I check for empty string for these values in the business layer when I am going thru each row in the datatable for Data Validation. Thanks...more >>

I am creating a web service that returns data from an Access 2000 database using VS2005. The Access database is located on a different server than where the web service is running. The Access database is also opened by a different desktop application running on various workstations on the ...more >>

I use a data adapter to fill a DataTable (that contains no row or columns) with data from a table in my SQL Server Express database. The columns that the DataAdapter creates in my DataTable all have the correct datatype but each is created so that AllowDBNull = True. However, the table in t...more >>

Is there any possible way to upload a file into an image field in SQL Server asynchronously? Our users upload a lot of large files into a SQL Server, and we have no way of showing them progress. ADO had an "AppendChunk" method, but it doesn't look like .Net has anything similar. This seems l...more >>

Hello I have two tables that do not belong to DataSet. They are individual. Is it posible to create DataRelation Or ForeignKey in this situation? I tried but on: childTable.ParentRelation.Add(dataRelation) got Null Exception. Thanks Milan...more >>

We are encountering an extremely odd issue. We process incoming files for customers and output text files to produce printed material. Then an XML file containing the fields of the original file along with all fields necessary to produce the output text files are saved as an XML file. If an i...more >>

All, I'm trying to create a DataReader Function to call from within my class to open a simple datareader. I have thoroughly read the Data Access Patterns and practices and do not believe in using canned code right off the bat. I want to rebuild the canned code so I understand it, then I...more >>

Hi, can anyone help me with the following. MS Access 2002 database, Northwind, Customer table. In VB.NET using a datagrid and a dataset to fill the datagrid. I'm trying to insert, update and delete records in the datagrid. Inserts and deletes are working fine, but the updates are failing and I ...more >>

Hi all, I'm new to .NET but have quite a long experience as OO developer. I've been reading lots of documentation in order to get started with the SDK. First I started with on-line documentation about ADO.NET and now I am actually using the Microsoft Patterns and Practices document "Desig...more >>

Dear All, i have establish a connection to Oracle 10g using ODP.net , i could populate data in a listbox/combo box, but i need to display these data in one by one , i mean navigation using |< < > >| these buttons , plshelp me blw is the code i'm using to populate data in combo/list ...more >>

Hi, When I go to Add New item->Sql database-> click ADD i get the following error.I also get the same error when i open the security page on web site admininstration tool. "There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by ins...more >>

I use the code below to detach a Database, but if the database does not exist, it will thow exception. How can I determinate if the Database exist before detach it? *********************************************************************** string sConnection = "Data Source=.........more >>

I built a dataset with 11 tables and their relationships using the data set builder. I removed all the table adapters: the intention is to use the Enterprise Library to load the data, and to do the updates. That side of things works fine. The plan is to use ObjectDataSource to bind web cont...more >>

Dear all, I have a strange behaviour when updating a grid. I will try to explain clearly: I have a CustDataSet object fill with customer information like Name, Firstname, Country, adress That Custdataset contains all my customer information. Then I have a web page on which my user can ...more >>

My code: Dim IP As String IP = "192.168.0.169" SqlConnection1.ConnectionString = "workstation id=xxxxx;integrated security=SSPI;Data Source=" & IP & ";persist security info=False;initial catalog=adp1SQL" The error occurs when I use the IP address instead "ms...more >>

I have an intermittent error where I get the following exception: "Error: Concurrency violation: the UpdateCommand affected 0 records." Here are the steps I follow: Create SQLConnection Set connection string of the connection. Open connection Create SQL Data Adapter with the connection and a...more >>

In vb.net 1.1 I could do this: Dim ds As dsEquip = GetDataset() Dim dr As dsEquip.tbEquipRow For Each dr In ds.tbEquip.Rows 'Do something Next now in c# 2.0 I'm trying to do the same thing like this: dsEquip ds = oData.PersonGetRecShort(); foreach (dsEquip.tbEquipRow dr in (dsEqu...more >>

Hello I've experienced a very low speed filling DataSet in program running on PocketPC and connected to SQL Server via Wireles Lan. I used SqlDataAdapter. Table basically consists of text fields of type nvarchar and has about 6000 rows. It takes about 5 minutes to fill DataSet using SqlDataAd...more >>

Hi, I have an ASP.NET app that uses ADO.NET for data access. I have a form that allows a user to enter a date. This date field is not required however. If they don't enter it, I shove a variable declared of type System.DateTime that is initialized to null into the database. It works but i...more >>

im trying to put a transaction around my NUnit tests fixtures and a seperate transaction around each test and I'm trying to do that in my base class so that all my test can benefit from them. The problem is that I can't find a way to do both transactions. it's either around the whole fixtu...more >>

I have two datatables in a dataset with a relation defined. How do I generate a JOINed view of this data? Thanks, MS ...more >>

I get an e-mail in C# I want to store this e-mail item in SQL Server 2005. I don't have any hardcopy of this mail item. I only have a programmatic C# object, and i wish to insert it into a varbinary field. How can i convert this object to a suitable form to insert to db?...more >>

Hello, I have sql command like: "Select... Where myColumn = @myParameter" Now, I can simply add parameter to the collection and filter data. What if I want to return not filtered data, I mean to skip, avoid executing this "myColumn = @myParameter"?! Is this possible, or I have to change s...more >>

Dear all, I have a dataset object which as been filled from an SQL server table I have then a dataview from that dataset,which is bind to a datagrid object. My user can edit, update, delete entry directly from that datagrid through an ASP page. Is there a simple way to automatically hand...more >>

Hello, I'm very excited about the new SqlDataSource in asp.net 2.0. I have written a wuite long sql script on my SqlDatasource UpdateCommand. I want to see wheater it actually does what it was meant to do. Is there any way i can do this? Many thanks JJ ...more >>

Hello, To my amazement I cannot connect to a SQL 2005 Express over a network share. Now reading through the newsgroups I can understand why this can be a problem BUT... HOW does one go about having two PCs read/write data to a centralized SQL 2005 Express Database? Any help would be GREA...more >>

Hi, Thinking of the best way to develop a data acces layer for a new program I have been doing some performance test. My lab pilot is as follows: SqlServer 2000 + VS2005 TS in the same machine. Storage procedure returning 100.000 records from a table -------------------------...more >>

I need to create new Excel 2003 XLS files containing a single worksheet that has the results of a database query (a combination of text, integer, and date columns). Can someone please point me to an example of how to do this in a VB2005/ADO.NET 2.0 Winforms app, *WITHOUT* using Interop (Offic...more >>

I'm getting an exception message using EnterpriseLibrary.Data block. In the profiler I can see that the sql i fired in the sql database. Imports Microsoft.Practices.EnterpriseLibrary.Data Dim db As Database = DatabaseFactory.CreateDatabase Dim cmd As DBCommandWrapper = db.GetSqlStringComma...more >>

After four long hours of googling on the subject and finding almost nothing, I'm forced to post this one. I'm doing a small project that reads several IIS and stores in a database the domains hosted there. This application runs quite fine. But I'd like to add some transaction control on it,...more >>

How do i perform intersection in 2 datasets having a same col. *** Sent via Developersdex http://www.developersdex.com ***...more >>

Hi. I have a quick question. I am trying to create a quick data access layer for command CRUD tasks using stored procedures. My question is more of a design point of view. In each of my methods Create, Read, Update, and Delete, it seems I am repeating a lot of code such as: <Code> // Cre...more >>

VS 2005, VB, .Net Frameword 2.0, Oracle 9i Database, System.Data.OracleClient I am trying to insert documents (word, pdf, images) into a BLOB data column in an Oracle 9i database using the System.Data.OracleClient. I have permissions on the database and the connection works to retrieve record...more >>

Hi folks, I am looking for a solution of an "simple" problem, but I dont found it. I have a dataset with to tabels on it. On a Form i have a lot of TextBoxes to display the data from two database tables. The databinding of the TextBoxes is linked to two BindingSource-Objects (.NET 2.0). ...more >>

Hi, in my current project I need to record audio data analyse them and store everything in some sort of database. I have not much experience with databases except for some small tests with ADO and MS Access, MySql and Paradox. The goal is to record sample files for test speakers and sto...more >>

Dear all, Does the way of creating a datarelation between a parent and a child based on more that one column , is going to create a FK first ?? thnaks regards serge...more >>

Hi, Im using Visual Studio 2005 and playing around with all the new ADO .Net 2.0 features, I am hoping that what I am chasing is now available. I am wanting to display an updatable row (don't need insert or delete) which displays columns from two tables which have a one to one relationship. T...more >>

Can anybody tell me how SqlDataReader and OracleDataReader process the encoding of contents from database when it's GetString(or GetSqlString,GetOracleString) method is called? I have been annoyed on this issue for several days and searched many materials but no help. -- Zhou Peng...more >>

Hi, I'm trying to make a new connection to a external database, it's not local, so what is the direction I must write to connect to it? It is the www... or I must write the IP of the server where it is stored? Thanks! Ángel ...more >>

Dear all, Is there any restriction or rules when you must you Store procedure call within application code compare to direct SQL statement. For sure the first reason is data security as all querry are executed on the server. But is there some cases where store procedure should be avoid ...more >>

I have a stored procedure that adds a new record in the database and have another SP that updates a record. I used to call ExecuteNonQuery method on command object and it used to return 1 if method executed sucessfully. This was all fine and dandy in .Net1.1 Now in .Net 2.0 I use the same c...more >>

I have a pretty simple block of code here that won't work. I've looped through the rows, and reviewed the values and the dataset values change fine but it's not updating to the database and doesn't throw an exception. Has anyone run into this before? sql = "SELECT * FROM INVENTORY WHERE I...more >>

Hi everybody, I have a column in one of tables in one of the sql server that has a data type of UniqueIdentifier. Now, I am supplying a value to used this column as filter to get specific record. Note: strCompId is in string datatype. [code] adoOleDbDataAdapter2.SelectCommand.Para...more >>

Hi If you save a Dataset, which order must you do the operations in? I think its 1) Update 2) Delete 3) Add Or does the order matter? Vayse ...more >>

This is completely baffling me and I'm hoping someone can help me understand why this doesn't work. I'm updating existing rows in a MS SQL table by reading them into a datatable, modifying the values then updating the database using the update method of SqlDataAdapter. If I set a value of a f...more >>

I get an error when I try to execute the following code using ADO.Net in VB.Net: conn.open sqlString="CREATE LOGIN test WITH PASSWORD = '1qaz2wsx'" command=new SqlCommand(sqlString) command.connection = conn command.ExecuteNonQuery() The error occurs when executing the ExecuteNonQuery lin...more >>

hey doods and doodettes. I am having severe memory issues when opening Datasets in .net 2.0. A web-based app will cause the worker process to recycle on a heavy-duty server after just a few client connections, and a windows app will bring the machine to a crawl. My testing code is as foll...more >>