Hi, 1) I am very very new to asp.net. 2) Would appreciate if somebody go give a code example of the OLE db provider connection string for accessing the oracle database My oracle server information is : -------------------------------------------- ==> schema user ID = nmb ...more >>

A few months ago (I'm pretty sure it was Bill Vaughn's article but I can't find it), someone mentioned using Notification services to tell clients that a change had been made. I've been working on this for a while, and I'm convinced it's as doable as it is worth doing. The implementa...more >>

Perhaps this isn't the best venue to vent...but I was just wondering if anyone else has had an experience like my current one. (This does actually relate to ADO.NET - unfortunately) I was working on a project where some consultants from a company who's former initials looked something li...more >>

I have followed carefully the advice given in this forum on how to handle autonumber primary keys in Access, setting AutoIncrement properties on the column and negative seed number and negative increment, as well as backfilling the pkcol in the onRowUpdated event. But I keep getting an erro...more >>

Hi, I am storing the DataTable in a ViewState. ViewState("mydata") = dsRedemption.T_Redemption_Dtl Then I am casting the ViewState into a DataTable variable. Dim x As New DataTable x = CType( ViewState("mydata"), DataTable) This is giving me a error where it's not allowing me to Cas...more >>

I'm trying to implement my own version of a datareader in vb .net using the following example: http://msdn.microsoft.com/library/default.asp? url=/library/en- us/cpguide/html/cpcontemplatedatareadervb.asp I get the following error: 'TestCustomDataReader.CustomSqlDataReader' must imple...more >>

Hi First of all, I am a complete newbie to .net. I am wondering what would be the best way for a pocket pc to get info from a office win2k server machine which is behind ISA server? Assuming that both Pocket PC PDA and the office machine are somehow connected to the internet. My guess is ...more >>

We've got a .NET (WinForms) application that talks to a read-only SQL Server database (it's a reference tool that the user can't modify). On the user's local machine, however, they can store some "favorites" ... these are stored as very simple XML files with the IDs for the widgets they want to s...more >>

Hello, I've been looking into this all day but can find no reference related to this. We have a legacy com object which returns back data from a datasource in an xml format, similar to the following: <rows> <row> <column name="OrderNo" security="0"> <value>1</value...more >>

Hi all i have a table with an autonumber field with a based select , i want to get all the three others commands, my problem is, i have a ds and i want to insert a new row ( my database gives a new id to that row, it the pk ) after i insert the row, i have watched the DS for my ID, and i can...more >>

Hi all i have a problem with my command builder i have made a commandbuild to get the insert, delete and update querys. i´m using a table with a autonumber, so i have fill my dataset with this query select * from test_table1 this table has 3 fields ID ( autonumber) Code( Varchar) Descri...more >>

Hello Everyone, I've got a real general question. I want to create an application with 10 forms and use one dataset to populate various places on different forms. If I fill the dataset on form1 and then the user goes to form2 using form2.ShowDialog, if the dataset is also listed on form...more >>

Hi, I've read loads of posts in here and articles on the internet about this, but for some reason, I just can't get it working. My app needs to read from multiple Excel data sources, and it doesn't know any of the column name or types, only the PrimaryID field name (and the table/worksheet nam...more >>

I have some experience in ADO.NET and none in JDO. The articles on JDO (Java Data Objects - I think) though, seem to suggest that it is a new and the 'best yet' attempt at solving the relational-object mismatch. From what I understand, as developer I would really only work with JDO's and link a...more >>

Is it possible to export a dataset with 2 datatables to a excel workbook and each datatable is populate in different worksheet in excel workbook. If can be done how can I do it or and article or sample on this. thanks. ...more >>

I am looking for some documentation or instruction on how to populate a typed dataset via an associated stored procedure. Here is what I have done... Added a new typed data set via the "Add new item" menu. Dragged a stored procedure from my SQL database to the .xsd dataset form. I wan...more >>

I have a Windows form with several controls on it with those controls being bound to a dataset. If I change the value in one of the textboxes, the value is changed in the dataset. But the HasChanges property of the dataset comes back false and any update using the DataAdapter comes back ...more >>

Hello, I 'm new in aspnet and adonet programming ... does anybody know how to bind a complexe dataset (multi-tables, multi-relations) in different datagrids in web forms? for intance : datagrid1 -> customers, datagrid2 -> products, datagrid3 -> companies (shops) , datagrid4 -> invoices , data...more >>

This is driving me insane, I have looked at examples left and right, and no matter what, I can never get values for my output parameters! I have confirmed that the output parameter is being set properly by SQL Server. Below is the code I have. Can anyone tell me where I might be going wrong? I h...more >>

Hello All, I am using the command.ExecuteNonQuery() method to execute an update statement. I then check the return value to see how many records were affected by the update. This used to work in .NET 1.0, but when we upgraded to .NET 1.1 it now returns -1. Has anyone else experienced t...more >>

Hi I want to execute multiple SQL Server stored procedures in a single batch via ADO so that I can minimize network trips. I need to pass in an array of caommandtype and commandtext objects. What is the best way to do this. Is there an example anywhere on how to do this ? Thanks, Ve...more >>

How can I bind controls on one WinForm to DataSet in another WinForm? How can I make this DataSet available at design time on second WinForm? Dan ...more >>

We try to migrate our ASP appliations to ASP.NET and expereance some strange performance drops when replacing ADO ODBC recordset queries by ADO.NET DataReader Objects. Especialy reading a single row from a large table (> 4.000.000 data rows) by selecting the row using the primary key. It is...more >>

Hello folks, is there a way how I can avoid Null Values in datasets when they are filled with a dataadapter. (Of cours I could change my querey so that no Null values are returned, but I can't do so in my case). I have tryed to set nillable property to false and set a default value, but then a...more >>