Hi,
I have an embedded datagrid within a datalist. I am not able to
perfrom paging in the datagrid. Any ideas? Here is my code:
Here is my Simplegrid.cs file:
using System;
using System.Collecti ons;
using System.Componen tModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.Sess ionState;
using System.Web.UI;
using System.Web.UI.W ebControls;
using System.Web.UI.H tmlControls;
using System.Data.Sql Client;
using System.Configur ation;
namespace TestCProject
{
/// <summary>
/// Summary description for WebForm1.
/// </summary>
public class WebForm1 : System.Web.UI.P age
{
protected System.Web.UI.W ebControls.Data List dtl1;
protected System.Web.UI.W ebControls.Labe l Label1;
protected System.Web.UI.W ebControls.Data Grid DataGrid1;
protected System.Web.UI.W ebControls.Data Grid dgr1;
private void Page_Load(objec t sender, System.EventArg s e)
{
if(!Page.IsPost Back)
{
Session["Status"] = "";
dtl1.DataSource = GetCustomers();
dtl1.DataBind() ;
//BindGrid();
}
}
private DataSet GetCustomers()
{
string sSelect;
sSelect = "SELECT CustomerID, CompanyName, City, Country, Phone
FROM Customers WHERE CustomerID LIKE 'c%'";
return GetReader(sSele ct);
}
private DataSet GetReader(strin g sSQL)
{
DataSet ds = new DataSet();
SqlConnection oConnect = new
SqlConnection(C onfigurationSet tings.AppSettin gs["SQLConnectionS tring"]);
oConnect.Open() ;
// SqlCommand oCommand = new SqlCommand(sSQL , oConnect);
//
// return oCommand.Execut eReader(Command Behavior.CloseC onnection);
SqlDataAdapter SQLda = new SqlDataAdapter( sSQL,oConnect);
SQLda.Fill(ds, "SQLNewStar t");
return ds;
}
#region Web Form Designer generated code
override protected void OnInit(EventArg s e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeCompo nent();
base.OnInit(e);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeCompo nent()
{
this.Load += new System.EventHan dler(this.Page_ Load);
}
#endregion
protected void BindGrid()
{
try
{
DataGrid1.Pager Style.Mode = PagerMode.Numer icPages;
DataGrid1.Pager Style.PageButto nCount = 5;
DataGrid1.PageS ize = 4;
DataGrid1.DataS ource=GetNewSta rtData();
DataGrid1.DataB ind();
}
catch (Exception Exp)
{
string errorMessage = Exp.Message;
Response.Write( errorMessage);
}
}
private DataSet GetNewStartData ()
{
DataSet ds = new DataSet();
string strSQL = " Select CategoryId, CategoryName, description from
categories";
SqlConnection myConnection = new
SqlConnection(C onfigurationSet tings.AppSettin gs["SQLConnectionS tring"]);
SqlDataAdapter SQLda = new SqlDataAdapter( strSQL,myConnec tion);
SQLda.Fill(ds, "SQLNewStar t");
return ds;
}
protected void DataGrid1_PageI ndexChanged(obj ect source,
System.Web.UI.W ebControls.Data GridPageChanged EventArgs e)
{
try
{
DataGrid1.Curre ntPageIndex = e.NewPageIndex;
BindGrid();
}
catch (Exception Exp)
{
string Error = Exp.Message;
}
}
protected void BindOrdersGrid( object sender, DataListItemEve ntArgs
e)
{
ListItemType oType = new ListItemType();
oType = (ListItemType)( e.Item.ItemType );
if (oType == ListItemType.Se lectedItem)
{
string sKey = dtl1.DataKeys[e.Item.ItemInde x].ToString();
Session["Status"] = sKey;
DataGrid oGrid = new DataGrid();
oGrid = (DataGrid)(e.It em.FindControl( "dgr1"));
Session["Datagrid"]= oGrid;
oGrid.PagerStyl e.Mode = PagerMode.Numer icPages;
oGrid.PageSize = 2;
oGrid.DataSourc e = GetOrders(sKey) ;
oGrid.DataBind( );
}
}
private void BindNewGrid(str ing currentState, DataGrid oGrid)
{
// DataGrid oGrid = new DataGrid();
//
// oGrid = (DataGrid)(e.It em.FindControl( "dgr1"));
oGrid.PagerStyl e.Mode = PagerMode.Numer icPages;
oGrid.PagerStyl e.PageButtonCou nt = 5;
oGrid.PageSize = 4;
oGrid.DataSourc e = GetOrders(curre ntState);
oGrid.DataBind( );
}
protected void PageIndexChange d(object source,
System.Web.UI.W ebControls.Data GridPageChanged EventArgs e)
{
try
{
DataGrid oGrid = new DataGrid();
// oGrid = (DataGrid)(dtl1 .FindControl("d gr1"));
oGrid = (DataGrid)(Sess ion["Datagrid"]);
oGrid.CurrentPa geIndex = e.NewPageIndex;
oGrid.PagerStyl e.Mode = PagerMode.Numer icPages;
oGrid.PageSize = 2;
oGrid.DataSourc e = GetOrders((stri ng)Session["Status"]);
oGrid.DataBind( );
}
catch (Exception Exp)
{
string Error = Exp.Message;
}
}
private DataSet GetOrders(strin g sKey)
{
string sSelect;
sSelect = "SELECT Orders.OrderID, Orders.OrderDat e, " +
"Orders.Require dDate, Orders.ShippedD ate, Orders.Freight, " +
"Shippers.Compa nyName As ShipperName " +
"FROM Orders JOIN Shippers " +
"ON Orders.ShipVia = Shippers.Shippe rID " +
"WHERE CustomerID='" + sKey + "'";
return GetReader(sSele ct);
}
protected void DoItemSelect(ob ject sender,DataList CommandEventArg s
e)
{
if (e.CommandName == "Select")
{
dtl1.SelectedIn dex = e.Item.ItemInde x;
dtl1.DataSource = GetCustomers();
dtl1.DataBind() ;
}
if (e.CommandName == "UnSelect")
{
dtl1.SelectedIn dex = -1;
dtl1.DataSource = GetCustomers();
dtl1.DataBind() ;
}
}
}
}
Following is the Simplegrid.aspx file:
<%@ Page language="c#" Codebehind="Sim pleGrid.aspx.cs "
AutoEventWireup ="false" Inherits="TestC Project.WebForm 1" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>WebForm1 </title>
<meta name="GENERATOR " Content="Micros oft Visual Studio 7.0">
<meta name="CODE_LANG UAGE" Content="C#">
<meta name="vs_defaul tClientScript" content="JavaSc ript">
<meta name="vs_target Schema"
content="http://schemas.microso ft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING= "GridLayout ">
<form id="Form1" method="post" runat="server">
<TABLE id="Table1" style="Z-INDEX: 104; LEFT: 8px; WIDTH: 448px;
POSITION: absolute; TOP: 8px; HEIGHT: 438px" cellSpacing="1"
cellPadding="1" width="448" border="1">
<TR>
<TD>
<asp:DataGrid id="DataGrid1" AutoGenerateCol umns="false"
OnPageIndexChan ged="DataGrid1_ PageIndexChange d" AllowPaging="Tr ue"
runat="server">
<Columns>
<asp:BoundColum n DataField="Cate goryId"
HeaderText="Cat egoryId" ItemStyle-Wrap="false"></asp:BoundColumn >
<asp:BoundColum n DataField="Cate goryName"
HeaderText="Cat egoryName" ItemStyle-Wrap="false"></asp:BoundColumn >
<asp:BoundColum n DataField="desc ription"
HeaderText="des cription" ItemStyle-Wrap="false"></asp:BoundColumn >
</Columns>
</asp:DataGrid></TD>
</TR>
<TR>
<TD>
<asp:DataList DataKeyField="C ustomerID" id="dtl1" runat="server"
Width="397px" OnItemCommand=" DoItemSelect"
OnItemDataBound ="BindOrdersGri d">
<HeaderStyle Font-Bold="True" ForeColor="#fff fff"
BackColor="#b50 055" />
<FooterStyle Font-Bold="True" ForeColor="#fff fff"
BackColor="#b50 055" />
<ItemStyle BackColor="#FFF 7E7" VerticalAlign=" Top" />
<AlternatingIte mStyle BackColor="#FFF FC0" />
<HeaderTemplate >
<b>Customer List</b>
</HeaderTemplate>
<ItemTemplate >
<asp:ImageButto n CommandName="Se lect"
ImageUrl="~/images/click-down.gif" Width="16" Height="17"
runat="server" AlternateText=" Click to view orders" ID="Imagebutton 1"
/>
<%# DataBinder.Eval (Container.Data Item, "CustomerID ") %>
<b>
<%# DataBinder.Eval (Container.Data Item, "CompanyNam e") %>
</b>
<%# DataBinder.Eval (Container.Data Item, "City") %>
<%# DataBinder.Eval (Container.Data Item, "Country") %>
Phone:
<%# DataBinder.Eval (Container.Data Item, "Phone") %>
</ItemTemplate>
<SelectedItemTe mplate>
<asp:ImageButto n CommandName="Un Select"
ImageUrl="~/images/click-up.gif" Width="16" Height="17" runat="server"
AlternateText=" Click to hide orders" ID="Imagebutton 2" />
<%# DataBinder.Eval (Container.Data Item, "CustomerID ") %>
<b>
<%# DataBinder.Eval (Container.Data Item, "CompanyNam e") %>
</b>
<%# DataBinder.Eval (Container.Data Item, "City") %>
<%# DataBinder.Eval (Container.Data Item, "Country") %>
Phone:
<%# DataBinder.Eval (Container.Data Item, "Phone") %>
<asp:DataGrid id="dgr1" runat="server" BorderStyle="No ne"
BorderWidth="0" BackColor="#DEB A84" CellPadding="3" CellSpacing="0"
OnPageIndexChan ged="PageIndexC hanged" AllowPaging="Tr ue"
DataKeyField="O rderID" Width="100%" AutoGenerateCol umns="False">
<HeaderStyle BackColor="#c0c 0c0" />
<Columns>
<asp:BoundColum n DataField="Ship perName" HeaderText="Via "
ReadOnly="True" />
</Columns>
</asp:DataGrid>
</SelectedItemTem plate>
</asp:DataList></TD>
</TR>
<TR>
<TD></TD>
</TR>
</TABLE>
<asp:Label id="Label1" style="Z-INDEX: 103; LEFT: 16px; POSITION:
absolute; TOP: 462px" runat="server"> Label</asp:Label>
</form>
</body>
</HTML>
Thanks.
