Help on simple databinding ???

[serge calderara]

Dear all,

I have 2 tables from which I create a simple data relation:
Table1 has a field name ID which is retrive from a database
Table2 has fields ID and Name which is retrived from database

I have build a datarelation from Table 1 to Table 2 on field ID, so far so
good
Base on that my dataset contains following structure :

TABLE1: ID
TABLE2: ID, NAME

From that I have 2 list box name lstTable1 and lstTable 2
What I need to do is :
- bind the lstTable1 listbox on ID field of table 1 from dataset
- bind the lstTable2 listbox on field NAME and gets childs content field
issue from content of lstBox1

I am able to bind list box but the content of lstBox' contains all records
and NOT only records based on parent of lstBox1

How can I do that ?

thnaks for your help
regards
Serge

[carl]

Serge,

One approach is to use a row filter on the second list. Here's some
sample code:

/* Filter sample */

protected void Page_Load(objec t sender, EventArgs e)
{
if (!Page.IsPostBa ck)
bindData("1");
}

protected void DropDownList1_S electedIndexCha nged(object sender,
EventArgs e)
{
bindData(DropDo wnList1.Selecte dValue);
}

private void bindData(string selectedId)
{
DataSet myds = GetDataSet();

// Initialize Drop Down List 1
DropDownList1.D ataSource = myds.Tables["TableA"];
DropDownList1.D ataTextField = "ID";
DropDownList1.D ataValueField = "ID";

// Bind Drop Down List 1
DropDownList1.D ataBind();
DropDownList1.C learSelection() ;
DropDownList1.I tems.FindByValu e(selectedId).S elected = true;

// Initialize Drop Down List 2
DropDownList2.D ataSource = myds.Tables["TableB"];
DropDownList2.D ataTextField = "NAME";
DropDownList2.D ataValueField = "ID";

// Apply Filter to Drop Down List 2
myds.Tables[1].DefaultView.Ro wFilter =
string.Format(" ID = {0}", selectedId);

// Bind Drop Down List 2
DropDownList2.D ataBind();
}

/* End sample */

I simplified it a bit, but you can see that when the page loads or the
first DropDownList's index changes the second list is filtered.

-Carl

[serge calderara]

hi carl, thanks

the idea was to use the dtarelation object.
I manage to get it working

serge

"carl" wrote:

Serge,

One approach is to use a row filter on the second list. Here's some
sample code:

/* Filter sample */

protected void Page_Load(objec t sender, EventArgs e)
{
if (!Page.IsPostBa ck)
bindData("1");
}

protected void DropDownList1_S electedIndexCha nged(object sender,
EventArgs e)
{
bindData(DropDo wnList1.Selecte dValue);
}

private void bindData(string selectedId)
{
DataSet myds = GetDataSet();

// Initialize Drop Down List 1
DropDownList1.D ataSource = myds.Tables["TableA"];
DropDownList1.D ataTextField = "ID";
DropDownList1.D ataValueField = "ID";

// Bind Drop Down List 1
DropDownList1.D ataBind();
DropDownList1.C learSelection() ;
DropDownList1.I tems.FindByValu e(selectedId).S elected = true;

// Initialize Drop Down List 2
DropDownList2.D ataSource = myds.Tables["TableB"];
DropDownList2.D ataTextField = "NAME";
DropDownList2.D ataValueField = "ID";

// Apply Filter to Drop Down List 2
myds.Tables[1].DefaultView.Ro wFilter =
string.Format(" ID = {0}", selectedId);

// Bind Drop Down List 2
DropDownList2.D ataBind();
}

/* End sample */

I simplified it a bit, but you can see that when the page loads or the
first DropDownList's index changes the second list is filtered.

-Carl