Rowstate of a row is deleted.. However, just before doing an update against the dataset I'd like to retrieve some values out of the "deleted" row.. Is is possible? Giri ...more >>

I have a Win forms application using version 1.1 that a client has installed on a "network drive". The application connects with a SQL Server 2000 database using the Microsoft .NET Framework 1.1 Data Provider for SQL Server. The client's users map to the network drive and run the application ...more >>

I have a dataset that includes a data table, Item, that has a LocationID field on it. In the stored procedure I use to generate this dataset, I include a Join on my Location table so that the Item table includes fields like LocationName, LocationType, LocationSize, etc. for ease of display (I'm ...more >>

I have two stored procedures in an MS SQL Server 2000 database. Internally, each stored procedure performs an insert operation and then returns a table with some return message info (identity column, etc). I use the OleDb provider to normally execute the stored procs. I use OleDb becau...more >>

USING VS 2003 vb.net MSDE... I have a table with a boolean (bit) data type that I use as an index (table, etc., created via Server Explorer). When I go to the tables property pages, Index tab, this bit column does not show up in the drop down list of columns to create a new index on it. Is...more >>

If you have a data set, and it has a table which was created using the fillschema method of the dataadapter. Do you have to clear the data table each time you refill it? At first I thought you had to preform a clear each time (by the way my table does have primary keys and is an auto increment pk...more >>

In our new .NET web applications, we try to limit the use of SqlConnection to just one instance per page, even if there are multiple accesses to various queries. The thinking behind is that this reduces the need to getting and returning connections to the pool repeatedly if a page has multiple ...more >>

I have a question about the DataSets/Tables Visual Studio .NET generates for you when dragging stored procs/tables from the Server Explorer. The DataSet and DataTable classes created for you have constructors with an access level of internal (friend in VB.NET). Can anyone tell me why? To me, you...more >>

Hi, I've written a Stored procedure that return 3 different tables. Something like: Select * from A; Select * from B; Select * from C; But when I try to retrive the datas in a dataset, only the first table is filled. The code I use is like this DataSet ds = new DataSet(); OleDbDataAd...more >>

Hello, I create a DataSet with 7 empty DataTables - no rows. I then create 7 "stand-alone" DataTables with same schema - and same tablename - as the ones in the DS, and query the data source, filling each DT individually. At this point if I merge the stand-alone DTs into the "empty" DS it...more >>

Hi, I keep getting this error intermittently. I can compile many times, and run fine, and then one compile/run of it, out of nowhere I get this. If I restart the computer it fixes it, but it seems awfully weird. Any ideas? Server Error in '/intranet' Application. ----------------------------...more >>

Hi, I am working with a set of data which is displayed on the screen. The problem is that it is in a datatable in a dataset. I need to know when a row was added or removed from that datatable inorder to redraw the text to match it correctly. I am trying to do this in visual basic.net right now...more >>

Due to security reasons, I need to persist DataSet's as encrypted files on Tablet PC's. Does anyone know of some useful information on how to do this? (Or should I use MSDE instead?) ...more >>

Hello. I need some suggestions regarding an application that I'm working on. = The requirements/design spec. indicate that the application needs a = separate data access layer, but I'd also like to use the data access = application block. We'll be using SQL Server only as the provider. So, ...more >>

Hello! Yesterday I asked some basics about inserting data. Subject was 'Newbie question about inserting data'. Anyway I need something more today :) I wondering how should I do following... Application has two forms: Form1 for inserting master table rows, and Form2 for inserting for examp...more >>

Hello, I have an MDI Parent with a lot of childs. Each child uses the same DataSet (Schema) but with an new instance on every form. The child forms contain different grids, combo boxes, textboxes which are bounded to the DataSet. My question is: How can I use the VisualStudio.NET 2003 D...more >>

How I can traduce this sentences, thanks. Dim drowSession As DataRow drowSession = Context.Cache("SessionKeys ").NewRow() drowSession("session_key ") = "323223" Context.Cache("SessionKeys ").Rows.Add(drowSession) strMatch = "session_key='323223'" arrSessions = Context.Cache("SessionKeys ")...more >>

I am having some serious performance problems resulting from too many round trips on the wire in order to populate several tables in an ADO.NET DataSet. I would like to make ONE stored procedure call that will return all of the table data. (I am using SQL Server 2000) If this is doable, does a...more >>

Hey First of all, this is technically a re-post -- so, sorry to those who don't like re-posts My issue is basically this. I have an ODBC connection to a dBase IV database. Everything seems to be working fine except for an issue with the ODBCDataReader. Whenever I call <ODBCDataReader>.Item(<f...more >>

hi, I am attempting to update two databases simultaneously, from one ASP.NET Web Application, which is written in C#. One database is local i.e. on my localhost IIS and this has no problems at all. I uploaded the same database file to my web server and I am having problems trying to connect...more >>

Hello all - I'm at wits end with this problem that I'm trying to figure out and I was hoping someone could help me who is more of an expert than I am. I have 2 separate datasets that come from separate databases that I merge together into 1 dataset. First when they are set up in their own datase...more >>

How do you invoke the Data Link Properties dialog for an SqlConnection connection string? I need to be able to allow my users to build connection strings for Sql Server ADO.NET provider using the Data Link Properties dialog, like the IDE does when you select "New Connection..." in the ...more >>

H How do I add a new row via dataset I have a dataset which I populate it's data by myself, and I'm not use DataAdapter May be I have to to use an DataAdapter that return no rows, but builds the dataset for me, and then Usa the update of dataAdaper If it's true, how do I do it thank ...more >>

I have a dataset that filled by me via datatables, and data rows, and not by dataadaptor How can I associate this table with DB table, in order to insert a new row into the DB ...more >>

How do you invoke the connection string builder (Data Link Properties) dialog box programmatically? I need to be able to allow users to manually build ADO.NET connection strings using the same dialog as the IDE does when you select "New Connection..." in the ConnectionString drop-down in...more >>

I created my sprocs when signed on as sa, so they're owned by dbo. Now, when I want to change my query string to use a special Sql-Server account created just to access this DB, it doesnt have permission to execute the sprocs. Is there a way to change that? I could have sworn I saw one a wh...more >>

Hi there, We are to make the decision on whether to choose .Net or J2EE. One of the questions my clients asked is that, can we use Unix like Solaris as the application server, and Unix database on server side, while the client application is still in .Net? Thanks Jonatha ...more >>

Hi there, We are to make the decision on whether to choose .Net or J2EE. One of the questions my clients asked is that, can we use Unix as the server and use Unix based database on server site, while the client is still use VS.Net stuff Jonathan...more >>

Hello, when I start my ASP.NET application in debug mode and then start a transaction and after some inserts, I stop the debug mode (without committing and without rolling back the transaction), those records still have been inserted into the tables. But as of my understanding they shouldn'...more >>

Hi smart people (if any :-) I just simply want to access a database in asp.net and it simply does not work! In fact the database I want to use is MySQL but when I tried to connect to an Access database the same problem occurred. In the second case in fact, the same code worked in a Windows Applica...more >>