Crystal Report

Friends Today I'm succeed in Designing of Crystal Report in Web Aplication. This type of Crystal report are basically use in e-shopping website where dealer and courier can see their Invertory Stock and/or Sale.

So here is Code....

protected void Page_Load(object sender, EventArgs e)

{
if (!IsPostBack)

{
string strcomm = " Alter view view_Accept as SELECT Order_Table.Order_ID, Item_Master.Item_Id, Item_Master.ItemName, Order_Detail.Qty, Item_Master.Rate,(Order_Detail.Qty * Item_Master.Rate) as Amount, Dealer.Dealer_Name, Dealer.City, FROM Dealer INNER JOIN Order_Table INNER JOIN Order_Detail ON Order_Table.Order_ID = Order_Detail.Order_ID INNER JOIN Item_Master ON Order_Detail.ItemCode = Item_Master.Item_Id ON Dealer.Dealer_Id = Order_Detail.Dealer_Id INNER JOIN Shipment ON Item_Master.Item_Id = Shipment.Item_Id ";

DataTable dt = dUT.GetDataTable(strcomm);
CrystalReportViewer1.ReportSource = "E:\\Arun\\May\\23May 2008\\Accept.rpt";

}

first of all create the view in the database like;;

create view view_name as "your select query";

"your Select Query means here you write the Select query based on your table which coloums you want.

After that in VS 2005..

1. go to Website->Add New Items->Select Crystal report then "Click OK"

2. A dialog box will appear . In this Select the "Create New Connection"->OLE DB(ADO)->Select the Database Provider and your database Name.

After following the steps Select the View Name Which You created in your Database. Add this to right hand side and finish.

Paging In DataList C#


protected void Page_Load(object sender, EventArgs e)
{
getitemfromdatabase();
}
protected void cmdNext_Click(object sender, EventArgs e) { // Set viewstate variable to the next page CurrentPage += 1;
// Reload control getitemfromdatabase();
}
protected void cmdPrev_Click(object sender, EventArgs e)
{ // Set viewstate variable to the previous page CurrentPage -= 1;
// Reload control getitemfromdatabase();
}
private void getitemfromdatabase()
{
SqlDataAdapter myAdapter = new SqlDataAdapter("SELECT item_id, item_name, description, qty, new_rate, old_rate, user_id, offer_rate FROM item_master", con);
// Read sample item info from XML document into a
DataSet DataSet Items = new DataSet();
myAdapter.Fill(Items, "item_master");
repeaterItems.DataSource = Items;
repeaterItems.DataBind();
// Populate the repeater control with the Items DataSet
PagedDataSource objPds = new PagedDataSource();
objPds.DataSource = Items.Tables[0].DefaultView;
objPds.AllowPaging = true; objPds.PageSize = 3;
objPds.CurrentPageIndex = CurrentPage;
lblCurrentPage.Text = "Page: " + (CurrentPage + 1).ToString() + " of " + objPds.PageCount.ToString();
// Disable Prev or Next buttons if necessary cmdPrev.Enabled = !objPds.IsFirstPage; cmdNext.Enabled = !objPds.IsLastPage;
mydatalist.DataSource = objPds; mydatalist.DataBind();
}
public int CurrentPage
{
get
{ // look for current page in ViewState
object o = this.ViewState["_CurrentPage"]; if (o == null) return 0;
// default to showing the first page else return (int)o;
}
set { this.ViewState["_CurrentPage"] = value;
}
}
}