Web Part drop down list

[castron]

Hi All,

I'm trying to create a web part that will populate data in a drop down menu, I'm not sure how to pass the data from the method where I'm retrieving the data to the CreateChildControls method. It compiles fine, but when I add the web part to the page, there is no data in the drop down menu. I'm new on the whole .net stuff. Any help will be greatly appreciate. Thanks in avance

here is my code I have so far

using System;
using System.Collections.Generic;
using System.Text;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

namespace TelecomWebParts
{
public class Vendors : WebPart
{
DropDownList ddVendors;
SqlConnection myConnection;
SqlCommand cmdVendor;
SqlDataReader drVendor;


public void getRecords()
{
myConnection = new SqlConnection(@"Server=servername;user id=user;password=passwor;Database=databasename");
myConnection.Open();
cmdVendor = myConnection.CreateCommand();
cmdVendor.CommandText = "Select VendorID, CompanyName from tblVendor";
drVendor = cmdVendor.ExecuteReader();
//ddVendors = new DropDownList();
//ddVendors.DataSource = drVendor;
//ddVendors.DataTextField = "CompanyName";
//ddVendors.DataValueField = "VendorID";
//drVendor.Close();
//myConnection.Close();
}

protected override void CreateChildControls()
{
ddVendors = new DropDownList();
ddVendors.ID = "vendors";
ddVendors.AppendDataBoundItems = true;
ddVendors.DataSource = drVendor;
ddVendors.DataTextField = "CompanyName";
ddVendors.DataValueField = "VendorID";
ddVendors.DataBind();
drVendor.Close();
this.Controls.Add(ddVendors);
}

}
}

[castron]

Hi again,

I was able to do it, but when I try to add the web part to a page, I got the following error:
An unhandled exception has occurred.
Request for the permission of type "System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToke=b77a5c56e089" failed.

Any idea?
Thanks
here is the code....

public DataTable getRecords()
{
SqlConnection myConnection;
myConnection =
new SqlConnection(@"Server=servernam;user id=username;password=password;Database=databasenam e");
SqlDataAdapter da = new SqlDataAdapter("Select VendorID, CompanyName from tblVendor", myConnection);
DataTable dt = new DataTable("Vendor");
da.Fill(dt);
myConnection.Close();
return dt;
}
protected override void CreateChildControls()
{
DropDownList ddVendors;
ddVendors =
new DropDownList();
ddVendors.ID =
"vendors";
//ddVendors.AppendDataBoundItems = true;
ddVendors.DataSource = getRecords();
ddVendors.DataTextField =
"CompanyName";
ddVendors.DataValueField =
"VendorID";
ddVendors.DataBind();
this.Controls.Add(ddVendors);
}

Hi All,

I'm trying to create a web part that will populate data in a drop down menu, I'm not sure how to pass the data from the method where I'm retrieving the data to the CreateChildControls method. It compiles fine, but when I add the web part to the page, there is no data in the drop down menu. I'm new on the whole .net stuff. Any help will be greatly appreciate. Thanks in avance

here is my code I have so far

using System;
using System.Collections.Generic;
using System.Text;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

namespace TelecomWebParts
{
public class Vendors : WebPart
{
DropDownList ddVendors;
SqlConnection myConnection;
SqlCommand cmdVendor;
SqlDataReader drVendor;


public void getRecords()
{
myConnection = new SqlConnection(@"Server=servername;user id=user;password=passwor;Database=databasename");
myConnection.Open();
cmdVendor = myConnection.CreateCommand();
cmdVendor.CommandText = "Select VendorID, CompanyName from tblVendor";
drVendor = cmdVendor.ExecuteReader();
//ddVendors = new DropDownList();
//ddVendors.DataSource = drVendor;
//ddVendors.DataTextField = "CompanyName";
//ddVendors.DataValueField = "VendorID";
//drVendor.Close();
//myConnection.Close();
}

protected override void CreateChildControls()
{
ddVendors = new DropDownList();
ddVendors.ID = "vendors";
ddVendors.AppendDataBoundItems = true;
ddVendors.DataSource = drVendor;
ddVendors.DataTextField = "CompanyName";
ddVendors.DataValueField = "VendorID";
ddVendors.DataBind();
drVendor.Close();
this.Controls.Add(ddVendors);
}

}
}