DropDownList in editable DataGrid

[Stephan Bour]

Hi,
I¹ve tried to implement a solution to populate a dropdownlist inside an
editable datagrid. The code is simple enough and an example can be found
here: <http://www.4guysfromro lla.com/webtech/050801-1.shtml>
The problem I'm having is that the entire datagrid disappears after I click
the Edit link.
Could someone tell me what I'm doing wrong?
Much appreciated,
Stephan.

THE GRID:

<asp:DataGrid id="ByJob" AutoGenerateCol umns="false"
OnEditCommand=" ByJob_Edit" OnCancelCommand ="ByJob_Canc el"
OnUpdateCommand ="ByJob_Upda te" DataKeyField="P ersonID" runat="server">
<HeaderStyle backcolor="Blac k" forecolor="Whit e" font-bold="True"
horizontalalign ="Left" />
<AlternatingIte mStyle BackColor="#DED CFF" />
<Columns>
<asp:EditComman dColumn EditText="Edit"
CancelText="Can cel"
UpdateText="Upd ate"
ItemStyle-Wrap="false"
/>
<asp:TemplateCo lumn HeaderText="Nam e">
<ItemTemplate >
<asp:Label ID="NameLabel" runat="server"
Text='<%# DataBinder.Eval (Container.Data Item, "Name") %>'></asp:Label>
</ItemTemplate>
<EditItemTempla te>
<asp:DropDownLi st id="NameEdit"
DataValueField= "PersonID" DataTextField=" Name" DataSource="<%# TempDataView
%>" runat="server"> </asp:DropDownLis t>
</EditItemTemplat e>
</asp:TemplateCol umn>
</Columns>
</asp:DataGrid>

THE CODE BEHIND:

public virtual void Page_Load (Object Sender, EventArgs e) {

if (! Page.IsPostBack ) {
Defaults (); //Defaults runs a SQL query that populates the
datagrid. That part works fine (not shown)
}
}

protected void PopulateDropDow nList () {
try {
String ShowPeople = "SELECT * FROM People";
SqlConnection myConnection = new SqlConnection(" server =
'LMM-MB-DATA,25886';Dat abase = 'LMM_Jobs'; Trusted_Connect ion=Yes");
SqlDataAdapter myCommand = new SqlDataAdapter( ShowPeople,
myConnection);

DataSet ds_Names = new DataSet();
myCommand.Fill( ds_Names, "People");
DataView TempDataView = new DataView(ds_Nam es.Tables["People"]);
//DataBind();
}
catch (Exception SQL) {
SqlError.Text = "<strong><cente r><font color = red>Sorry, there
was a problem with the database connection. Please try again
later</center></strong></font><br>" +
SQL.Message;
}
}

protected void ByJob_Edit (object sender, DataGridCommand EventArgs e) {
PopulateDropDow nList ();
ByJob.EditItemI ndex = e.Item.ItemInde x;
}

[Janaka]

Try calling the PopulateDropDow nList () method after setting the
EditItemIndex

"Stephan Bour" <sb***@niaid.ni h.gov> wrote in message
news:BC453055.E B30%sb***@niaid .nih.gov...

Hi,
I¹ve tried to implement a solution to populate a dropdownlist inside an
editable datagrid. The code is simple enough and an example can be found
here: <http://www.4guysfromro lla.com/webtech/050801-1.shtml>
The problem I'm having is that the entire datagrid disappears after I click the Edit link.
Could someone tell me what I'm doing wrong?
Much appreciated,
Stephan.

THE GRID:

<asp:DataGrid id="ByJob" AutoGenerateCol umns="false"
OnEditCommand=" ByJob_Edit" OnCancelCommand ="ByJob_Canc el"
OnUpdateCommand ="ByJob_Upda te" DataKeyField="P ersonID" runat="server">
<HeaderStyle backcolor="Blac k" forecolor="Whit e" font-bold="True"
horizontalalign ="Left" />
<AlternatingIte mStyle BackColor="#DED CFF" />
<Columns>
<asp:EditComman dColumn EditText="Edit"
CancelText="Can cel"
UpdateText="Upd ate"
ItemStyle-Wrap="false"
/>
<asp:TemplateCo lumn HeaderText="Nam e">
<ItemTemplate >
<asp:Label ID="NameLabel" runat="server" Text='<%# DataBinder.Eval (Container.Data Item, "Name") %>'></asp:Label>
</ItemTemplate>
<EditItemTempla te>
<asp:DropDownLi st id="NameEdit"
DataValueField= "PersonID" DataTextField=" Name" DataSource="<%# TempDataView %>" runat="server"> </asp:DropDownLis t>
</EditItemTemplat e>
</asp:TemplateCol umn>
</Columns>
</asp:DataGrid>

THE CODE BEHIND:

public virtual void Page_Load (Object Sender, EventArgs e) {

if (! Page.IsPostBack ) {
Defaults (); //Defaults runs a SQL query that populates the
datagrid. That part works fine (not shown)
}
}

protected void PopulateDropDow nList () {
try {
String ShowPeople = "SELECT * FROM People";
SqlConnection myConnection = new SqlConnection(" server =
'LMM-MB-DATA,25886';Dat abase = 'LMM_Jobs'; Trusted_Connect ion=Yes");
SqlDataAdapter myCommand = new SqlDataAdapter( ShowPeople,
myConnection);

DataSet ds_Names = new DataSet();
myCommand.Fill( ds_Names, "People");
DataView TempDataView = new DataView(ds_Nam es.Tables["People"]); //DataBind();
}
catch (Exception SQL) {
SqlError.Text = "<strong><cente r><font color = red>Sorry, there was a problem with the database connection. Please try again
later</center></strong></font><br>" +
SQL.Message;
}
}

protected void ByJob_Edit (object sender, DataGridCommand EventArgs e) { PopulateDropDow nList ();
ByJob.EditItemI ndex = e.Item.ItemInde x;
}

[Stephan Bour]

Sorry, no change. I need to amend the original statement though. The
datagrid is now reloaded as is instead of disappearing. The "Edit" link is
still present and does not change to the expected Update and Cancel links.

in article #a************* *@tk2msftngp13. phx.gbl, Janaka at
ja****@magicali a.com wrote on 2/3/04 12:02 PM:

Try calling the PopulateDropDow nList () method after setting the
EditItemIndex

"Stephan Bour" <sb***@niaid.ni h.gov> wrote in message
news:BC453055.E B30%sb***@niaid .nih.gov...

Hi,
I¹ve tried to implement a solution to populate a dropdownlist inside an
editable datagrid. The code is simple enough and an example can be found
here: <http://www.4guysfromro lla.com/webtech/050801-1.shtml>
The problem I'm having is that the entire datagrid disappears after I

click

the Edit link.
Could someone tell me what I'm doing wrong?
Much appreciated,
Stephan.

THE GRID:

<asp:DataGrid id="ByJob" AutoGenerateCol umns="false"
OnEditCommand=" ByJob_Edit" OnCancelCommand ="ByJob_Canc el"
OnUpdateCommand ="ByJob_Upda te" DataKeyField="P ersonID" runat="server">
<HeaderStyle backcolor="Blac k" forecolor="Whit e" font-bold="True"
horizontalalign ="Left" />
<AlternatingIte mStyle BackColor="#DED CFF" />
<Columns>
<asp:EditComman dColumn EditText="Edit"
CancelText="Can cel"
UpdateText="Upd ate"
ItemStyle-Wrap="false"
/>
<asp:TemplateCo lumn HeaderText="Nam e">
<ItemTemplate >
<asp:Label ID="NameLabel"

runat="server"

Text='<%# DataBinder.Eval (Container.Data Item, "Name") %>'></asp:Label>
</ItemTemplate>
<EditItemTempla te>
<asp:DropDownLi st id="NameEdit"
DataValueField= "PersonID" DataTextField=" Name" DataSource="<%#

TempDataView

%>" runat="server"> </asp:DropDownLis t>
</EditItemTemplat e>
</asp:TemplateCol umn>
</Columns>
</asp:DataGrid>

THE CODE BEHIND:

public virtual void Page_Load (Object Sender, EventArgs e) {

if (! Page.IsPostBack ) {
Defaults (); //Defaults runs a SQL query that populates the
datagrid. That part works fine (not shown)
}
}

protected void PopulateDropDow nList () {
try {
String ShowPeople = "SELECT * FROM People";
SqlConnection myConnection = new SqlConnection(" server =
'LMM-MB-DATA,25886';Dat abase = 'LMM_Jobs'; Trusted_Connect ion=Yes");
SqlDataAdapter myCommand = new SqlDataAdapter( ShowPeople,
myConnection);

DataSet ds_Names = new DataSet();
myCommand.Fill( ds_Names, "People");
DataView TempDataView = new

DataView(ds_Nam es.Tables["People"]);

//DataBind();
}
catch (Exception SQL) {
SqlError.Text = "<strong><cente r><font color = red>Sorry,

there

was a problem with the database connection. Please try again
later</center></strong></font><br>" +
SQL.Message;
}
}

protected void ByJob_Edit (object sender, DataGridCommand EventArgs e)

{

PopulateDropDow nList ();
ByJob.EditItemI ndex = e.Item.ItemInde x;
}