Tuesday, December 30, 2008

File v/s BLOB storage in applications

This is my one of the old articles on File storage in applications. May help some readers..
http://www.codeproject.com/KB/database/File_Vs_Blob_Storage.aspx

BLOB Storage in SQL Server. How to store and retrive BLOBS in asp.net application

I have written an article on how to work on BLOB objects in asp.net and sql server. This may help the novice application developers.

http://www.codeproject.com/KB/database/Store_and_manipulat_BLOBs.aspx

-:HTH:-

How to improve site performance by compressing ViewState ?

Here is an article that describes how to improve aspnet site peroformance by compressing viewstate. Worth reading...http://www.dotnetbips.com/articles/22d33d11-1a75-42c8-bbf6-ca1a345d3fcf.aspx

Best ASP.NET FAQ for interviews

Here are some useful links...

http://www.syncfusion.com/faq/aspnet/

http://www.aspnetfaq.com


http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=4081&lngWId=10

http://www.techinterviews.com/?p=193

http://blogs.crsw.com/mark/articles/254.aspx

Shopping Cart Web Template

Here is a nice shopping cart web template..Take it up from there...
http://demo.x-cart.com

:)

Another free CSS web template

This will help the beginners to start with the simple site design and layouts..
Grab it..
http://www.free-css-templates.com

Mini icons for your web applications....

Here are some nice icons which we can use it inside the controlsa and for CSS while developing web applications...

http://icons.primail.ch/

Digg it....

Disaster Recovery in SharePoint Products and Technologies 2003

The below informations will help you a lot when you start managing the SharePoint server farm of your organization since failure is not an option for us (IT) !

This URL points to a page on TECHNET that may interest you:
http://technet.microsoft.com/en-us/library/cc750142.aspx

How to perform a disaster recovery operation of Windows SharePoint Services 2.0 Companyweb and Windows SharePoint Services 2.0 databases?
http://support.microsoft.com/default.aspx/kb/827701

Move SharePoint sites across server farm
http://blogs.msdn.com/priyo/archive/2006/03/24/559896.aspx

I thought this Help and How-to article from Microsoft(R) Office Online might interest you. "Back up, restore, or move a SharePoint site"

-::HTH::-

Ajax pre-loader image online generator

Here we go!...http://www.ajaxload.info/
You can have your own ajax pre-loader...build your own styles..

Ziyad

Here is a joke!

Long back, a person who sacrificed his sleep, forgot his family, forgot his food, Forgot laughter were called "Saints", But now they are called.. "IT professionals"

Monday, December 29, 2008

Happy Holidays !

Dear readers,
I wish you all Merry Christmas, Happy New Year and Happy Holidays !

Rgds, Z

Tool to generate CSS Menu, CSS Button, CSS Page Layout, etc. and free template

Hey developers, here is the nice tool to create your own CSS driven menu, web page layout, button and nice site template for free...

http://www.cssportal.com/

Hope this will help us in our work...

Sunday, December 28, 2008

How to render RDLC (local report) as excel in asp.net ?

Here we go - to render the rdlc local report in asp.net web application


public static void GenerateExcelFromLocalReport()
{
//get your report datasource from the database
IDataReader iReader = GetReportDataSourceReader();
LocalReport report = new LocalReport();
report.ReportPath = HttpContext.Current.Server.MapPath("~/reports
/rdlc/MyReport.rdlc");

report.DataSources.Add(new ReportDataSource("DataSource1", iReader));
ReportParameter[] parameters = new ReportParameter[3];
parameters[0] = new ReportParameter("Filter1", "Filter1's value"));
parameters[1] = new ReportParameter("Filter2", "Filter2's value");
parameters[2] = new ReportParameter("Footer", "Footer's value");
report.SetParameters(parameters);
//
//code to render report as excel document
string encoding = String.Empty;
string mimeType = String.Empty;
string extension = String.Empty;
Warning[] warnings = null;
string[] streamids = null;
//
byte[] byteArray = report.Render("Excel", null, out mimeType,
out encoding, out extension, out streamids, out warnings);

//
HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
HttpContext.Current.Response.AddHeader("Content-Disposition",
"attachment; filename=MyExcel.xls");

HttpContext.Current.Response.AddHeader("Content-Length",
byteArray.Length.ToString());

HttpContext.Current.Response.ContentType = "application/octet-stream";
HttpContext.Current.Response.BinaryWrite(byteArray);
HttpContext.Current.Response.End();
}


-::HTH::-

How to generate or render .pdf document from local report (rdlc) with parameters ?

Here is the code to render the rdlc (local report) as pdf document in asp.net web application.

public void GeneratePDFFromLocalReport()
{
//get your report datasource from the database
IDataReader iReader = GetReportDataSourceReader();
LocalReport report = new LocalReport();
report.ReportPath =
HttpContext.Current.Server.MapPath("~/reports/rdlc/MyReport.rdlc");
report.DataSources.Add(new ReportDataSource("DataSource1", iReader));
ReportParameter[] parameters = new ReportParameter[3];
parameters[0] = new ReportParameter("Filter1", "Filter1's value"));
parameters[1] = new ReportParameter("Filter2", "Filter2's value");
parameters[2] = new ReportParameter("Footer", "Footer's value");
report.SetParameters(parameters);
//
//code to render report as pdf document
string encoding = String.Empty;
string mimeType = String.Empty;
string extension = String.Empty;
Warning[] warnings = null;
string[] streamids = null;
//
byte[] byteArray = report.Render("PDF", null,
out mimeType, out encoding, out extension, out streamids, out warnings);
//
HttpContext.Current.Response.ContentType = "Application/pdf";
HttpContext.Current.Response.AddHeader("Content-Disposition",
"attachment; filename=MyPDF.pdf");
HttpContext.Current.Response.AddHeader("Content-Length",
byteArray.Length.ToString());
HttpContext.Current.Response.ContentType = "application/octet-stream";
HttpContext.Current.Response.BinaryWrite(byteArray);
HttpContext.Current.Response.End();
}


-::HTH::-