Connection String

<add name="DWSTAGE" connectionString="Data Source=(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = ProdServer)&#xA; (PORT = 1521)))(CONNECT_DATA...

I have an app where I keep getting this error.

This is a c# .net 3.5 app running on a windows 2003 server with IIS 6.0 connecting to an Oracle 10g db.

This app had no problems during testing...

Just an update. I bubbled up the events to the page but still was having the same issue.

Because of time constraints I have let go of trying to sync these tables bilaterally and will have them...

@sknake - a little update.

After looking further into my problem I believe this has to do with Itemplate is controlling the events for all the controls that are held in it; this is why the events...

The exception is caused because the test data in the table does not match all the dropdownlist, I don't have any issues with the full dataset.

To re-create

The problem is only with the drop...

I tried one more thing before sending out this copy. I tried to create different event handlers if the field was an ID field or a DESC field but the page still has the same functionality which is...

You don't directly use triggers in a C# app. If you have a trigger on update for the Student table it will be triggered when you send an update statement from your code. If you want the db to do jobs...

@DdoubleD

Thanks for the reply. i added the removal on the eventhandler on Friday because i found a blog with someone who had a similar problem and adding the removal of the eventhandler helped...

I am creating a gridview dynamically using Itemplate but I have run into an issue where the event handlers I create for my drop down boxes in edititem template are accumulating every time it fires. ...

The indexes are maintained so they line up in the drop down lists.

I was thinking about using the selectedindexchanged event handler, now that I set autopostback to true it is firing right away...

Im currently working on a gridview built using Itemplate at runtime.

When in edit mode I use dropdownlists for some of the control fields which are populated from views in my db. The problem I am...

Found my own solution, thanks.

I am just wondering if there is a way to stop my paging images from moving around the gridview footer when using the builtin gridview paging control.

Use double ampersands && in your if statement.

I have been getting the same error as well on an app I am working on.

I have not been able to find much information on the actual problem but my connection is still working and I am receiving...

I think you want to try a query like this


SELECT Count(*) FROM Orders
WHERE signNumber = ?
(AND ? BETWEEN fromdate and todate
Or ? BETWEEN fromdate AND todate)


You need to use the OR...

Query optimization is the process of optimizing the performance of a query to utilize as little system resources as possible.

http://www.samspublishing.com/library/library.asp?b=STY_Csharp_24hours