dear all i am new to .net platform. i am working on a project in vb.net now. i plan to use gotdotnet daab version 3 for my DAL.I must have database independence for this project. i am able to retrieve data from the datbase and fill it to a dataset. i have attached this dataset to a data grid ...more >>

Hello, Can we move more than one record in datareader ... or saying it can we directly move to say 10th record in the datareader instead of going from 1 to 10th record using datareader.read() method. Please review... Niraj Ranka ...more >>

Hi, I'm using .NET Framework 1.1 and SQL Server 2000. I have a few "select" stored procedure that each contain a single OUTPUT parameter in addition to the typical return parameter. When I use SqlCommandBuilder.DeriveParameters, to dynamically populate the parameters in my select command, the...more >>

This is taken from autogenerated code. Can somebody explain to me what does this mean? // Create a new dataset to hold the records returned from the call to FillDataSet. // A temporary dataset is used because filling the existing dataset would // require the databindings to be rebound. ...more >>

I've migrated a VB6 program to .NET. The VB program uses ADO (Provider=OraOLEDB.Oracle) and the .NET program uses ADO.NET (same provider). I know that ADO is different from ADO.NET, but I would like to make the .NET program works the same as before (especially performance). In the VB program,...more >>

Hi all, i'm using this code to insert records into an Access table from asp.net, using a stored procedure, called qry_InsertData: PARAMETERS [pID] Long, [pCod] Long, [pCodArt] Text(20), [pQ1] Long, [pDataUscita] DateTime; INSERT INTO Table ( ID, Cod, CodArt, Q1, DataUscita ) VALUES (pID, p...more >>

I got a problem when i transfer data form the dataset to the database, the decimal value are truncated and not rounded. Is there a way to round them automaticly. if not, how can i retrieve the precision of the decimal in the database in dot.net to do the rounding before? thanks ...more >>

Guys, in ASP.NET interfacing to oracle, are there limitations on using SQL and group functions? or even subqueries for that matter? i've tried this several ways, and even just tried using a SQL DISTINCT and i get a "missing expression" error correlated subqueries gets a "missing select" error i...more >>

Hi, I am doing a 3 tier thick client app and use a middle tier to get and put dataset contents. I am using an approach, very similar to many prescribed by Microsoft and in books to create a pseudokey as an identity/autoincrement column with seed and step both -1. Then when database table is...more >>

Hi, I am writing a CMS-System which dynamically loads modules at startup and each module supplies it's Schema in form of a DataSet. The CMS-Core merges all these fragments into one whole DataSet. So far, so good, it all works and all tables are in the dataset. But if I try to persist that s...more >>

Hi there, I'm kind of new with Store Procedures here and I'm trying to do the following; I'm trying to convert the following line of code into a store procedure Me.DA.SelectCommand.CommandText = "SELECT * FROM tbData WHERE ID= " & Me.ID.Value I want to pass the current ID value to th...more >>

Hi everybody, Does anybody know where I can find an example of how to implement a simple data access class ? So that all my database tasks in my application can be isolated to that one class ?. I have written a version , but I want to no what the formal method of doing this is. Please ...more >>

Hi, I'm building a test application I call JukeBox, with an Access DB working with Ole Db. In there I have an Albums table and an Artists table. In the first I have an ArtistID column that points to an ID in the Artists table. Now what I'd like to do would be to have a datagrid that's bound ...more >>

Interesting issue. I can Clear or Reset the dataset or the datatables, but what about clearing dataset tables that will not exist on the first pass? For example, I populate some customer information into ds.Tables("dtCustomers"), but every time a combo event occurs, I want to flush the table...more >>

Hi, I have table in SQL Server with column names "a", "b", "B", "d", "D", .... When I use the SqlDataAdapter .Fill method to create & fill a DataTable with data from that table, the columnnames have changed to "a", "b", "B1", "d", "D1", ... I suppose this has something to do with case se...more >>

I have a terrible problem trapping sqlclient exceptions when filling datatables using stored procedures. I wrote a simple test case that shows filling a dataset throws exceptions fine, but filling a datatable will ignore exceptions. I use the "Ten Most Expensive Products" stored procedure in...more >>

this is a stange place for this request and I apologize. However I asked in both server sql and vs 2005 forums. The frequency of posting is so low it's impossible to carry out a dialog. I have sql 2000 installed. I ran the script for northwind. Didn't seem to be any problems. However, ...more >>