FlazX - Welcome to your Computer & IT learning center

FlazX - Welcome to your Computer & IT learning center
Complete Cpllection of it books

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