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

More Search Options

RSS Available

• Re: Read Write excel file

  Thanks, BarbaMariolino! That's a really good news. I'd better try it with only .NET 2.0. My Excel have some DropDownList columns. They are just ActivX controls in frm20.dll. Is there any way to add such controls to a cell, and read its selected value? Thanks for your help!

  Posted to Enterprise Services Integration (Forum) by blackpuppy on 12/17/2009
  Filed under: Excel 2007, asP.NET 2.0

• Re: read/write Excel 2007 with DropDownList

  I know I can read/write Excel using ADO.NET (OLE DB provider). The connection strings for Excel 2003 (and below) and Excel 2007 can be found at connection strings . But it does not help me read/write DropDownList controls. The DropDownList controls are ActiveX controls. Previously in Excel 2003 solution, we export GridView as HTML table but download it as .xls file. Some columns have DropDownList controls, so they are justhtml SELECT controls. Excel 2003 will open and save it as Web Page format.

  Posted to Enterprise Services Integration (Forum) by blackpuppy on 12/13/2009
  Filed under: Excel 2007, asP.NET 2.0

• Re: read/write Excel 2007 with DropDownList

  I tried to reading an Excel (either 2003 or 2007) Workbook file (a "genuine" Excel file) on hard disk like a database using ADO.NET (via OLE DB provider, and Jet or ACE). What I read out of the cell/column with DropDownList is just blank. If the selected value in the DropDownList control in the Excel file cannot be read, there is nothing to be bound to GridView. I do not know how to use ADO.NET (Jet or ACE) to do that. In Excel, the ActiveX control (the DropDownList control) is just related

  Posted to Enterprise Services Integration (Forum) by blackpuppy on 12/13/2009
  Filed under: Excel 2007, asP.NET 2.0

• read/write Excel 2007 with DropDownList

  My project is using Visual Studio 2005 to develop ASP.NET 2.0 web site. This is the constraint and cannot be changed in the near future. Is there any tool for .NET 2.0 to read/write Excel 2007? I do not need to create any Office Add-ins. This is what I want to do: On a ASP.NET 2.0 web site, on web server, create an Excel 2007 file with data from database. Some columns in the Excel file are DropDownList controls. Allow the user to download it to hist/her local machine. The user will fill in data in

  Posted to Enterprise Services Integration (Forum) by blackpuppy on 12/12/2009
  Filed under: Excel 2007

• Re: Read Write excel file

  GemBox.Spreadsheet requires .NET Framework 3.0 . My project is using Visual Studio 2005 to develop ASP.NET 2.0 web site. This is the constraint and cannot be changed in the near future. Is there any such tool for .NET 2.0 ? Or could I use GemBox.Spreadsheet which requires .NET Framework 3.0 in my ASP.NET 2.0 web site? I do not need to create any Office Add-ins. This is what I want to do: On a ASP.NET 2.0 web site, on web server, create an Excel 2007 file with data from database. Allow the user to

  Posted to Enterprise Services Integration (Forum) by blackpuppy on 12/8/2009
  Filed under: Excel 2007, asP.NET 2.0

• Re: Downloading office 2007 files using c#

  I'm using Office 2003, not using Office 2007 so I cannot try with Offic 2007 files. As far as I know, Office 2007 files are just zip files. So it's no difference in downloading Office 2007 files from other binary files. Where do you store your uploaded file? If it's just normal file on web server harddisk, could you try to compare the downloaded fie with the original file? Could it be opened as a zip file, e.g., using WinZip? They should be different, otherwise the downloaded file should

  Posted to C# (Forum) by blackpuppy on 8/21/2009
  Filed under: download

• Re:   decoded to 0x00A0?

  Thanks, Zong-Qing Li! There is one extra step to do in exporting DataTable. Not all columns in the DataTable are bound to the GridView and shown to the user, So what I actually did is export only the columns of the DataTable used in GridView. The difficulty here is that different types DataControlField are specifying data field differently. BoundField has a DataField that I can use. But for TemplateField, I have to manually specify the column(s) defined in the item template. And note all the above

  Posted to Getting Started (Forum) by blackpuppy on 11/28/2008
  Filed under: HtmlDecode &nbsp, to space

• Client IsPostBack?

  I asked Session end event for StateServer/SQLServer in the forum State Management . But maybe the question is more appropriate here. In web.config, when sessionState's mode is set to InProc, there is a Session_End event handler in global.asax that I could use to delete some temporary data for a report saved in database. But when it is set to StateServer or SQLServer, this event handler is ignored. In out-of-process session mode, I use client JavaScript window.setTimeout() to simulate Session_End

  Posted to Client Side Web Development (Forum) by blackpuppy on 11/27/2008
  Filed under: Client IsPostBack

• Re: Session end event for StateServer/SQLServer

  Thanks, raju! It works fine. I use JavaScript's window.setTimeout() to simulate session timeout. After the specified interval times out, then I use AJAX to call a page method to delete temp data. < script type= "text/javascript" language= "javascript" > var isSubmit = false; jQuery(document).ready(function() { // simulate session timeout on client using a timer var t = window.setTimeout('clearQuery()', <%= GetSessionTimeout() %> * 60000); // millisecond

  Posted to State Management (Forum) by blackpuppy on 11/27/2008
  Filed under: Session end event in out-of-process mode, WebForm_DoPostBackWithOptions()

• &nbsp; decoded to 0x00A0?

  I want to export a GridView to a text file. But the original space in database will be rendered as &nbsp; in inGridView, then become 0x00A0 after being decoded using HttpUtility.HtmlDecode() method. This is illustrated by the following code. string originalString = " " ; // space string webString = HttpUtility.HtmlEncode(originalString); // &nbsp; string actual = HttpUtility.HtmlDecode(webString); // 0x00A0 string expected = webString.Replace( "&nbsp;" , " "

  Posted to Getting Started (Forum) by blackpuppy on 11/25/2008
  Filed under: HtmlDecode &nbsp, to space