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...

Ok, has anyone used get_offset method. Basically i need to get values from every alternate column in a row, till the end of the row i.e. where the data ends. Please any help would be great

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 =...

Ok,worked it out, used OpenXML for it. Basically i am populating the XML into a temp table created and then created an inner join from there. However, for some reason the first two rows are null values, even though there are values in there. any ideas. I am using the following INSERT...

I was thinking of populating the data retrieved from each of the ids into a table and then pass the table. But the amount of data looks huge. Any examples of working with xml would be great!! Searched the web sites, did not bump into any good ones so far.

Hmm, thanks for that. Any examples or urls, have used XML to insert data into the table how, to loop through the XML and select the records. Also every id in XML will return rows of data, not sure how to return the data. Sorry, but not a SQL2005 expert!! ANy help great

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...

Ok, we are using Excel interop to read from and write to Excel. Basically the data needs to be passed to a service which retrieves data from database and a huge chunk of data is populated to Excel. In terms of performance which would be better and Add-In or a ASP.Net page??

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...

Cracked it!!! Thanks guys for all your help. Here is the solution incase any one needs it in the future.. Declare @xmlPointer int, INSERT INTO Table_Name(ID, SampleDateTime, Value) Select * From OpenXML(@xmlPointer,'//Node1',1) WITH (ID varchar(50) '../@ID',SamlpleDateTime DateTime...

Thanks for that, the columns after the Insert into are the actual columns in the table. The ID is not a foreign key. It is just named that way for some reason. This is just a holding table which holds the huge chunk of data. Thanks for that, shall give it a go... finger crossed!!!

Hello, I am getting nowhere with this, the records are not being inserted in the database table. Anymore ideas. Basically i need to insert huge chunk of data(we are talking 100s of rows here from a service process.) I thought the best way was to pass the data in an XML and then parse it. But the...

If i use ntext instead of XML datatype, the reason is because of restrictions in the DAL layers which we use to call and execute these stored procedures, do not support this datatype yet.

Did not make any difference tried both the syntaxes. I am trying to insert all these attributes into the columns of the same table. Could anyone point me towards a good site which could provide me a good understanding of parsing this XML in SQL or if someone here could do a bit of explaining...

Thanks for that, will try that one. I am using 2005. Does that mean that we do not use sp_xml_preparedocument anymore??

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??

So basically does this mean that you do not need to implement the IEnumerator in your class. yield does it for you, and it also helps create instances of custom types on the fly...??