1
Answer

how to do paging in listview??

Sreenish

Sreenish

9y
483
1
hello ..
 
 
I have listview in that had set paging ...but am unable do edit the record  in that paging...
 
 
am sharing code..any help appreciated..
 
 
Source::
 
 
<div id="Main" style=" height:100%;width:100%">
<div id="large" style=" height:12%;width:100%">
<div style="float:left;height:100%;width:12%; border:1px solid black; text-align:center">
CustomerId
<asp:TextBox ID="txtCustomerId" runat="server" BorderColor="Black" BackColor="LightBlue" ReadOnly="true"></asp:TextBox>
</div>
<div style="float:left;height:100%;width:12%;border:1px solid black; text-align:center">
Name
<asp:TextBox ID="txtName" runat="server" BorderColor="Black" BackColor="LightBlue" onkeydown="return isAlpha(event.keyCode);" MaxLength="25" ontextchanged="txtName_TextChanged"></asp:TextBox>
<asp:RequiredFieldValidator ID="rfv2" runat="server" ErrorMessage="" SetFocusOnError="true" ControlToValidate="txtName" ValidationGroup="a"></asp:RequiredFieldValidator>
</div>
<div style="float:left;height:100%;width:12%;border:1px solid black;text-align:center">
Country
<asp:TextBox ID="txtCountry" runat="server" BorderColor="Black" BackColor="LightBlue" onkeydown="return isAlpha(event.keyCode);" MaxLength="20"></asp:TextBox>
<asp:RequiredFieldValidator ID="rfv3" runat="server" ErrorMessage="" SetFocusOnError="true" ControlToValidate="txtCountry" ValidationGroup="a"></asp:RequiredFieldValidator>
</div>
<div style="float:left;height:100%;width:5%;border:1px solid black;text-align:center">
<br />
<asp:Button ID="btnadd" runat="server" Text="Insert" BackColor="Aqua" onclick="btnadd_Click" ValidationGroup="a"/>
</div>
<div style="float:left;height:100%;width:5%;border:1px solid black;text-align:center">
<br />
<asp:Button ID="btncan" runat="server" Text="Clear" BackColor="Aqua" onclick="btncan_Click"/>
</div>
<div style="float:left;height:100%;width:54%"></div>
</div>
<asp:ListView ID="ListView1" runat="server" onitemcanceling="ListView1_ItemCanceling" onitemediting="ListView1_ItemEditing" onitemdatabound="ListView1_ItemDataBound"
onitemupdating="ListView1_ItemUpdating" onitemdeleting="ListView1_ItemDeleting" ItemPlaceholderID="itemplaceholder" GroupPlaceholderID="groupplaceholder" OnPagePropertiesChanging="OnPagePropertiesChanging">
<LayoutTemplate>
<div>
<asp:PlaceHolder ID="groupplaceholder" runat="server"/>
<tr>
<td colspan="3" >
<%-- This part used for paging --%>
<asp:DataPager ID="DataPager1" runat="server" PagedControlID="ListView1" PageSize="3" style="width:90%" onprerender="DataPager1_PreRender" >
<Fields>
<asp:NextPreviousPagerField ButtonType="Link" ShowFirstPageButton="false" ShowPreviousPageButton="true"
ShowNextPageButton="false" />
<asp:NumericPagerField ButtonType="Link" />
<asp:NextPreviousPagerField ButtonType="Link" ShowNextPageButton="true" ShowLastPageButton="false"
ShowPreviousPageButton="false" />
</Fields>
</asp:DataPager>
<%-- end --%>
</td>
</tr>
</div>
</LayoutTemplate>
<GroupTemplate>
<div>
<asp:PlaceHolder ID="itemplaceholder" runat="server"/>
</div>
</GroupTemplate>
<ItemTemplate>
<div id="large2" style="height:88%;width:100%">
<div style="float:left;height:100%;width:12%; border:1px solid black; text-align:center">
<asp:Label ID="lblcustomerid" runat="server" Text='<%#Eval("CustomerId")%>' Width="165px" Height="22px"></asp:Label>
</div>
<div style="float:left;height:100%;width:12%;border:1px solid black; text-align:center" >
<asp:Label ID="lblname" runat="server" Text='<%#Eval("Name")%>' Width="165px" Height="22px"></asp:Label>
</div>
<div style="float:left;height:100%;width:12%;border:1px solid black; text-align:center">
<asp:Label ID="lblcountry" runat="server" Text='<%#Eval("Country")%>' Width="165px" Height="22px"></asp:Label>
</div>
<div style="float:left;height:100%;width:5%;border:1px solid black; text-align:center">
<asp:Button ID="btnedit" runat="server" CommandName="Edit" Text="Edit" BackColor="Aqua"/>
</div>
<div style="float:left;height:100%;width:5%;border:1px solid black; text-align:center">
<asp:Button ID="btndelete" runat="server" CommandName="Delete" BackColor="Aqua" OnClientClick="return confirm('Are you sure you want to delete?');" Text="Delete"/>
</div>
<div style="float:left;height:100%;width:64%;">
<asp:Label runat="server" ID="lblstatus" Text='<%#Eval("Status")%>' Visible="false" Width="250px"></asp:Label>
</div>
</div>
</ItemTemplate>
</asp:ListView>
</div>
 
 
Code::
 
DataTable dt = new DataTable();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
dt.Columns.Add("CustomerId");
dt.Columns.Add("Name");
dt.Columns.Add("Country");
dt.Columns.Add("Status");
ViewState["Details"] = dt;
ListView1.DataSource = dt;
ListView1.DataBind();
txtCustomerId.Text = (dt.Rows.Count + 1).ToString();
txtName.Focus();
}
}
protected void OnPagePropertiesChanging(object sender, PagePropertiesChangingEventArgs e)
{
(ListView1.FindControl("DataPager1") as DataPager).SetPageProperties(e.StartRowIndex, e.MaximumRows, false);
DataTable dt = new DataTable();
dt = (DataTable)ViewState["Details"];
DataRow dr = dt.NewRow();
dr["CustomerId"] = (dt.Rows.Count + 1).ToString();
dr["Name"] = txtName.Text;
dr["Country"] = txtCountry.Text;
dr["Status"] = "Saved";
DataPager DataPager1 = ((DataPager)ListView1.Items[e.StartRowIndex].FindControl("DataPager1"));
int PageCount = (DataPager1.TotalRowCount * DataPager1.PageSize);
if (PageCount * DataPager1.PageSize != DataPager1.TotalRowCount)
{
PageCount = PageCount + 1;
}
//for (int i = 0; i < PageCount; i++)
//{
//}
//ddl.Items.FindByValue(CurrentPage.ToString()).Selected = true;
ListView1.DataSource = dt;
ListView1.DataBind();
}
protected void btnadd_Click(object sender, EventArgs e)
{
bool IsRecordExist = false;
DataTable dt = new DataTable();
dt = (DataTable)ViewState["Details"];
DataRow dr = dt.NewRow();
IsRecordExist = CheckRecorExist();
if (IsRecordExist == false)
{
dr["CustomerId"] = (dt.Rows.Count + 1).ToString();
dr["Name"] = txtName.Text;
dr["Country"] = txtCountry.Text;
dr["Status"] = "Saved";
dt.Rows.Add(dr);
ViewState["Details"] = ListView1.DataSource = dt;
ListView1.DataBind();
RefreshHeader();
}
else
{
dt = (DataTable)ViewState["Details"];
DataRow drUpdate = dt.Select("CustomerId=" + txtCustomerId.Text).FirstOrDefault();
drUpdate["Name"] = txtName.Text;
drUpdate["Country"] = txtCountry.Text;
drUpdate["Status"] = ((Label)ListView1.Items[0].FindControl("lblstatus")).Text = "Modified";
dr["Status"] = "Modified";
ViewState["Details"] = ListView1.DataSource = dt;
ListView1.DataBind();
RefreshHeader();
}
}
private bool CheckRecorExist()
{
bool IsExistRecord = false;
foreach (ListViewItem item in ListView1.Items)
{
if (((Label)ListView1.Items[item.DataItemIndex].FindControl("lblcustomerid")).Text == txtName.Text)
{
IsExistRecord = true;
break;
}
}
return IsExistRecord;
}
private void RefreshHeader()
{
DataTable dt = new DataTable();
dt = (DataTable)ViewState["Details"];
int Row = dt.Rows.Count + 1;
txtCustomerId.Text = Row.ToString();
txtName.Text = "";
txtCountry.Text = "";
txtName.Focus();
}
protected void ListView1_ItemEditing(object sender, ListViewEditEventArgs e)
{
ListView1.EditIndex = e.NewEditIndex;
DataTable dt = (DataTable)ViewState["Details"];
string EditNo = ((Label)ListView1.Items[e.NewEditIndex].FindControl("lblCustomerId")).Text;
((Label)ListView1.Items[e.NewEditIndex].FindControl("lblstatus")).Text = "Saved";
DataRow dr = dt.Select("CustomerId=" + EditNo).FirstOrDefault();
dr["Status"] = ((Label)ListView1.Items[0].FindControl("lblstatus")).Text;
dr["Status"] = "Saved";
ViewState["Details"] = ListView1.DataSource = dt;
txtCustomerId.Text = ((Label)ListView1.Items[e.NewEditIndex].FindControl("lblcustomerid")).Text;
txtName.Text = ((Label)ListView1.Items[e.NewEditIndex].FindControl("lblname")).Text;
txtCountry.Text = ((Label)ListView1.Items[e.NewEditIndex].FindControl("lblcountry")).Text;
txtName.Focus();
}
protected void ListView1_ItemCanceling(object sender, ListViewCancelEventArgs e)
{
ListView1.EditIndex = -1;
DataTable dt = (DataTable)ViewState["Details"];
ViewState["Details"] = dt;
ListView1.DataSource = dt;
ListView1.DataBind();
}
protected void ListView1_ItemUpdating(object sender, ListViewUpdateEventArgs e)
{
TextBox txtCustomerId = ((TextBox)ListView1.Items[e.ItemIndex].FindControl("txtCustomerId"));
TextBox txtName = ((TextBox)ListView1.Items[e.ItemIndex].FindControl("txtName"));
TextBox txtCountry = ((TextBox)ListView1.Items[e.ItemIndex].FindControl("txtCountry"));
ListView1.EditIndex = -1;
DataTable dt = (DataTable)ViewState["Details"];
ViewState["Details"] = dt;
ListView1.DataSource = dt;
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[e.ItemIndex]["CustomerId"] = txtCustomerId.Text;
dt.Rows[e.ItemIndex]["Name"] = txtName.Text;
dt.Rows[e.ItemIndex]["Country"] = txtCountry.Text;
}
ListView1.DataBind();
}
protected void ListView1_ItemDeleting(object sender, ListViewDeleteEventArgs e)
{
string cusid = ((Label)ListView1.Items[e.ItemIndex].FindControl("lblcustomerid")).Text;
((Label)ListView1.Items[e.ItemIndex].FindControl("lblstatus")).Text = "Deleted";
DataTable dt = (DataTable)ViewState["Details"];
DataRow dr = dt.Select("CustomerId=" + cusid).FirstOrDefault();
dr["Status"] = ((Label)ListView1.Items[e.ItemIndex].FindControl("lblstatus")).Text;
dr["Status"] = "Deleted";
ViewState["Details"] = ListView1.DataSource = dt;
ListView1.DataBind();
RefreshHeader();
txtName.Focus();
}
protected void btncan_Click(object sender, EventArgs e)
{
txtName.Text = "";
txtCountry.Text = "";
}
protected void ListView1_ItemDataBound(object sender, ListViewItemEventArgs e)
{
if (e.Item.ItemType == ListViewItemType.DataItem)
{
DataTable dt = (DataTable)ViewState["Details"];
DataRow dr = ((System.Data.DataRowView)e.Item.DataItem).Row;
switch (dr["Status"].ToString())
{
case "Deleted":
{
btnadd.Visible = true;
btncan.Visible = true;
((Button)e.Item.FindControl("btnedit")).Visible = false;
((Button)e.Item.FindControl("btndelete")).Visible = false;
((Label)e.Item.FindControl("lblcustomerid")).BackColor = Color.Red;
((Label)e.Item.FindControl("lblname")).BackColor = Color.Red;
((Label)e.Item.FindControl("lblcountry")).BackColor = Color.Red;
break;
}
case "Saved":
{
btnadd.Visible = true;
btncan.Visible = true;
((Button)e.Item.FindControl("btnedit")).Visible = true;
((Button)e.Item.FindControl("btndelete")).Visible = true;
break;
}
case "Modified":
{
//e.Item.DataItem = Color.Empty;
btnadd.Visible = true;
btncan.Visible = true;
((Button)e.Item.FindControl("btnedit")).Visible = true;
((Button)e.Item.FindControl("btndelete")).Visible = true;
break;
}
default:
{
break;
}
}
}
}
protected void txtName_TextChanged(object sender, EventArgs e)
{
int x = 0;
DataTable dt = (DataTable)ViewState["Details"];
ViewState["Details"] = dt;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((txtName.Text == dt.Rows[i]["Name"].ToString() && dt.Rows[i]["Country"].ToString() != i + 1.ToString()))
{
x = 1;
}
if (x == 1)
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Name Already Exists');", true);
txtName.Text = string.Empty;
}
else
{
}
}
}
 
here am facing if i edit the recordit is showing index error..must be non negative...page size is 3...so in second page if i edit it is showing index error...any help please.. 
Answers (1)
Next Recommended Forum