Tuesday, March 26, 2013

Show Confirm window through code behind


http://www.telerik.com/community/forums/aspnet-ajax/window/need-to-show-confirm-window-through-
code-behind.aspx

Friday, March 22, 2013

Use UpdateProgress To Cover Screen

http://blog.oscarscode.com/dot-net/use-updateprogress-to-cover-screen/

Monday, February 18, 2013

My Sql Templates

Properties

select 'signUp.' + column_name + ' = .Text;' from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME like 'Signup'



Wednesday, January 30, 2013

References Not Found on .g.i.cs files

Just CLEAN and REBUILD the solution. It works! ;)

Sunday, December 2, 2012

The breakpoint will not currently be hit in Silverlight project

Solution to the "The breakpoint will not currently be hit" in Silverlight project

Solution 1:
1. Right click on the Silverlight project
2. Locate and click the Web tab
3. Make sure that the Silverlight checkbox is checked.

Solution 2: What if the Silverlight checkbox is already checked, you have already cleaned the solution, deleted the BIN and OBJ folders and still, it doesn't work?
1. Uncheck the Silverlight checkbox
2. Run the solution (the breakpoint will not work, of course!)
3. Stop running. Go the properties again and re-check the Silverlight option.
It works for me!

Solution 3: Clear the browser's cache / temporary files

Solution 4: Usually deleting the <solutionfilename>.suo file in the solution folder fixes it.



Tuesday, November 20, 2012

Telerik Report: RendererNotAvailableException... rendering format is not available

Scenario: I am trying to export the report programmatically
Feature: Telerik Reporting export feature
Error Message: "RendererNotAvailableException... rendering format is not available" for the following formats:

- DOCX
- HTML
- PPTX 
- XPS

Code Snippet: 
Telerik.Reporting.Processing.ReportProcessor reportProcessor = new Telerik.Reporting.Processing.ReportProcessor();
Telerik.Reporting.Processing.RenderingResult result = reportProcessor.RenderReport(format, reportToExport, deviceInfo);
 reportBytes = result.DocumentBytes;
 if (reportBytes != null && reportBytes.Length > 0)
                Mailer.SendNotifications(_report, reportBytes);

Solution:
As noted in the Deploying Applications using Telerik Reporting help section, the DOCX/PPTX/XLSX rendering extensions require Telerik.Reporting.OpenXmlRendering.dll and Open XML SDK 2.0 for Microsoft Office (DocumentFormat.OpenXml.dll v.2.0.5022.0 or above).

The XPS rendering extension requires Telerik.Reporting.XpsRendering assembly (Telerik.Reporting.XpsRendering.dll). In both cases your project should be targeting .NET 3.5 Framework or above.


If just adding the DocumentFormat.OpenXml.dll does not work, then, the

Open XML SDK 2.0 for Microsoft Office must be installed first on the server.

If still, it doesn't work, check the project that references to the project where Telerik Reporting is originally referenced. That project also needs the mentioned DLLs.

Friday, October 26, 2012

Insert Record(s) to a Table from Another Table



insert into TableDocument2(DocumentId, DeptId, a, b, c, d,e) 
select DocumentId, 9, f, g, h, i, NULL from TableDocument