Very Computer

Has anyone solved this error? I am creating a composite control that creates a
dataset which gets data from the authors table in pubs and then binds to a
DataGrid. The error occurs when the DataGrid is added to the Controls collection.

Here is the code sample:

public class MyCtrl : Control
{
   protected override void CreateChildControls()
   {
      SQLConnection oConnection = new SQLConnection(sConnStr);
      SQLCommand oCommand = new SQLCommand("select * from authors", oConnection);
      SQLDataSetCommand dsCmd = new SQLDataSetCommand("select * from authors",
         sConnStr);
      DataSet ds = new DataSet();
      dsCmd.FillDataSet(ds, "authors");

      System.Web.UI.WebControls.DataGrid authors = new
         System.Web.UI.WebControls.DataGrid();
      authors.DataSource = ds.Tables["authors"].DefaultView;
      authors.ID = "authid";
      authors.DataBind();

      Controls.Add(authors);    // error happens here
   }

Quote:}

Unfortunately I don't have an answer, but I can say that I feel your pain.
:)

I've seen the same thing happen when binding a data source manually:

void Page_Load(Object sender, EventArgs e) {
   if (!IsPostBack) {
      // need to load this data only once
      ItemsGrid.DataSource= CreateDataSource();
      ItemsGrid.DataBind();
   }

Quote:}

ICollection CreateDataSource() {
   DataTable dt = new DataTable();
   DataRow dr;

   dt.Columns.Add(new DataColumn("IntegerValue", typeof(Int32)));
   dt.Columns.Add(new DataColumn("StringValue", typeof(string)));
   dt.Columns.Add(new DataColumn("CurrencyValue", typeof(double)));

   for (int i = 0; i < 100; i++) {
      dr = dt.NewRow();

      dr[0] = i;
      dr[1] = "Item " + Int32.ToString(i);
      dr[2] = 1.23 * (i+1);

      dt.Rows.Add(dr);
   }

   DataView dv = new DataView(dt);
   return dv;

Quote:}

If I do this in a web control, I get the message "The id 'ctrl1' is already
used by another control".  If I do it in a web form, it works great.

Go figure...

Marc Bernard

Has anyone solved this error? I am creating a composite control that creates
a
dataset which gets data from the authors table in pubs and then binds to a
DataGrid. The error occurs when the DataGrid is added to the Controls
collection.

Here is the code sample:

public class MyCtrl : Control
{
   protected override void CreateChildControls()
   {
      SQLConnection oConnection = new SQLConnection(sConnStr);
      SQLCommand oCommand = new SQLCommand("select * from authors",
oConnection);
      SQLDataSetCommand dsCmd = new SQLDataSetCommand("select * from
authors",
         sConnStr);
      DataSet ds = new DataSet();
      dsCmd.FillDataSet(ds, "authors");

      System.Web.UI.WebControls.DataGrid authors = new
         System.Web.UI.WebControls.DataGrid();
      authors.DataSource = ds.Tables["authors"].DefaultView;
      authors.ID = "authid";
      authors.DataBind();

      Controls.Add(authors);    // error happens here
   }

Quote:}

Add the control to the form prior to data binding.

public class MyCtrl : Control
{
   protected override void CreateChildControls()
   {
      SQLConnection oConnection = new SQLConnection(sConnStr);
      SQLCommand oCommand = new SQLCommand("select * from authors",
oConnection);
      SQLDataSetCommand dsCmd = new SQLDataSetCommand("select * from
authors",
         sConnStr);
      DataSet ds = new DataSet();
      dsCmd.FillDataSet(ds, "authors");

      System.Web.UI.WebControls.DataGrid authors = new
         System.Web.UI.WebControls.DataGrid();
        Controls.Add(authors);

    authors.DataSource = ds.Tables["authors"].DefaultView;
      authors.ID = "authid";
      authors.DataBind();

     }

Has anyone solved this error? I am creating a composite control that creates
a
dataset which gets data from the authors table in pubs and then binds to a
DataGrid. The error occurs when the DataGrid is added to the Controls
collection.

Here is the code sample:

public class MyCtrl : Control
{
   protected override void CreateChildControls()
   {
      SQLConnection oConnection = new SQLConnection(sConnStr);
      SQLCommand oCommand = new SQLCommand("select * from authors",
oConnection);
      SQLDataSetCommand dsCmd = new SQLDataSetCommand("select * from
authors",
         sConnStr);
      DataSet ds = new DataSet();
      dsCmd.FillDataSet(ds, "authors");

      System.Web.UI.WebControls.DataGrid authors = new
         System.Web.UI.WebControls.DataGrid();
      authors.DataSource = ds.Tables["authors"].DefaultView;
      authors.ID = "authid";
      authors.DataBind();

      Controls.Add(authors);    // error happens here
   }

Quote:}