Home
Get Started
Learn
Downloads
AJAX
MVC
Community
Wiki
Forums
Sign in
|
Join
Home
›
ASP.NET Forums
›
Search
Search
You searched for the word(s): userid:485546
More Search Options
RSS Available
Matching Posts
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
Page 1 of 14 (135 items) 1
2
3
4
5
Next >
...
Last ยป
Channel 9:
Virtual Earth Videomap Movies
TechNet Edge:
AD RMS Certificates and Licensing on the Client and the Server
Channel 9:
C9 Lectures: Dr. Erik Meijer - Functional Programming Fundamentals Chapter 10 of 13 [C9 Lectures: Dr. Erik Meijer - Functional Programming Fundamentals Chapter 10 of 13]
Channel 10:
Bing Launches 2nd Homepage Photo Contest
Channel 10:
Bing4Free Lets You Use Bing.com Images for Desktop Wallpaper
Channel 10:
Bing for Windows Mobile Updated
Channel 10:
Bing Updates: Streetside Views, Photosynth, and "Mapplications"
WindowsClient:
Tale of two tweets - VS beta - is it busy 70% of the time or is it brilliantly fast?
TechNet Edge:
Forefront TMG URL Filtering and MRS
Mix Online:
Using the HTML5 Video and Audio Tag with Gestalt
WindowsClient:
Subclassing Shape (or more accurately, Path)
WindowsClient:
Having trouble deleting files? Try this
Channel 9:
Nick Baker: Xbox Architecture
TechNet Edge:
Thrive Live! Behavioral Interviewing: A behavioral answer is always the correct answer
ASP.NET:
PDC and Tech-Ed Europe Slides and Code
WindowsClient:
JScript location bar silliness
WindowsClient:
Anybody build a XAML parser in C or C++ yet?
WindowsClient:
Silverlight use, power and deployment keeps growing; so does WPF
ASP.NET:
T4CSS: A T4 Template for .Less CSS With Compression
WindowsClient:
JSON-P: An Elegant Hack
Microsoft Communities
ASP.NET
Channel 8
Channel 9
Channel 10
IIS.NET
Silverlight
TechNet Edge
WindowsClient
Mix Online