Combat: ASP. NET DropDownList and ListBox are used together

2014-71 application of a portal network application sorting management

1: Receive parameters, initialize

int totalrows = 7;

int type = 0;

protected void Page_Load (object sender, EventArgs e)
{
Try
{
Type = Convert.ToInt32 (request.querystring["f_id"] = = null? "0": request.querystring["f_id"]);
Totalrows = Convert.ToInt32 ((request.querystring["columns"] = = null? "7": request.querystring["Columns"));
}
catch (Exception)
{
}
Finally
{
if (! Page.IsPostBack)
{
Bindtype (type. ToString ());
Bindapp (type. ToString ());
}
}

}

2: Binding Data Source (DropDownList and ListBox)

private void Bindtype (String type)
{
String SqlType = "SELECT ID as TypeId, Name as TypeName from View_dt_wkcommon_leveldicview where parentid= 4 order by Re Aloredernum ";

DataSet typeds = SqlHelper.ExecuteDataset (conn, CommandType.Text, SqlType);

if (typeds! = null && typeds. Tables[0]. Rows.Count > 0)
{

//Data source binding method

DataRow r = typeds. Tables[0]. NewRow ();
r["TypeId"] = "0";
r["TypeName"] = "Default";

Typeds. Tables[0]. Rows.insertat (r, 0);

Dropdownlist1.datasource = Typeds. Tables[0];
Dropdownlist1.datavaluefield = "TypeId";
Dropdownlist1.datatextfield = "TypeName";
Dropdownlist1.databind ();

　 Options how to add
DropDownList1.Items.Clear ();

DROPDOWNLIST1.ITEMS.ADD (New ListItem ("Default", "0"));

for (int i = 0; i < typeds. Tables[0]. Rows.Count; i++)
{
ListItem item = new ListItem (typeds. Tables[0]. rows[i]["TypeName"]. ToString (), Typeds. Tables[0]. rows[i]["TypeId"]. ToString ());
DROPDOWNLIST1.ITEMS.ADD (item);
}

ListItem it = DropDownList1.Items.FindByValue (type);

if (it = null)
{
DropDownList1.Items.FindByValue (Type). Selected = true;
}
Else
{
Dropdownlist1.selectedindex = 0;
}

}
Else
{
ListItem item = new ListItem ("No Classification", "0");
LISTBOX1.ITEMS.ADD (item);
}

}

Binding app
private void Bindapp (String type)
{
String condition = Type = = "0"? String. Format ("S.isdefault=1"): String. Format ("a.type={0}", type);

String Sqlapp = String. Format ("Select S.id, A.name, A.type, S.sort from Dt_work_nh_selfsettings as S, Dt_work_nh_selfdefapps as a where s.appid = a.ID and S.createrid = {0} and {1} ORDER by sort ", UserId, condition);

DataSet Appds = SqlHelper.ExecuteDataset (conn, CommandType.Text, Sqlapp);

if (Appds! = null && Appds. Tables[0]. Rows.Count > 0)
{
ListBox1.Items.Clear ();

for (int i = 0; i < Appds. Tables[0]. Rows.Count; i++)
{
ListItem item = new ListItem (Appds. Tables[0]. rows[i]["Name"]. ToString (), Appds. Tables[0]. rows[i]["Id"]. ToString ());
LISTBOX1.ITEMS.ADD (item);
}

Insertline ();
Listbox1.selectedindex = 0;
Lbmsg. Text = string. Format ("There are {0} apps for this category," Appds. Tables[0]. Rows.Count);
Lbstep.text = "";
ISDISENABLEBTN (FALSE);
}
Else
{
ListBox1.Items.Clear ();
LISTBOX1.ITEMS.ADD ("No related data item! ");
Lbmsg. Text = "Hint: The app category is not currently included in any app!" ";
Lbstep.text = "";
ISDISENABLEBTN (TRUE);
}
}

3:dropdownlist Data linkage

Rebind classification Information
protected void DropDownList1_SelectedIndexChanged (object sender, EventArgs e)
{
Bindapp (Dropdownlist1.selectedvalue);
}

Description

The listbox sometimes needs to add additional options to differentiate groupings, such as dividing each 4 options into a group, adding dividers between groups and groups

such as:---------------({0}) Platoon---------------

static string line = "---------------({0}) platoon---------------";

//Remove each row of separator lines
private void Removeline ()
{
int rows = listbox1.items.count/totalrows;
int others = ListBox1.Items.Count% Totalrows;

for (int m = 1; m <= rows; m++)
{
ListBox1.Items.Remove (New ListItem (string. Format (line, M), "1");
}

if (Others > 0)
{
ListBox1.Items.Remove (New ListItem (string. Format (line, rows + 1), "-1"));
}
}

Add each row of divider lines
private void Insertline ()
{
int rows = listbox1.items.count/totalrows;
int others = ListBox1.Items.Count% Totalrows;

for (int m = 1, n = 0; m <= rows; m++, n++)
{
int index = m * Convert.ToInt32 (totalrows) + N;
ListBox1.Items.Insert (Index, new ListItem (string. Format (line, M), "1");
}

if (Others > 0)
{
ListBox1.Items.Insert (ListBox1.Items.Count, New ListItem (string. Format (line, rows + 1), "-1"));
}
}

The effect is as follows: