C#:Change repeater data based on dropdownlist

Fares Ayyad

10y4.5k.NET

Hello

I'm working on project that have a repeater and a dropdownlist.

DropDownList with AutoPostBack:

"ddlTer" runat="server" AutoPostBack="true" >

This is the repeater in .aspx page:

asp:Repeater ID="rptDep" runat="server" >
class="table table-hover table-striped table-condensed table-bordered table-responsive" >
Deposit No.
Territory
Deposit Date
Custom Declaration No.
Goods Description
Units Balance
WT Balance
Goods Balance Amount(LC)
<%#Eval("cdin_Serial") %>
<%#Eval("terr") %>
<%#Eval("customDec") %>
<%#Eval("cdin_startunstufdate") %>
<%#Eval("cdin_goodsDesc") %>
<%#Eval("unitsBal") %>
<%#Eval("wtBal") %>
<%#Eval("currBal") %>

How i populate Data in DropDownList:

var ids = new List<int> { -1342177274, -1073741819, -805306364, -536870909, -268435454, 1, 268435456 };
var tc = (from t in db.Territories
where ids.Contains(t.Terr_TerritoryID)
select new
{
terCapt = t.Terr_Caption,
terID = t.Terr_TerritoryID
}
);
ddlTer.DataSource = tc.ToList();
ddlTer.DataValueField = "terID";
ddlTer.DataTextField = "terCapt";
ddlTer.SelectedValue = "-1073741819";
ddlTer.DataBind();

Integer declaration to know the select value.

int selected = int.Parse(ddlTer.SelectedValue);

Query to select data from database, and passing the Selected value

var query = (from cdin in db.CDIndexes
join comp in db.Companies on cdin.cdin_CompanyId equals comp.Comp_CompanyId
join terr in db.Territories on cdin.cdin_Secterr equals terr.Terr_TerritoryID
join gds in db.Goods on cdin.cdin_CDIndexID equals gds.good_GoodsID
where cdin.cdin_Status == "InProgress" &&
cdin.cdin_CompanyId == 83 &&
cdin.cdin_Secterr == selected &&
cdin.cdin_CDIndexID == 4 &&
cdin.cdin_Deleted == null &&
comp.Comp_Deleted == null //&& cdin.cdin_Secterr= -1073741819 && cdin.cdin_CompanyId=83 cdin.cdin_Deleted = null && comp.Comp_Deleted = null &&
select new
{
cdin_Serial = cdin.cdin_Serial,
cdin_startunstufdate = cdin.cdin_startunstufdate,
cdin_goodsDesc = cdin.cdin_goodsDesc,
terr = terr.Terr_Caption,
customDec = cdin.cdin_Customdeclar,
unitsBal = cdin.cdin_RemainPackages,
wtBal = cdin.cdin_RemainWT,
currBal = cdin.cdin_ActMortgageAmnt,
gdsDesc = gds.good_Name,
gdUnitBal = gds.good_RemainPackages,
gdWtBal = gds.good_RemainWT,
}
.ToList();

Binding the repeater:

rptDep.DataSource = query;
rptDep.DataBind();

Note that : all the code above is warped by if(!isPostBack)

what i want is how to change the data in repater if the dropdown list selected item changed.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Francis Susaimichael10y ago
You can consider to use session variable like below. So you should change your code as below:
if(!Page.IsPostBack) // First time it will contact the DB and fetch the result
{
// Your queries
varquery=(fromcdinindb.CDIndexes
joincompindb.Companiesoncdin.cdin_CompanyIdequalscomp.Comp_CompanyId
jointerrindb.Territoriesoncdin.cdin_Secterrequalsterr.Terr_TerritoryID
joingdsindb.Goodsoncdin.cdin_CDIndexIDequalsgds.good_GoodsID
wherecdin.cdin_Status=="InProgress"&&
cdin.cdin_CompanyId==83&&
cdin.cdin_Secterr==selected&&
cdin.cdin_CDIndexID==4&&
cdin.cdin_Deleted==null&&
comp.Comp_Deleted==null//&&cdin.cdin_Secterr=-1073741819&&cdin.cdin_CompanyId=83cdin.cdin_Deleted=null&&comp.Comp_Deleted=null&&
selectnew
{
cdin_Serial=cdin.cdin_Serial,
cdin_startunstufdate=cdin.cdin_startunstufdate,
cdin_goodsDesc=cdin.cdin_goodsDesc,
terr=terr.Terr_Caption,
customDec=cdin.cdin_Customdeclar,
unitsBal=cdin.cdin_RemainPackages,
wtBal=cdin.cdin_RemainWT,
currBal=cdin.cdin_ActMortgageAmnt,
gdsDesc=gds.good_Name,
gdUnitBal=gds.good_RemainPackages,
gdWtBal=gds.good_RemainWT,
}
.ToList();
// Put your list into session variable
Session["yourlist"] = query;
// Bind the list
rptDep.DataSource=query;
rptDep.DataBind();
}
else // Next time get the session variable and bind it to the grid/repeater
{
var list = Session["yourlist"];
// Bind the list
rptDep.DataSource=query;
rptDep.DataBind();

}
0
Midhun Tp10y ago
Hi,
You can call a selected index change function for dropdown and inside that function you can call repeater binding method. In that method you can make necessary changes to show data based on dropdown value.
0
ali tuncer10y ago
you will bind repeater again on dropdownlist selectedindexchanged event..
check this article for selectedindexchanged event
http://www.aspsnippets.com/Articles/ASPNet-DropDownList-SelectedIndexChanged-event-example-in-C-and-VBNet.aspx
0