Web Part drop down list

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • castron
    New Member
    • Mar 2008
    • 5
    #1

    Web Part drop down list

    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 CreateChildCont rols 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.Collecti ons.Generic;
    using System.Text;
    using System.Web.UI.W ebControls.WebP arts;
    using System.Web.UI;
    using System.Web.UI.H tmlControls;
    using System.Web.UI.W ebControls;
    using System.Data;
    using System.Data.Sql Client;

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


    public void getRecords()
    {
    myConnection = new SqlConnection(@ "Server=servern ame;user id=user;passwor d=passwor;Datab ase=databasenam e");
    myConnection.Op en();
    cmdVendor = myConnection.Cr eateCommand();
    cmdVendor.Comma ndText = "Select VendorID, CompanyName from tblVendor";
    drVendor = cmdVendor.Execu teReader();
    //ddVendors = new DropDownList();
    //ddVendors.DataS ource = drVendor;
    //ddVendors.DataT extField = "CompanyNam e";
    //ddVendors.DataV alueField = "VendorID";
    //drVendor.Close( );
    //myConnection.Cl ose();
    }

    protected override void CreateChildCont rols()
    {
    ddVendors = new DropDownList();
    ddVendors.ID = "vendors";
    ddVendors.Appen dDataBoundItems = true;
    ddVendors.DataS ource = drVendor;
    ddVendors.DataT extField = "CompanyNam e";
    ddVendors.DataV alueField = "VendorID";
    ddVendors.DataB ind();
    drVendor.Close( );
    this.Controls.A dd(ddVendors);
    }

    }
    }
    Tags: None
    • castron
      New Member
      • Mar 2008
      • 5
      #2
      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.Sq lClient.SqlClie ntPermission, System.Data, Version=2.0.0.0 , Culture=neutral , PublicKeyToke=b 77a5c56e089" failed.

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

      public DataTable getRecords()
      {
      SqlConnection myConnection;
      myConnection =
      new SqlConnection(@ "Server=servern am;user id=username;pas sword=password; Database=databa sename");
      SqlDataAdapter da = new SqlDataAdapter( "Select VendorID, CompanyName from tblVendor", myConnection);
      DataTable dt = new DataTable("Vend or");
      da.Fill(dt);
      myConnection.Cl ose();
      return dt;
      }
      protected override void CreateChildCont rols()
      {
      DropDownList ddVendors;
      ddVendors =
      new DropDownList();
      ddVendors.ID =
      "vendors";
      //ddVendors.Appen dDataBoundItems = true;
      ddVendors.DataS ource = getRecords();
      ddVendors.DataT extField =
      "CompanyNam e";
      ddVendors.DataV alueField =
      "VendorID";
      ddVendors.DataB ind();
      this.Controls.A dd(ddVendors);
      }

      Originally posted by 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 CreateChildCont rols 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.Collecti ons.Generic;
      using System.Text;
      using System.Web.UI.W ebControls.WebP arts;
      using System.Web.UI;
      using System.Web.UI.H tmlControls;
      using System.Web.UI.W ebControls;
      using System.Data;
      using System.Data.Sql Client;

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


      public void getRecords()
      {
      myConnection = new SqlConnection(@ "Server=servern ame;user id=user;passwor d=passwor;Datab ase=databasenam e");
      myConnection.Op en();
      cmdVendor = myConnection.Cr eateCommand();
      cmdVendor.Comma ndText = "Select VendorID, CompanyName from tblVendor";
      drVendor = cmdVendor.Execu teReader();
      //ddVendors = new DropDownList();
      //ddVendors.DataS ource = drVendor;
      //ddVendors.DataT extField = "CompanyNam e";
      //ddVendors.DataV alueField = "VendorID";
      //drVendor.Close( );
      //myConnection.Cl ose();
      }

      protected override void CreateChildCont rols()
      {
      ddVendors = new DropDownList();
      ddVendors.ID = "vendors";
      ddVendors.Appen dDataBoundItems = true;
      ddVendors.DataS ource = drVendor;
      ddVendors.DataT extField = "CompanyNam e";
      ddVendors.DataV alueField = "VendorID";
      ddVendors.DataB ind();
      drVendor.Close( );
      this.Controls.A dd(ddVendors);
      }

      }
      }

        Comment

        Previous template Next
        Working...