You searched for the word(s): userid:754703

More Search Options

RSS Available

• Oracle ORA-12154 TNS Could Not Resolve Service Name

  I have an application that works great locally. When we moved it to our test server (running Windows 2003, .NET 3.5, Oracle 9i Client 9.2.0.7.0) it returns the stack trace below. I have used TNSPING to test the connection string and it is working fine. I can connect to the database using TOAD for Oracle Freeware version. Oracle 9i Client is the only version of the Oracle software installed. I have tried restarting the server. Any one able to provide some possible solutions? Unknown Error System.Data

  Posted to Oracle (Forum) by ddelella on 11/19/2009

• Re: Oracle ORA-12154 TNS Could Not Resolve Service Name

  The first link assumes I have 10g installed and I do not. The second link showed me one or two minor issues with the sqlnames.ora file but none of the fixes caused the application to work. I am still at a stand still. SQL*Plus, TOAD for Oracle, TNSPING, and regular ping on the database server address are all working. Just the application is failing. The old version of the application is even running. Heres another topper. I installed VB.Net Express on the same machine copied the source code over

  Posted to Oracle (Forum) by ddelella on 11/19/2009

• Re: DataAdapter.Fill Returning 0 For DbNull Integers

  I checked with the dbadmin and for some reason he was doing a ISNULL(..., 0) call in the stored procedure. I have asked him to remove these for proper value display. ...and to answer the other replay. The reason you should not return a value like -1 or any other idicator for a blank value is that integers can be both positive and negative. Returning a negative assumes that the field can only take positive values which is not always the case. Visual Studio has the IsDbNull(...) check to help make

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ddelella on 11/16/2009

• DataAdapter.Fill Returning 0 For DbNull Integers

  I have a simple command which gathers data on a certain project. I just added 4 new integer field which ARE nullable in the database. I have tested saving the page with null values and the database still shows NULL in the database. However, when I pull the data down using the .Fill method the column containing the data has a 0 instead of a DbNull value. Any ideas? Dim myAdapter As New SqlDataAdapter(myCommand) Dim myDataSet As New DataSet myAdapter.Fill(myDataSet, "Projects")

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ddelella on 11/12/2009

• Re: GridView Save OnActiveTabChanged

  This would work but I can not find a spot to save the values in the old fields. The only function used to detect the changing tabs is OnActiveTabChanged which does not contain the original values anymore. This method is only activated after the callback. Without adding a save button I do not see any method which is called before the postback or a way to access the old data before the postback to save it.

  Posted to Data Presentation Controls (Forum) by ddelella on 11/2/2009

• Re: GridView Save OnActiveTabChanged

  I stumbled on a workable but not optimal solution. I added Autopostbacks to the GridView and wrapped it in an UpdatePanel. These fire Async post backs which update the DataTable which is populating the GridView. The DataTable is stored in the session and therefore the information for the GridView is maintained on tab changing. There is minimal latency needed to do the DataTable change so this solution should work.

  Posted to Data Presentation Controls (Forum) by ddelella on 11/2/2009

• Re: GridView Save OnActiveTabChanged

  A page contains a AJAX TabContainer. There are two tabs. In tab 1 is a GridView control. The grid has a list of countries, a template column with a checkbox, and another template column with a drop down list. The user can check and uncheck the boxes and select an option for any country. There is no EditCommandColumn for the GridView. When I switch to tab two I want to save any of the options change in the Grid on tab 1. That is a slim downed one step at a time version.

  Posted to Data Presentation Controls (Forum) by ddelella on 10/30/2009

• GridView Save OnActiveTabChanged

  I have a page with at least 6 tabs in a TabContainer control using AJAX. I already enabled post backs when switching tabs so I could use the OnActiveTabChanged method. In this method I am trying to save the data on the tab I am leaving and call a public load function in the user control for the tab I am loading. Each tab is a user control with a load and save public commands. I am running into the typical postback issue of loosing data on the currently loaded tab when the postback occurs. In particular

  Posted to Data Presentation Controls (Forum) by ddelella on 10/29/2009

• Re: Modal Window Data Collection For GridView

  I did not see anything on that page for new data row collection and then adding to the gridview without a refresh. I did find a nice AJAX loading screen using modal windows which I was looking for. Thanks

  Posted to ASP.NET AJAX UI (Forum) by ddelella on 10/28/2009

• Modal Window Data Collection For GridView

  I have a GridView control which list a country name, has a drop down for a selected reason, and a check box column. I want to be able to dynamically add new countries. For purely UI reasons I would like to have an add button below the grid and when clicked it opens a modal window. Once the countries are selected to add the user hits okay and the grid is updated. I was looking for a way to handle this without the postback from the ok button in the modal window? Any suggestions on how to achieve this

  Posted to ASP.NET AJAX UI (Forum) by ddelella on 10/27/2009