Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kav123

    Web Service Timeout Issue

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

    C# Interop Excel Question

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

    Excel Interop Error

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

    C# Interop Excel Question

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

    Retrieving huge amount of data : XML or anything else?

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

    Retrieving huge amount of data : XML or anything else?

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

    Retrieving huge amount of data : XML or anything else?

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

    Retrieving huge amount of data : XML or anything else?

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

    Populating Excel Spreadsheet from .Net Add In which calls web service

    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??
  10. kav123

    Populating Excel Spreadsheet from .Net Add In which calls web service

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

    Calculating Percentages

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

    Using XML as a parameter in SQL2005

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

    Using XML as a parameter in SQL2005

    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!!!
  14. kav123

    Using XML as a parameter in SQL2005

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

    Using XML as a parameter in SQL2005

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

    Using XML as a parameter in SQL2005

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

    Using XML as a parameter in SQL2005

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

    Using XML as a parameter in SQL2005

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

    Invalid attempt to Read when reader is closed

    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??
  20. kav123

    yield method

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

Part and Inventory Search

Back
Top