strange text appearing in gridview dropdownlist

[Jon Paal]

this text keeps showing up in my gridview dropdownlist

"System.Data.Da taRowView"

How do I prevent this problem ?

[Kevin Goff]

Can you post the code you use for databinding? You are probably missing
something there.

"Jon Paal" <Jon[ nospam ]Paal @ everywhere dot comwrote in message
news:%2******** ********@TK2MSF TNGP03.phx.gbl. ..

this text keeps showing up in my gridview dropdownlist

"System.Data.Da taRowView"

How do I prevent this problem ?

[Jon Paal]

....asp:SqlData Source
SelectCommand=" SELECT userid, status FROM aspnet_Users, UserData WHERE userid = userdataid AND Len(userid ) 2 "
UpdateCommand=" UPDATE UserData SET status = @status WHERE userid = @userid ">
<UpdateParamete rs>
<asp:Paramete r Name="userid " Type="String" />
</UpdateParameter s>

....asp:GridVie w
DataKeyNames="u serid"

....
<asp:TemplateFi eld HeaderText="Sta tus">
<ItemTemplate >
<asp:Label id="label1" runat="server" Text='<%# Eval("Status") %>' />
</ItemTemplate>
<EditItemTempla te>
<asp:DropDownLi st runat="server" ID="ddlStatus"
AppendDataBound Items="true"
SelectedValue=' <%# Bind("status") %>'
DataSourceID= "SqlDataSource1 "
AutoPostBack="F alse" >
<asp:ListItem Text="Open" Value="Open"></asp:ListItem>
<asp:ListItem Text="Closed" Value="Closed"> </asp:ListItem>
</asp:DropDownLis t>
</EditItemTemplat e>
</asp:TemplateFie ld>


"Kevin Goff" <ke********@nos pam.nospamwrote in message news:eF******** ******@TK2MSFTN GP02.phx.gbl...

Can you post the code you use for databinding? You are probably missing something there.

"Jon Paal" <Jon[ nospam ]Paal @ everywhere dot comwrote in message news:%2******** ********@TK2MSF TNGP03.phx.gbl. ..

>this text keeps showing up in my gridview dropdownlist

"System.Data.D ataRowView"

How do I prevent this problem ?

[Jon Paal]

The list of options is not drawn from the database. The list is a fixed set of choices and the selected value is matched to that
retrieved from the database.

I'm getting the correct outcome and everything works as expected except there are those strange items added to my fixed list of
options in the DDL. I have no idea what is causing them to appear....

"Milosz Skalecki [MCAD]" <mi*****@REMOVE ITwp.plwrote in message news:CA******** *************** ***********@mic rosoft.com...

Howdy,

You didn't specify which field should be mapped to text and which to value
(DataValueField ="userid" DataTextField=" status"):

SelectCommand=" SELECT userid, status FROM aspnet_Users, UserData WHERE
userid = userdataid AND Len(userid ) 2 "
UpdateCommand=" UPDATE UserData SET status = @status WHERE userid = @userid ">
<UpdateParamete rs>
<asp:Paramete r Name="userid " Type="String" />
</UpdateParameter s>

....asp:GridVie w
DataKeyNames="u serid"

....
<asp:TemplateFi eld HeaderText="Sta tus">
<ItemTemplate >
<asp:Label id="label1" runat="server" Text='<%# Eval("Status") %>' />
</ItemTemplate>
<EditItemTempla te>
<asp:DropDownLi st runat="server" ID="ddlStatus"
AppendDataBound Items="true"
DataValueField= "userid" DataTextField=" status"
SelectedValue=' <%# Bind("status") %>'
DataSourceID= "SqlDataSource1 "
AutoPostBack="F alse" >
<asp:ListItem Text="Open" Value="Open"></asp:ListItem>
<asp:ListItem Text="Closed" Value="Closed"> </asp:ListItem>
</asp:DropDownLis t>
</EditItemTemplat e>
</asp:TemplateFie ld>

--
Milosz
"Jon Paal" wrote:

>>

....asp:SqlDat aSource
SelectCommand= "SELECT userid, status FROM aspnet_Users, UserData WHERE userid = userdataid AND Len(userid ) 2 "
UpdateCommand= "UPDATE UserData SET status = @status WHERE userid = @userid ">
<UpdateParamete rs>
<asp:Paramete r Name="userid " Type="String" />
</UpdateParameter s>

....asp:GridVi ew
DataKeyNames=" userid"

....
<asp:TemplateF ield HeaderText="Sta tus">
<ItemTemplate >
<asp:Label id="label1" runat="server" Text='<%# Eval("Status") %>' />
</ItemTemplate>
<EditItemTempla te>
<asp:DropDownLi st runat="server" ID="ddlStatus"
AppendDataBound Items="true"
SelectedValue=' <%# Bind("status") %>'
DataSourceID= "SqlDataSource1 "
AutoPostBack="F alse" >
<asp:ListItem Text="Open" Value="Open"></asp:ListItem>
<asp:ListItem Text="Closed" Value="Closed"> </asp:ListItem>
</asp:DropDownLis t>
</EditItemTemplat e>
</asp:TemplateFie ld>


"Kevin Goff" <ke********@nos pam.nospamwrote in message news:eF******** ******@TK2MSFTN GP02.phx.gbl...

Can you post the code you use for databinding? You are probably missing something there.

"Jon Paal" <Jon[ nospam ]Paal @ everywhere dot comwrote in message news:%2******** ********@TK2MSF TNGP03.phx.gbl. ..
this text keeps showing up in my gridview dropdownlist

"System.Data.D ataRowView"

How do I prevent this problem ?