| Author: Rajesh(March-2008 Winner) 30 Aug 2008 | Member Level: Gold | Rating:  Points: 0 |
hi,
You should use Ajax.
|
| Author: shazia khan 30 Aug 2008 | Member Level: Gold | Rating: Points: 6 |
hii anu
write like this in page load
if (!IsPostBack)
{
con.Open();
SqlDataAdapter s = new SqlDataAdapter("select name from lco order by name", con);
DataTable dt = new DataTable();
s.Fill(dt);
foreach (DataRow da in dt.Rows)
{
ListItem li = new ListItem();
li.Text = da["name"].ToString();
lco_name.Items.Add(li);
}
con.Close();
}
and on the selected indix change event write this
protected void DropDownList1_SelectedIndexChanged(object sender, System.EventArgs e)
{
con.Open();
SqlDataAdapter sa = new SqlDataAdapter("select area from lco where area = '" + ddl1.SelectedItem.Text + "' ", con);
DataTable d = new DataTable();
sa.Fill(d);
spo_name.Items.Clear();
foreach (DataRow db in d.Rows)
{
ListItem li = new ListItem();
li.Text = db["area"].ToString();
spo_name.Items.Add(li);
}
spo_name.SelectedIndex = 0;
con.Close();
}
|
| Author: abhay 30 Aug 2008 | Member Level: Gold | Rating: Points: 6 |
if you want do it in ajax please refer
http://www.dotnetspider.com/resources/20324-bind-dropdown-according-data-another.aspx
|
| Author: abhay 30 Aug 2008 | Member Level: Gold | Rating: Points: 6 |
if you want code for this in c#
then
first bind 1st drop down like this
string selectcategory = "select PK_SUBJECTMENU_ID,TITLE_MENU from SUBJECTMENU";
connection ob1 = new connection();
ddlmenu.DataSource=ob1.sqlcommand(selectcategory).ExecuteReader();
ddlmenu.DataTextField="TITLE_MENU";
ddlmenu.DataValueField="PK_SUBJECTMENU_ID";
ddlmenu.DataBind();
ListItem hash=new ListItem("--Select Category--","-1");
ddlmenu.Items.Insert(0,hash);
connection obj=new connection();
DataTable dtmenu = obj.connectiondatatable(selectcategory);
then
in this function you can bind second dropdown
like this
private void ddlcategory_SelectedIndexChanged(object sender, System.EventArgs e)
{
connection ob=new connection();
string selectsubmenu = "SELECT PK_PRIMARY_KEY, TITLE_SUBMENU FROM SUBJECT_SUBMENU WHERE FK_SUBJECTMENU_ID = "+ Convert.ToInt32(ddlcategory.SelectedItem.Value) + " ORDER BY TITLE_SUBMENU";
ob.datatablebind(selectsubmenu);
if( ob.datatablebind(selectsubmenu).Rows.Count> 0)
{
ddlsubcategory.DataSource=ob.sqlcommand(selectsubmenu).ExecuteReader();
ddlsubcategory.DataTextField = "TITLE_SUBMENU";
ddlsubcategory.DataValueField = "PK_PRIMARY_KEY";
ddlsubcategory.DataBind();
ListItem lt1 = new ListItem("--Select Any One--","-1");
ddlsubcategory.Items.Insert(0,lt1);
}
else
{
ddlsubcategory.Items.Clear();
}
}
|
| Author: Arun 30 Aug 2008 | Member Level: Bronze | Rating: Points: 6 |
write like this in page load
if (!IsPostBack)
{
con.Open();
SqlDataAdapter s = new SqlDataAdapter("select name from lco order by name", con);
DataTable dt = new DataTable();
s.Fill(dt);
foreach (DataRow da in dt.Rows)
{
ListItem li = new ListItem();
li.Text = da["name"].ToString();
lco_name.Items.Add(li);
}
con.Close();
}
and on the selected indix change event write this
protected void DropDownList1_SelectedIndexChanged(object sender, System.EventArgs e)
{
con.Open();
SqlDataAdapter sa = new SqlDataAdapter("select area from lco where area = '" + ddl1.SelectedItem.Text + "' ", con);
DataTable d = new DataTable();
sa.Fill(d);
spo_name.Items.Clear();
foreach (DataRow db in d.Rows)
{
ListItem li = new ListItem();
li.Text = db["area"].ToString();
spo_name.Items.Add(li);
}
spo_name.SelectedIndex = 0;
con.Close();
}
ARUN.A
|