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

More Search Options

RSS Available

• Re: Excel data population issue

  Hi Stanly, Thanks for the link. Those were really cool examples. But what really i need is that What i 'm missing in the production server that is causing the data to scramble. As i said the scrambling only happens when i use a template created from Excel 2007. But there is no problem with the template created from Excel 2003. The issue with Excel 2003 template file is with its huge size.

  Posted to Data Access and ObjectDataSource Control (Forum) by hemant_vikram on 11/5/2009

• Excel data population issue

  Hi Guys, I need to write data to an Excel template which has 2 sections. The section on top is the header and I write data to its individual cell using the following method: UPDATE [Sheet1$C16:C16] SET F1 = 'some data' The other section, the section below header, has line items and each row is populated using the following method (same as above) INSERT INTO [Sheet1$A29:BI29] (F1, F2, F3,.....F60) VALUES (1,'string data',20.34,.....,'another string data') This method is working

  Posted to Data Access and ObjectDataSource Control (Forum) by hemant_vikram on 11/4/2009
  Filed under: Excel 2007

• Excel data population issue

  Hi Guys, I need to write data to an Excel template which has 2 sections. The section on top is the header and I write data to its individual cell using the following method: UPDATE [Sheet1$C16:C16] SET F1 = 'some data' The other section, the section below header, has line items and each row is populated using the following method (same as above) INSERT INTO [Sheet1$A29:BI29] (F1, F2, F3,.....F60) VALUES (1,'string data',20.34,.....,'another string data') This method is working

  Posted to Enterprise Services Integration (Forum) by hemant_vikram on 11/4/2009
  Filed under: Excel 2007

• Re: System.InvalidOperationException: There was an error generating the XML document.

  Hi Martin, Thanks for your suggestion. I tried the following method (serializing to a file and then using it) and it worked. public XmlDocument Serialize<T>(T obj) { XmlDocument xmlDoc; string file = Server.MapPath(ConfigurationManager.AppSettings["ADMIN_REPORT_TEMP_FOLDER"].ToString() + "/itemaudit_" + DateTime.Now.Ticks.ToString() + ".xml"); try { XmlSerializer xs = new XmlSerializer(typeof(T)); using (System.IO.FileStream fs = new System.IO.FileStream(file,

  Posted to XML and XmlDataSource Control (Forum) by hemant_vikram on 10/28/2009

• System.InvalidOperationException: There was an error generating the XML document.

  Hi Guys, Not always but occasionally I get the following exception message: System . InvalidOperationException : There was an error generating the XML document . ---> System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown. at System.String.GetStringForStringBuilder(String value, Int32 startIndex, Int32 length, Int32 capacity) at System.Text.StringBuilder.GetNewString(String currentString, Int32 requiredLength) at System.Text.StringBuilder.Append(String

  Posted to XML and XmlDataSource Control (Forum) by hemant_vikram on 10/26/2009

• Re: System.InvalidOperationException: There was an error generating the XML document.

  Hi Kavitha, I still get the same error. Any other thoughts or suggestions. FYI: There are around 300,000 records.

  Posted to XML and XmlDataSource Control (Forum) by hemant_vikram on 10/26/2009

• Re: System.InvalidOperationException: There was an error generating the XML document.

  At the following line: serializer.Serialize(memStream, transformObject);

  Posted to XML and XmlDataSource Control (Forum) by hemant_vikram on 10/26/2009

• Re: Preserve Excel Formatting

  Hi Guys, Is there any possible workaround for this problem. Appreciate your thoughts.

  Posted to Enterprise Services Integration (Forum) by hemant_vikram on 9/28/2009

• Preserve Excel Formatting

  Hi Guys, I have an excel template file properly set with necessary formattings. For example: All amount cells are formatted with Currency type and 2 descimal places, etc.., I use this template to write the user data and have it downloaded by the client. I use the following method to write data to excel cells. INSERT INTO [sheet1$A29:B29] (F1, F2) VALUES ('Hemant', 200) From the above insert statement you can see that I 'm inserting in the Row 29 values such as Hemant (String type) and

  Posted to Enterprise Services Integration (Forum) by hemant_vikram on 9/26/2009
  Filed under: excel formatting

• Re: Empty space character ignored ???

  Hi Guys, First off sorry for the delayed response. Monday morning duh! I executed the following two scenarios. One with ANSI_PADDING ON and another with OFF in the query analyzer. In both the cases i got the same result. DECLARE @test VARCHAR(10) SET ANSI_PADDING OFF SET @test = 'Hemant ' SELECT LEN(@test) SELECT DATALENGTH(@test) SELECT SUBSTRING(@test, 1, 7) + 'Hai' SELECT @test + 'Hai' SET ANSI_PADDING ON SET @test = 'Hemant ' SELECT LEN(@test) SELECT DATALENGTH

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by hemant_vikram on 9/21/2009