Intersoft Community - WebGrid Enterprise - ValueList in grid not using value field

ValueList in grid not using value field

handy@intersoftpt.com — Thu, 09 Dec 2010 01:45:43 GMT

Hello Shawn,

Ok, I assume that it also works on you because you said it already showed text instead of value. Thank you for your confirmation.

Regards,
Handy

ValueList in grid not using value field

SAgosto — Mon, 06 Dec 2010 16:59:03 GMT

I got news from WebGrid development team regarding this issue. After being investigated further by the team, I need to re-clarify that this issue is not bug.
James is correct. Please try to implement the value list in InitializeLayout event rather than PrepareDataBinding server side event. This should solve the issue.
For James: thank you very much for your contribution in our community forum.

I had the same problem and I moved the loading of the WebValueLookups to the InitializeLayout event and the columns now defaulted the TEXT instead of VALUE.

ValueList in grid not using value field

yudi@intersoftpt.com — Tue, 08 Sep 2009 23:51:50 GMT

I got news from WebGrid development team regarding this issue. After being investigated further by the team, I need to re-clarify that this issue is not bug.

James is correct. Please try to implement the value list in InitializeLayout event rather than PrepareDataBinding server side event. This should solve the issue.

For James: thank you very much for your contribution in our community forum.

ValueList in grid not using value field

james — Tue, 08 Sep 2009 10:22:12 GMT

Hello Eric,

After investigating your code further, it appears that you implement the ValueList in incorrect event. Instead of initializing the value list in PrepareDataBinding, you should place it in InitializeLayout event to ensure the value list is initialized when needed.

Code sample:

protected void WebGrid2_InitializeLayout(object sender, LayoutEventArgs e)
    {
        WebValueList vLang = null;
        WebGridColumn languageColumn = WebGrid2.RootTable.Columns.GetNamedItem("CultureCode");
        if (languageColumn != null)
            vLang = languageColumn.ValueList;
        
        if (vLang != null)
        {
            // setup valuelist data
            vLang.DataTextField = "CultureCodeDescription";
            vLang.DataValueField = "CultureCodeId";
            if (!vLang.IsDataCached())
            {
                DataTable dt = new DataTable("Languages");
                SqlDataAdapter theLanguages = new SqlDataAdapter();
                SqlConnection conn = new SqlConnection(SqlDataSource1.ConnectionString);
                try
                {
                    string queryLangs = "SELECT CultureCodeId, CultureCodeDescription FROM Culture";
                    theLanguages.SelectCommand = new SqlCommand(queryLangs, conn);
                    theLanguages.Fill(dt);
                }
                finally { if (conn.State == ConnectionState.Open) { conn.Close(); } }
                vLang.DataSource = dt;
            }
        }
    }

Let me know if that works for you.

- James.

ValueList in grid not using value field

yudi@intersoftpt.com — Mon, 07 Sep 2009 05:10:16 GMT

I was able to repro your issue based on the attached code behind. It is confirmed as bug.

I have forwarded and reported this issue to WebGrid development team. A work item, #393, has been created regarding this issue. The hotfix file will be available in our upcoming build number of WebGrid.

Please feel free to contact us with any questions or concerns you may have.

ValueList in grid not using value field

ehanig@extendemail.com — Fri, 04 Sep 2009 01:22:16 GMT

Hi,

here are both files zipped for you.

Eric

ValueList in grid not using value field

yudi@intersoftpt.com — Thu, 03 Sep 2009 22:34:42 GMT

I was unable to download the attached code behind.
Could you please re-attach the code behind in a compressed file format (zip or rar)?

ValueList in grid not using value field

ehanig@extendemail.com — Thu, 03 Sep 2009 07:38:49 GMT

Hi,

its also important to note that everything works fine, the dropdownlist shows correctly, however, when we add a row, it then shows the data value field in the table and not the data text field.

Eric

ValueList in grid not using value field

ehanig@extendemail.com — Thu, 03 Sep 2009 07:11:59 GMT

Yudi, the code behind page is attached above. I cant use the inline method your using since this needs to do a translation on the data first. Please take a look at the attachment and see if this helps.

Eric

ValueList in grid not using value field

yudi@intersoftpt.com — Thu, 03 Sep 2009 05:13:29 GMT

I created a test page based on your information and the code you provide in your posting.

From the code shown in your posting, I was unable to find the “ValueList” tag. So I decided to make a minor change by adding the following “ValueList” tag in my test page.

<ValueList DataSourceID="SqlDataSource2" DataTextField="CultureCodeDescription"

DataValueField="CultureCodeId" DataMember="DefaultView">

</ValueList>

I was unable to repro your issue by using my test page. The sample project is attached. Please make any necessary changes to the test page so that it replicates your issue, and then re-attach it for further investigation.

ValueList in grid not using value field

ehanig@extendemail.com — Thu, 03 Sep 2009 00:29:29 GMT

HI,

i have a valuelist that is a part of a grid (its a dropdownlist). The dropdown shows just fine, but when you select from the drop down, instead of showing what is in the Text field of the valuelist, its showing the value field. This is in 2009 webgrid 7.0

Eric

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="ChallengeQuestionSettings.ascx.cs" Inherits="ChallengeQuestionSettings" %> <%@ Register Assembly="ISNet.WebUI.WebGrid" Namespace="ISNet.WebUI.WebGrid" TagPrefix="ISWebGrid" %> <%@ Register Assembly="ComponentArt.Web.UI" Namespace="ComponentArt.Web.UI" TagPrefix="ComponentArt" %> <script type="text/javascript" language="javascript"> function wgPrepareCustomAction(grid, xmlr, name)

{

grid.SetStatus1('<%Response.Write(Resources.AdminText.MSG_Updating); %>'); return true;

}

function wgCustomActionResponse(grid, xmlrp)

{

grid.SetStatus1('<%Response.Write(Resources.AdminText.MSG_Ready); %>');

grid.RefreshAll();

return true;

}

</script><

script> <table cellpadding="0" cellspacing="0" width="900px" class="FormHeader"> <tr> <td style="padding-top: 5px; padding-bottom: 5px; padding-left: 5px" class="FormHeader"> <asp:Label ID="lblChallengeSettingsInfo" runat="server" /> </td> <td style="padding-top: 5px; padding-bottom: 5px; padding-right: 5px" class="FormHeader" align="right"> <a target="_blank" href="../../help.aspx?Context=ChallengeSettings"> <asp:Image ID="Image1" runat="server" ImageUrl="~/images/icons/wc_help16.gif" /></a> </td> </tr> <tr> <td class="FormBody" colspan="2" style="width: 900px; height: 620px;"> <table cellpadding="0" cellspacing="0"> <tr> <td style="padding-left: 5px; padding-right: 5px;"> <table cellspacing="0" cellpadding="0" border="1" style="height: 350px;"> <tr style="height: 620px; width: 900px;"> <td style="height: 620px;" align="left" valign="top"> <ISWebGrid:WebGrid ID="WebGridChallengeQuestion" runat="server" Height="620px" Width="900px" HorizontalAlign="NotSet" DataSourceID="SqlDataSource1"> <RootTable DataKeyField="ChallengeQuestionID"> <Columns> <ISWebGrid:WebGridColumn Caption="ChallengeQuestionID" DataMember="ChallengeQuestionID" DataType="System.Int32" Name="ChallengeQuestionID"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn Caption="ChallengeQuestion" DataMember="ChallengeQuestion" Name="ChallengeQuestion" TextboxMaxlength="150"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn Caption="CultureCode" DataMember="CultureCode" Name="CultureCode" TextboxMaxlength="50" EditType="DropdownList" > </ISWebGrid:WebGridColumn> </Columns> </RootTable> <LayoutSettings InProgressUIBehavior="ChangeCursorToHourGlass" HeaderClickAction="SortMulti" AlwaysShowHelpButton="False" NewRowLostFocusAction="AlwaysUpdate" TreeLines="False" AllowSorting="Yes" RowHeightDefault="20px" RowLostFocusAction="AlwaysUpdate" GridLines="Vertical" HideColumnsWhenGrouped="No" CellPaddingDefault="0" AutoFitColumns="True" ShowRefreshButton="false" AlternatingColors="True" VirtualLoadMode="LargeData" GridLineStyle="Solid" PagingMode="VirtualLoad" AllowContextMenu="false" GridLineColor="221, 236, 254" AllowEdit="Yes" AllowAddNew="Yes" AllowDelete="Yes" EditOnClick="true"> <HeaderStyle BorderWidth="1px" Font-Size="8pt" Font-Names="Verdana" BorderColor="#ACA899" BorderStyle="None" ForeColor="Black" BackgroundImage="/CommonLibrary/Images/ColBk.gif" Height="20px" CustomRules="border-bottom: #73A1E4 1px solid"></HeaderStyle> <FrameStyle BackColor="#A9C7F4"> </FrameStyle> <GroupByBox> <LabelStyle BorderWidth="1px" Font-Size="8pt" Font-Names="Verdana" BorderColor="Navy" BorderStyle="Solid" BackColor="White"></LabelStyle> <Style BackColor="#B2CDF7"> </Style> </GroupByBox> <EditTextboxStyle BorderWidth="0px" Font-Size="8pt" Font-Names="Verdana" BorderStyle="None"> </EditTextboxStyle> <NewRowStyle Font-Size="8pt" Font-Names="Verdana" ForeColor="DarkGray" BackColor="White"> </NewRowStyle> <FocusCellStyle BorderStyle="Solid" BorderWidth="1px" BorderColor="0, 45, 150"></FocusCellStyle> <RowStyle BackColor="White" CustomRules="text-overflow: ellipsis; overflow-x: hidden" Font-Names="Verdana" Font-Size="8pt" Overflow="Hidden" OverflowX="Hidden" OverflowY="Hidden" /> <GroupRowInfoStyle Font-Size="8pt" Font-Names="Verdana" BorderColor="Black" BorderStyle="None" BackgroundImage="/CommonLibrary/Images/ColBk.gif" CustomRules="border-bottom: #73A1E4 1px solid"> </GroupRowInfoStyle> <SelectedRowStyle BackColor="#FBE9B8" Overflow="Hidden" OverflowX="Hidden" OverflowY="Hidden" /> <EditFocusCellStyle BackColor="#E9CD82"> </EditFocusCellStyle> <AlternatingRowStyle BackColor="#DDECFE" CustomRules="text-overflow: ellipsis; overflow-x: hidden" Font-Names="Verdana" Font-Size="8pt" Overflow="Hidden" OverflowX="Hidden" OverflowY="Hidden" /> <StatusBarStyle BorderWidth="1px" Font-Size="8pt" Font-Names="Verdana" BorderColor="#73A1E4" BorderStyle="Solid" BackColor="#DDECFE"> <Padding Bottom="2px"></Padding> </StatusBarStyle> </LayoutSettings> </ISWebGrid:WebGrid> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:HostingConnectionString %>" SelectCommand="SELECT * FROM [ChallengeQuestion]" DeleteCommand="DELETE FROM [ChallengeQuestion] WHERE [ChallengeQuestionID] = @ChallengeQuestionID" InsertCommand="INSERT INTO [ChallengeQuestion] ([ChallengeQuestion], [CultureCode]) VALUES (@ChallengeQuestion, @CultureCode)" UpdateCommand="UPDATE [ChallengeQuestion] SET [ChallengeQuestion] = @ChallengeQuestion, [CultureCode] = @CultureCode WHERE [ChallengeQuestionID] = @ChallengeQuestionID"> <DeleteParameters> <asp:Parameter Name="ChallengeQuestionID" Type="Int32" /> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="ChallengeQuestionID" Type="String" /> <asp:Parameter Name="ChallengeQuestion" Type="String" /> <asp:Parameter Name="CultureCode" Type="String" /> </UpdateParameters> <InsertParameters> <asp:Parameter Name="ChallengeQuestion" Type="String" /> <asp:Parameter Name="CultureCode" Type="String" /> </InsertParameters> </asp:SqlDataSource> </td> </tr> </table> </td> </tr> </table> </td> </tr>

</table>

table>