Hi, I'm thinking of using transaction in my application but I'm not familiar in this area. There is a question I would like to ask. How to I specify a transaction that I can set the isolation Level & the locking hints for that particular transaction.. Regards Vanessa ...more >>

I have a dataset that has two columns I need to format one has just the date the other has just the time but when I bind the dataset to the datagrid it show both date and time for both fields in the property builder box I see a text box that is call data formatting expression can someone give me...more >>

Just installed MSDE from the .NET SDK. Am used to using SQL2K at work so am hunting around for the SA password settings. is there such a thing in MSDE? Can someone give me a very brief (I speak the lingo :) guide to MSDE please? Is there an SA password? If so, where do I set/change it? I'm gues...more >>

This sql statement against an access database is not working in vb.net but works in query analyzer when I sample it against a SQL table. Maybe you guys know what I am doing wrong........ sql3 = "SELECT from CUSTOMERS WHERE CustShipTo = (select max(CustShipTo) from customers where CustNumber = ...more >>

I have discovered a major problem with the OraClient library. The problem is easily reproduced in the following manner. I am hoping Microsoft folks read this. Say, for instance I have a table (Customers) consisting of CustomerName and CustomerState: CustomerName CustomerState ------...more >>

Hi, You can use MS Access (from 2000 upwards) to manage databases in MSDE. You can use your VS.NET IDE to do the same. The enterprise manager works fine on MSDE too! Just check regarding licensing-issues but if you are working on your company-pc you should be safe. However, some things ...more >>

Is there an easy way to avoid the '#agg' columns and preserve the original column order when writing an XML file? ds.writexml("myFile.xml") I want to import it into Excel and not have the extra #agg columns and not have the columns sorted alphabetically. Thanks for any assistance. ...more >>

Hi, i had develope asp.net using the webservice as the input point for processing. in the webservice, i had use the threading process the request. this is very data intensive process using sql server 2000 standard edition in the production server with .Net framework 1.0 SP2. i notice that whe...more >>

Hi, I am using .NET Provider for Oracle, .NET Framework 1.1 to connect to Oracle 9i database instance. I am using the OracleCommandBuilder.DeriveParameters to get the parameters for a given stored procedure. For some stored procedures, I get the OracleParameter[] with the same parameter...more >>

Hi, I'm pretty new to .NET, and even more new to Web Services. I've written a few stand-alone apps that successfully interact with a database, though, and I'm now puzzled. I have a web service running on my machine (for now) and a Windows app that calls a WebMethod from that service. W...more >>

Hi, I have an access database with around 500k records. I have C++.Net code that does the normal ado.net thing: 1) open connection 2) attach adapter with sql select statement 3) fill dataset 4) loop through all rows in dataset, modify each row as desired 5) fill in the update sql sta...more >>

Does anyone know of any good online examples of using DataAdapter.Update when your dataset operations are not the "trival" case where SELECT, INSERT, UPDATE and DELETE are applied to all tables in a typed dataset? Say for example your typed dataset has two tables "First" and "Second". Yo...more >>

Greetings all, I am (was, rather -- I have since went the route of containment to implement the pattern) trying to inherit DataTable to construct a Lazy Load patterned table for large result sets. However, I kept getting an error when adding new rows... exceptions were thrown declaring the ...more >>

In our project we need to get data from a database and return it, or cache it and return it later. We might also get the data from a web service instead of a database. Question, is DataSet the best option for retrieving data from a database. Between DataSet and DOM which will be faster fo...more >>

ODBC includes numerous scalar functions and calls such as SQLGetInfo that allow an application to generate SQL that works regardless of the targetted back-end database (within reason). Is there any equivalent of this in ADO. How do you generate database independent SQL in ADO? Tom ...more >>

Greetings, I'm developing database applications using C# on VS.NET 2003 and SQL Server Standard edition (SP3a), and the Microsoft Data Application Blocks. I've run into a situation I'm trying to understand, to wit, if I submit a query using SqlHelper.ExecuteScalar which returns no result...more >>

Hello! After I've finished using an instance of the SqlCommand class, should I then invoke Dispose() on the instance. I suppose so, as there is a Dispose method, but what does it actually release? I would basically prefer to skip invoking Dispose() as this will free me from determining when...more >>

I need to access field properties like datatype and datalength. Could someone point me in the right direction. At least some good search parameters. I've looked an only come up with articles on visual designers, not programmatic access. Thanks, Andy :) ...more >>

Hi When connecting with SqlClient to an SQL Server 2000, there will be thrown SqlExceptions with an Errors collection in it returning SqlError class. The VS.NET help on SqlError.Number says "This number corresponds to an entry in the master.dbo.sysmessages table.", but I'm getting -2 for A...more >>

I want to create a filter on a DataView for a time column. I have a column called StartTime in a SQL Server database which is defined as a DateTime column but it only contains times. I want to find all rows which are after 12:00:00 so I write the following line:- DataView dataView = new DataVi...more >>

Hi, Is there a simple way to encrypt all communication between a SQL Server 2000 and a .net application? What is the best practice in this case? Thanks /Johan ...more >>

I'm facing a problem while updating a ADO recordset after modifying its records using the Dataset( ADO.Net). I'm calling a method of a COM component from C# code. The method returns a disconnected ADO recordset object which I use to fill the Dataset using the OleDbDataAdapter.Fill() meth...more >>

I have classes in a data access layer that have methods that open a SqlConnection, create a SqlCommand object, ExecuteNonQuery, and then close the SqlConnection. Now, I need to implement transactions accross several of these method calls. Can I do that if the SqlConnection is closed at the end...more >>

Hi- I'm getting the following error when I run the duwamish.msi installer included with VS .NET 2003: "You must install the Microsoft .NET Framework SDK v1.0.3705 before running Duwamish 7.0(C#)" Does this literally mean I have to backrev to the old SDK? I've looked all over the newsgr...more >>

Hello. I have One problem. Whan I make database program in Visual Basic 6 which has some Forms. I make Dataenvironment. There I make connection to my database. In command I select table or write SQL comand.And Now I can acces to this tabel/ created new table with SQL command/. Such that, when...more >>

Hello All, I have had this problem many times. Most of the times I have blindly added all possible permissions combinations untill it got solved (many times I just added asp.net account to the administrator groups). But this time I am working on a server machine and therefore I cannot add a...more >>