Search results for query: *

I have a C# Windows Client App which calls the service bus, which in turn interacts with a web service which connects to a SQL Database. I am getting a time out error at the web service level. The database stored proc returns the records in quick time, and if i check the logs in the web service...

I get the following error when i try to access a range in an Excel worksheet: Exception from HRESULT: 0x800A03EC. The code at which it throws the error is: oRange = oSheet.get_Range("NamedRange", Missing.Value).get_Offset(0, 1); I have searched the internet could not find the solution. Please...

I am using Excel Interop to read and write data from/to an Excel Spreadsheet. The first hurdle i have hit is, that i get "Cells were not found error", even though there is data in the spreadsheet. I am using the following at the moment, as a test: oRngLicenceNumbers =...

Am not sure how to approach this so thought would post my thoughts. I have to retrieve this huge piece of information from the database. Basically i need to retrieve time series data for upto 126 ID numbers which will be passed to the database. Initially i thought of passing the whole 126...

I need to populate the spreadsheet by data being returned from the web service. I was thinking of using a COM .Net Add In which calls the web service and populates the spreadsheet. However, there is also information from the spreadsheet which needs to be extracted to be passed as an input...

I am trying to calculate the percentage value. The values for which the percentage needs to be calculated, they are coming from a database, they are coming fine. This is what i am doing: percent = (cCount/totalCount)*100; Although i am getting values for cCount and totalCount, the total...

Could anyone tell me more about working with OpenXML. I have the following XML structure, which will be passed as a parameter to the stored procedure. I have used OpenXML, but none of the records are being inserted. Could anyone suggest anything else. The following is just an example of the...

Any ideas what this error is about. Here we use codesmith to generate all the DAL layers, so manually we do not create any DAL layers at all. Any ideas??

Could anyone explain me how the yield method works?? When we use this method, is it true that we do not need to implement the IEnumerable/IEnumerator interface for that class.

Hi, I will be running an update script on a table on the live database servers. However, this time i thought of writing a script to do the updates, instead of running individual queries. I also want a rollback script. Any ideas how to write a rollback script

I am getting the following error. The dll is registered, i have given full permissions for the IUSR_MachineName. Any ideas why this might not be working. One thing though, on my pc(which where this ASP application is), i also have Visual Studio 2005 installed, hence ran ASP.Net applications...

Anyone ever changed a resource file before. Whenever i try to change it, it is breaking the entire solution. It fails to build.

I am passing a value stored as Real datatype in database(SQL 2005), and passing it onto an external payment site. Now before passing this, i am converting it to a string datatype and replacing the "." by "", because all the information to be sent is combined in a string. However, when it...

Newbie question, how do you set up a stored procedure to run at definite intervals in SQL 2005, basically scheduling it.

I have a windows service in .Net2.0 which calls a webservice which,is used to retrieve a record from the database. However, of late the windows service breaks, saying that there is maximum size for application pool has reached. When i checked the IIS logs, it tells me that the Connection Pool...

I have a windows service in .Net2.0 which calls a webservice which,is used to retrieve a record from the database. However, of late the windows service breaks, saying that there is maximum size for application pool has reached. When i checked the IIS logs, it tells me that the Connection Pool...

Now this integration was already set up before i came into the picture. We are now trying to set it up on staging server linking that with the test HSBC payment site. That seems to be failing. It has the components required installed. Basically my applicaiton just hits the HSBC UAT site and...

When i try to access a url, it is a simple url, no querystring paramaeters or anything, by clicking from a document or from my inbox it redirects itself to the default.aspx page, saying the session has timed out. However, if i access the same page from another page, by clicking on a submit...

When i try to access a url, it is a simple url, no querystring paramaeters or anything, by clicking from a document or from my inbox it redirects itself to the default.aspx page, saying the session has timed out. However, if i access the same page from another page, by clicking on a submit...

Can anyone tell how this works. Also if i change the order of these joins would that impact the resuls select stuff from A inner join B on A.id = B.Aid inner join C on A.id = C.Bid inner join D on A.id = D.Cid inner join E on D.id=E.id inner join F on D.id=F.id