Populate a ListBox in an Winforms application using ado.net.

[Cind]

I have to populate a listbox with details of a particular customer.
For example, you may want to view a Customer with the current products for that Customer. List Box should display the current prouct name registered by that customer.
Here goes my try,
Form1.cs:
private void ProductsRegiste red(string UserName, string productID)
{
UserData.Produc tsRegistered proreg = userdata.GetReg isteredProducts (UserName, productID);

listBox1.DataSo urce = proreg;
listBox1.Displa yMember = proreg.ProductN ame;
}

userdata.cs:
public struct ProductsRegiste red
{
public string ProductID;
public string ProductName;
}

public ProductsRegiste red GetRegisteredPr oducts(string UserName, string ProductID)
{

ArrayList arlist = new ArrayList();
ProductsRegiste red proreg = new ProductsRegiste red();
DataTable dtUsers = new DataTable();
string strSQL = "SELECT DISTINCT a.UserID,a.Prod uctID,b.[Name] FROM myacc_userregis teredProducts a inner join InstallationPro duct b on a.ProductID=b.[ID]inner join myacc_users c ON a.UserID=c.[ID]WHERE c.UserName ='" + UserName + "'";
SqlConnection sqlConn = new SqlConnection(" server=Intra; database=vc; uid=sa; pwd=ore");
sqlConn.Open();
SqlCommand cmd = new SqlCommand(strS QL, sqlConn);
SqlDataReader dr = cmd.ExecuteRead er();
if (dr.Read())
{

proreg.ProductI D = dr[0].ToString();
proreg.ProductN ame = dr[1].ToString();

}
dr.Close();
sqlConn.Close() ;
//listBox1.DataSo urce = proreg;
//listBox1.Displa yMember = "productNam e";

}

Help is appreciated!Tha nks in Advance!

[nateraaaa]

You need to call listbox1.DataBi nd() to bind your datasource to your listbox control.

Nathan