databinding in listbox using vb.net 2005

[peterparker]

---

hello bro,

I have question regarding my codes here:
this code is working:
private void btnload_Click(object sender, EventArgs e)
{

conn.Open();
ds = new DataSet();
cmd = new OleDbCommand("Select Ip from IP", conn);

da = new OleDbDataAdapter(cmd);
da.Fill(ds,"IP");
lstip.DataSource = ds.Tables["IP"];
lstip.DisplayMember = "Ip";
conn.Close();

}
private void lstip_SelectedIndexChanged(object sender, EventArgs e)
{

BindaData();

}

This is not working: I want to bind the data from listboox bro, inig click nako sa items from listboox mo display unta sa mga txtbox iyang remaining colums. thank you so much.
private void BindaData()
{

this.txtname.DataBindings.Clear();
this.txtdepartment.DataBindings.Clear();
this.txtpcname.DataBindings.Clear();
this.txtremarks.DataBindings.Clear();

this.lstip.DataSource = ds.Tables["IP"];
this.txtname.DataBindings.Add("Text", ds,"User");
this.txtdepartment.DataBindings.Add("Text", ds, "IP.Department");
this.txtpcname.DataBindings.Add("Text", ds, "IP.ComputerName");
this.txtremarks.DataBindings.Add("Text", ds, "IP.Remarks");
}
private void BindaData()

conn.Open();
cmd = new OleDbCommand("Select * from IP Where Ip = ' " + this.lstip.SelectedItem + " ' ", conn);
dr = cmd.ExecuteReader();

while(dr.Read())
{

this.txtdepartment.Text = dr[1].ToString();
this.txtname.Text = dr[2].ToString();
this.txtpcname.Text = dr[3].ToString();
this.txtremarks.Text = dr[4].ToString();
}
dr.Close();
conn.Close();

[trojan_vaughn]

First fragment:
Adding DataBindings takes binding object as parameter so syntax should be


this.txtname..DataBindings.Add( new Binding("Text", ds, "IP.Department"));



private void BindaData()
{

this.txtname.DataBindings.Clear();
this.txtdepartment.DataBindings.Clear();
this.txtpcname.DataBindings.Clear();
this.txtremarks.DataBindings.Clear();

this.lstip.DataSource = ds.Tables["IP"];
this.txtname.DataBindings.Add("Text", ds,"User");
this.txtdepartment.DataBindings.Add("Text", ds, "IP.Department");
this.txtpcname.DataBindings.Add("Text", ds, "IP.ComputerName");
this.txtremarks.DataBindings.Add("Text", ds, "IP.Remarks");
}


//what are the codes below for?

private void BindaData()

conn.Open();
cmd = new OleDbCommand("Select * from IP Where Ip = ' " + this.lstip.SelectedItem + " ' ", conn);
dr = cmd.ExecuteReader();

while(dr.Read())
{

this.txtdepartment.Text = dr[1].ToString();
this.txtname.Text = dr[2].ToString();
this.txtpcname.Text = dr[3].ToString();
this.txtremarks.Text = dr[4].ToString();
}
dr.Close();
conn.Close();

[peterparker]

@trojan_vaughn, thanks bro, private void bindaData() ako rana gihimo as an alternative code to bind a data kay d man gud mo work ang first code nako, so im trying to use datareader, so d japon mo work man gud, naka try naman ko ug use sa imong suggested code bro, pero still doesnt work ambot lang kaha sa 2008 na visual studio, 2005 man gud akong gamit karon. lamat bro.

[trojan_vaughn]

Way blema peterparker!

if you want to use data reader and expecting 1 row in the resultset i think you should use

if(dr.Read())
{
// code here.
}

But if the bindings work, then no need to do this.

[peterparker]

ang akong value sa listbox bro d man ma capture sa akong query nga.selecteditem, mao cguro ni reason nganong dili ma bind ang data, napa lain na way sa pagcapture sa value sa listbox bro? lamat bro