Prizes & Awards
My Profile
Active Members
TodayLast 7 Days
more...
|
 New Feature: Community Sites:
Create your own .NET community website and start earning from Google AdSense !
It's Free !
|
paging, sorting, link button in GridView
|
This code is for Aspx page:
In this code i have used NorthWind Database
asp:GridView ID="grcoll" runat="server" AutoGenerateColumns="false" DataKeyNames="orderId"
CssClass="mygrid" Width="100%" HeaderStyle-BackColor="white" BorderWidth="1"
RowStyle-BorderWidth="0" AllowPaging="true" AllowSorting="true" PageSize="20"
OnRowDataBound="grcoll_OnRowDataBound" OnRowCommand="grcoll_OnRowCommand" OnPageIndexChanging="grcoll_PageIndexChanging"
PagerStyle-HorizontalAlign="Center" OnSorting="grcoll_Sorting"
Columns
asp:BoundField DataField="OrderId" SortExpression="OrderId" HeaderText="Order Id" HeaderStyle-ForeColor="#78776b"
asp:BoundField DataField="OrderDate" SortExpression="OrderDate" HeaderText="Order Date" HeaderStyle-ForeColor="#78776b"
asp:BoundField DataField="ShippedDate" SortExpression="ShippedDate" HeaderText="Shipped Date" HeaderStyle-ForeColor="#78776b"
asp:TemplateField HeaderText="Action"
ItemTemplate
asp:LinkButton CssClass="links" ID="lnkView" runat="server" Text="View" CommandName="viewOrder" CommandArgument='<%#Eval("OrderId") %>'
/ItemTemplate
/asp:TemplateField
/Columns
/asp:GridView
now here is the code for aspx.cs
public partial class OrderDetail : System.Web.UI.Page
{
static string m_ConnectionString = System.Configuration.ConfigurationManager.AppSettings["conString"].ToString();
static string sort = "asc";
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (Request["custId"] != null)
{
bindGrid("OrderId", sort);
//bindGrid();
bindCutomerDetail();
}
}
}
protected void bindCutomerDetail()
{
try
{
string sql = "select * from Customers where customerId='" + Request["custId"].ToString() + "'";
SqlDataReader dr = DBAccess.ExecuteReader(m_ConnectionString, CommandType.Text, sql);
if (dr.HasRows)
{
dr.Read();
lblAddress.InnerHtml = dr["address"].ToString();
lblax.InnerHtml = dr["fax"].ToString();
lblCity.InnerHtml = dr["city"].ToString();
lblCompanyName.InnerHtml = dr["CompanyName"].ToString();
lblContactName.InnerHtml = dr["ContactName"].ToString();
lblContactTitle.InnerHtml = dr["ContactTitle"].ToString();
lblCountry.InnerHtml = dr["Country"].ToString();
lblPhone.InnerHtml = dr["phone"].ToString();
lblPostalCode.InnerHtml = dr["postalCode"].ToString();
lblRegion.InnerHtml = dr["region"].ToString();
}
dr.Dispose();
dr.Close();
}
catch(Exception ex)
{
Response.Write(ex.Message);
}
}
protected void bindGrid(string column, string expression)
{
lblcustomerId.Text = Request["custId"].ToString();
string sql = "select orderId,orderDate,shippedDate from Orders where CustomerId='" + Request["custId"].ToString() + "'";
DataSet ds = DBAccess.ExecuteDataset(m_ConnectionString, CommandType.Text, sql);
DataView dv = new DataView(ds.Tables[0]);
dv.Sort = column + " " + expression;
grcoll.DataSource = dv;
grcoll.DataBind();
if (ds.Tables[0].Rows.Count > 0)
{
}
else
{
lblmsg2.Text = "No records Found";
}
}
protected void grcoll_OnRowDataBound(object sender, GridViewRowEventArgs e)
{
}
protected void grcoll_OnRowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "viewOrder")
{
string OrderId;
OrderId = Convert.ToString(e.CommandArgument);
Response.Redirect("OrderDescription.aspx?OrderId=" + OrderId);
}
}
protected void grcoll_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
//This try block is used for Page Indexing
try
{
grcoll.PageIndex = e.NewPageIndex;
bindGrid("OrderId", sort);
}
catch (Exception ex)
{
//AppLib.SendErrorMail(ex.ToString());
// Response.Redirect("error.aspx");
}
}
protected void grcoll_Sorting(object sender, GridViewSortEventArgs e)
{
if (sort == "asc")
{
bindGrid(e.SortExpression, "desc");
sort = "desc";
}
else
{
bindGrid(e.SortExpression, "asc");
sort = "asc";
}
}
}
|
Responses
|
No responses found. Be the first to respond and make money from revenue sharing program.
|
|