print crystal report

using System.IO;
private void Button1_Click(object sender, System.EventArgs e)
{
MemoryStream oStream; // using System.IO
CrystalReport1 report = new CrystalReport1();
oStream = (MemoryStream)
report.ExportToStream(
CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
Response.Clear();
Response.Buffer= true;
Response.ContentType = "application/pdf";
Response.BinaryWrite(oStream.ToArray());
Response.End();
}

util class

using System.Configuration;

using System;

using System.Data;

using System.Text;

using System.Web.UI.WebControls;

using System.Web.UI.HtmlControls;

using System.Collections;

using System.ComponentModel;

using System.Data.OleDb;

using System.Drawing;

using System.Web;

using System.Web.SessionState;

using System.Web.UI;



namespace NameSpaceName.BaseClasses

{

public class DBUtil

{



//string strConnectionString =
ConfigurationSettings.AppSettings["ConnectionString"];

string strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Password=;User
ID=Admin;Data Source=" + System.Web.HttpContext.Current.Server.MapPath(@"~/Accessdata/DB1.mdb");


public OleDbConnection oConn = new OleDbConnection();





public DataSet Get_DataSet(string strSql)

{

OleDbCommand cmd = new OleDbCommand(strSql);

oConn.ConnectionString = strConnectionString;

oConn.Open();

OleDbDataAdapter myAdptr = new OleDbDataAdapter(strSql,oConn);

DataSet ds = new DataSet();

myAdptr.Fill(ds);

oConn.Close();

return ds;

}



public DataTable Get_Table(string strSql)

{

OleDbCommand cmd = new OleDbCommand(strSql);

oConn.ConnectionString = strConnectionString;

oConn.Open();

OleDbDataAdapter myAdptr = new OleDbDataAdapter(strSql,oConn);

DataSet ds = new DataSet();

myAdptr.Fill(ds);

oConn.Close();

return ds.Tables[0];



}





public OleDbDataReader Get_DataReader(string strSql)

{

OleDbCommand cmd = new OleDbCommand(strSql);

oConn.ConnectionString = strConnectionString;

oConn.Open();

cmd.Connection = oConn;

OleDbDataReader rd = cmd.ExecuteReader(CommandBehavior.CloseConnection);

//oConn.Close();

return rd;

}





public string Execute_Scaler(string strSql)

{

OleDbCommand cmd = new OleDbCommand(strSql);

oConn.ConnectionString = strConnectionString;

oConn.Open();

cmd.Connection = oConn;

string val = cmd.ExecuteScalar().ToString();

oConn.Close();

return val;

}





public int Execute_NonQuesry(string strSql)

{

OleDbCommand cmd = new OleDbCommand(strSql);

oConn.ConnectionString = strConnectionString;

oConn.Open();

cmd.Connection = oConn;

int val = cmd.ExecuteNonQuery();

oConn.Close();

return val;

}



public string FormatInput(string istr)

{

istr = istr.Replace( "<", "&lt;");

istr = istr.Replace( ">", "&gt;");

istr = istr.Replace( "[", "&#091;");

istr = istr.Replace( "]", "&#093;");

istr = istr.Replace( "'", "`");

if(istr == "")

{

istr = " ";

}

return istr;

}

public class PageUtility

{

public void SetFocus(Control control)

{

StringBuilder sb = new StringBuilder();



sb.Append("\r\n<script language='JavaScript'>\r\n");

sb.Append("<!--\r\n");

sb.Append("function SetFocus()\r\n");

sb.Append("{\r\n");

sb.Append("\tdocument.");



Control p = control.Parent;

while (!(p is System.Web.UI.HtmlControls.HtmlForm)) p = p.Parent;



sb.Append(p.ClientID);

sb.Append("['");

sb.Append(control.UniqueID);

sb.Append("'].focus();\r\n");

sb.Append("}\r\n");

sb.Append("window.onload = SetFocus;\r\n");

sb.Append("// -->\r\n");

sb.Append("</script>");



control.Page.RegisterClientScriptBlock("SetFocus", sb.ToString());

}

}





}

}

PixelAdRaptor - your million dollar pixel engine - Download PixelAdRaptor

PixelAdRaptor - your million dollar pixel engine - Download PixelAdRaptor

PHP image processing

1) create thumnails from the image
http://www.icant.co.uk/articles/phpthumbnails/
2) add watermark in the large image http://www.developertutorials.com/tutorials/php/adding-custom-text-to-image-050620/page1.html

Webstats4u.com - Catalogue / Top 10 charts

Webstats4u.com - Catalogue / Top 10 charts

Velocity Webshots Sandbox

Velocity Webshots Sandbox create webshot

Webmaster Forum - Internet Marketing & Search Engine Forums

Webmaster Forum - Internet Marketing & Search Engine Forums

Skins

http://skins.be

.NET Data Access Architecture Guide

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/daag.asp

free ebook download for self training, tutorial & certification

free ebook download for self training, tutorial & certification

free ebook download for self training, tutorial & certification

free ebook download for self training, tutorial & certification

Free E-book Reference

ftp://217.11.138.10/books/

Free E-book Reference

ftp://217.11.138.10/books/

Dynamic Drive DHTML Scripts- Cool DHTML Tooltip

Dynamic Drive DHTML Scripts- Cool DHTML Tooltip

The Code Project - MobileForms Toolkit - a modern way of developing mobile business applications - Product Showcase

The Code Project - MobileForms Toolkit - a modern way of developing mobile business applications - Product Showcase

Export DataSets to Excel

Export DataSets to Excel

C# C-sharp c sharp links

C# C-sharp c sharp links

Develop and Code: Secure Pages

Develop and Code: Secure Pages

ebooks, tutorials, articles and certification study notes

Hello Friends,
Here is the site with lots of of ebooks, tutorials, articles and certification study notes... Hope this helps some one looking for free trainings notes and ebooks.
http://www.itquestionbank.com
Here is the site with lots of of ebooks, tutorials, articles and certification study notes... Hope this helps some one looking for free trainings notes and ebooks.

Testing http://www.itquestionbank.com/testing
Testing Basics <http://www.itquestionbank.com/testing/testing-basics>
Test Process <http://www.itquestionbank.com/testing/sqa-testrocess>,
Methods<http://www.itquestionbank.com/testing/methods>,
Test Approach <http://www.itquestionbank.com/testing/test-approach>,
WinRunner <http://www.itquestionbank.com/testing/winrunner>, TestingFAQ's<http://www.itquestionbank.com/testing/testing-faq-s>,
Testing Tools <http://www.itquestionbank.com/testing/testing-tools>,
LoadRunner <http://www.itquestionbank.com/testing/loadrunner>,
Test Automation <http://www.itquestionbank.com/testing/test-automation>,
Rational Robot <http://www.itquestionbank.com/testing/rational-robot>,
Quick Test Pro(QTP) <http://www.itquestionbank.com/testing/qtp>, SegueSilk<http://www.itquestionbank.com/testing/segue-silk>,
Quality Assurance <http://www.itquestionbank.com/testing/quality-assurance>,
SQA Websites <http://www.itquestionbank.com/testing/sqa-websites>,
Test Director <http://www.itquestionbank.com/testing/test-director> Databases<http://www.itquestionbank.com/databases>
(170) Oracle <http://www.itquestionbank.com/databases/Oracle> , SQLServer<http://www.itquestionbank.com/databases/sql-server>,
MySQL <http://www.itquestionbank.com/databases/mysql>, MSAccess<http://www.itquestionbank.com/databases/ms-access>,
Visual FoxPro <http://www.itquestionbank.com/databases/visual-foxpro>,
TeraData <http://www.itquestionbank.com/databases/teradata>,
Sybase<http://www.itquestionbank.com/databases/sybase>,
DB2 <http://www.itquestionbank.com/databases/db2>,
PostgreSQL<http://www.itquestionbank.com/databases/postgresql>
Ebooks <http://www.itquestionbank.com/Ebooks>
(638) Java <http://www.itquestionbank.com/Ebooks/Java>,
MSAS<http://www.itquestionbank.com/Ebooks/msas>,
C and C Plus Plus<http://www.itquestionbank.com/Ebooks/C%20and%20C%20Plus%20Plus>,
Linux <http://www.itquestionbank.com/Ebooks/Linux>,
Networking<http://www.itquestionbank.com/Ebooks/Networking>,
UNIX <http://www.itquestionbank.com/Ebooks/UNIX>,
HTML<http://www.itquestionbank.com/Ebooks/HTML>,
Scripting <http://www.itquestionbank.com/Ebooks/Scripting>,
Computers<http://www.itquestionbank.com/Ebooks/computers>,
Perl <,ASP">http://www.itquestionbank.com/Ebooks/Perl>,ASP
<http://www.itquestionbank.com/Ebooks/ASP>,
Windows <http://www.itquestionbank.com/Ebooks/Windows>, Oracle9i<http://www.itquestionbank.com/Ebooks/oracle-9i>,
XML <http://www.itquestionbank.com/Ebooks/XML>,
Peoplesoft<http://www.itquestionbank.com/Ebooks/Peoplesoft>,
Oracle Apps <http://www.itquestionbank.com/Ebooks/OracleApps> ,
ASP.NET<http://www.itquestionbank.com/Ebooks/ASP.NET>,
C Sharp <http://www.itquestionbank.com/Ebooks/C%20Sharp>, MSOffice<http://www.itquestionbank.com/Ebooks/MS%20Office>,
VB.NET <http://www.itquestionbank.com/Ebooks/VB.NET>,
Others<http://www.itquestionbank.com/Ebooks/others>,
Python <http://www.itquestionbank.com/Ebooks/Python>,
Web<http://www.itquestionbank.com/Ebooks/web>,
Visual Basic <http://www.itquestionbank.com/Ebooks/Visual%20Basic>,
DB2<http://www.itquestionbank.com/Ebooks/DB2>,
Visual C++ <http://www.itquestionbank.com/Ebooks/Visual%20C++>,
MySQL<http://www.itquestionbank.com/Ebooks/MySQL>,
VB .NET 2005 <http://www.itquestionbank.com/Ebooks/vb-.net-2005>,
PHP<http://www.itquestionbank.com/Ebooks/PHP>,
SOAP <http://www.itquestionbank.com/Ebooks/SOAP>,
Macintosh<http://www.itquestionbank.com/Ebooks/Macintosh>,
Siebel <http://www.itquestionbank.com/Ebooks/Siebel>, SQLServer<http://www.itquestionbank.com/Ebooks/SQL%20Server>
ERP <http://www.itquestionbank.com/erp>
(100) SAP R3 <http://www.itquestionbank.com/erp/sap-r3>, OracleApps<http://www.itquestionbank.com/erp/oracle-apps>,
Peoplesoft <,">http://www.itquestionbank.com/erp/peoplesoft>,
Siebel<http://www.itquestionbank.com/erp/siebel>
Applications <http://www.itquestionbank.com/applications>
(65) MS Office <http://www.itquestionbank.com/applications/ms-office>,
SharePoint Portal Server<http://www.itquestionbank.com/applications/sharepoint-portal-server>,
MS FrontPage <http://www.itquestionbank.com/applications/ms-frontpage>,
Macromedia <http://www.itquestionbank.com/applications/macromedia>,
Adobe<http://www.itquestionbank.com/applications/adobe>,
Browsers <http://www.itquestionbank.com/applications/browsers>,
Corel<http://www.itquestionbank.com/applications/corel>
Java <http://www.itquestionbank.com/Java>
(577) Java <http://www.itquestionbank.com/Java/java>,
J2EE<http://www.itquestionbank.com/Java/j2ee>,
Servlets <http://www.itquestionbank.com/Java/servlets>,
JSP<http://www.itquestionbank.com/Java/jsp>,
EJB <http://www.itquestionbank.com/Java/ejb>,
Applets<http://www.itquestionbank.com/Java/applets>,
Java Swing <http://www.itquestionbank.com/Java/java-swing>,
J2ME<http://www.itquestionbank.com/Java/j2me>,
Core Java <http://www.itquestionbank.com/Java/core-java>,
JDBC<http://www.itquestionbank.com/Java/jdbc>,
Jini <http://www.itquestionbank.com/Java/jini>,
J2SE<http://www.itquestionbank.com/Java/j2se>,
Web Services <http://www.itquestionbank.com/Java/web-services>,
Design Patterns <http://www.itquestionbank.com/Java/design-patterns>,
JMS<http://www.itquestionbank.com/Java/jms>,
JSF <http://www.itquestionbank.com/Java/jsf> Certification<http://www.itquestionbank.com/certification>
(12) SUN <http://www.itquestionbank.com/certification/sun>, ExamSimulators<http://www.itquestionbank.com/certification/exam-simulators>,
Microsoft <http://www.itquestionbank.com/certification/microsoft>,
Cisco<http://www.itquestionbank.com/certification/cisco>,
Oracle <http://www.itquestionbank.com/certification/oracle>
OS<http://www.itquestionbank.com/OS>
(118) Linux <http://www.itquestionbank.com/OS/linux>,
LongHorn<http://www.itquestionbank.com/OS/longhorn>,
Windows CE <http://www.itquestionbank.com/OS/windows-ce>,
Windows<http://www.itquestionbank.com/OS/windows>,
Pocket PC <http://www.itquestionbank.com/OS/pocket-pc>,
Macintosh<http://www.itquestionbank.com/OS/macintosh>,
UNIX <http://www.itquestionbank.com/OS/unix>
Concepts<http://www.itquestionbank.com/concepts>
(116) Data Structure <http://www.itquestionbank.com/concepts/data-structure>,
Data Access <http://www.itquestionbank.com/concepts/data-access>,
Security<http://www.itquestionbank.com/concepts/security>,
Architecture <http://www.itquestionbank.com/concepts/architecture>,
Data Warehouse <http://www.itquestionbank.com/concepts/data-warehouse>,
OOPS<http://www.itquestionbank.com/concepts/OOPS>,
Data Modeling <http://www.itquestionbank.com/concepts/data-modeling>,
Networking <http://www.itquestionbank.com/concepts/networking>,
Project Management <http://www.itquestionbank.com/concepts/project-management>,
Design <http://www.itquestionbank.com/concepts/design> Programming<http://www.itquestionbank.com/Programming>
(755) Microsoft.NET <http://www.itquestionbank.com/Programming/microsoft.net>,
ASP.NET <http://www.itquestionbank.com/Programming/asp-.net>,
ASP<http://www.itquestionbank.com/Programming/asp>,
C and C++<http://www.itquestionbank.com/Programming/C%20and%20C%20Plus%20Plus>,
C# <http://www.itquestionbank.com/Programming/c>,
VB.NET<http://www.itquestionbank.com/Programming/vb.net>,
Visual Studio 2005 <http://www.itquestionbank.com/Programming/visual-studio>,
Palm <http://www.itquestionbank.com/Programming/palm>, VisualBasic<http://www.itquestionbank.com/Programming/visual-basic>,
Visual C++ <http://www.itquestionbank.com/Programming/visual-c>,
Visual J#<http://www.itquestionbank.com/Programming/visual-j>,
Delphi <http://www.itquestionbank.com/Programming/delphi>
Web<http://www.itquestionbank.com/Web>
(640) XML <http://www.itquestionbank.com/Web/xml>,
SOAP<http://www.itquestionbank.com/Web/soap>,
CSS <http://www.itquestionbank.com/Web/css>,
HTML<http://www.itquestionbank.com/Web/html>,
Apache <http://www.itquestionbank.com/Web/apache>,
Python<http://www.itquestionbank.com/Web/python>,
PHP <http://www.itquestionbank.com/Web/php>,
WebService<http://www.itquestionbank.com/Web/web-service>,
RSS <http://www.itquestionbank.com/Web/rss>,
Perl<http://www.itquestionbank.com/Web/perl>,
WAP <http://www.itquestionbank.com/Web/wap>,
JavaScript<http://www.itquestionbank.com/Web/java-script>,
WSDL <http://www.itquestionbank.com/Web/wsdl>, VoiceXML<http://www.itquestionbank.com/Web/voice-xml>,
Scripting <http://www.itquestionbank.com/Web/scripting>,
CGI<http://www.itquestionbank.com/Web/cgi>
PHPScripts <http://www.itquestionbank.com/php-scripts>
(122) Ads Management <http://www.itquestionbank.com/php-scripts/ads-management>,
Blog Scripts <http://www.itquestionbank.com/php-scripts/blog-scripts>,
Chat Scripts <http://www.itquestionbank.com/php-scripts/chat-scripts>,
Click Tracking <http://www.itquestionbank.com/php-scripts/click-tracking>,
Bookmark Scripts <http://www.itquestionbank.com/php-scripts/bookmark-scripts>,
Auction Scripts <http://www.itquestionbank.com/php-scripts/auction-scripts>,
Knowledge Base and FAQ<http://www.itquestionbank.com/php-scripts/knowledge-base-and-faq>,
Form Processors <http://www.itquestionbank.com/php-scripts/form-processors>,
CMS Scripts <http://www.itquestionbank.com/php-scripts/cms-scripts>,
Affiliate Programs <http://www.itquestionbank.com/php-scripts/affiliate-programs>,
Forum Scripts <http://www.itquestionbank.com/php-scripts/forum-scripts>
Regards,

Rahulvaja
rahulvaja2003@yahoo.com

Free Icons, Graphics, Buttons For ASP.NET Business Applications - Microsoft .NET Unknown

Free Icons, Graphics, Buttons For ASP.NET Business Applications And other coding reference- Microsoft .NET