StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POListBox - value being set to text field
text
Body
copied!<p>Problem: When adding list item the Value field is being set to the Text field. Initially I though the problem was related to the input parameter for the primary key ( group_type_id ) as it is configured as OUTPUT variable. </p> <p>Interesting enough, when I Watch all of the values, everything is correct. So for example, I'll watch these: </p> <pre><code>ddr["group_type_name"] comes out as "Dept" ddr["grouptypeid"] comes out as 4 </code></pre> <p>When the item is created however, </p> <pre><code>itms.TEXT = "Dept" itms.Value = "Dept" <-- THIS IS THE PROBLEM </code></pre> <p>I'm at a loss why the listbox values are being set to the text values when I can clearly see the data reader values are correct. ? </p> <p>Code sample here:</p> <pre><code>DbDataReader ddr = grp.GetGroupTypeList(grp); if (ddr.HasRows) { ListItem itm = new ListItem(); itm.Text = "Select Group"; itm.Value = "0"; lb.Items.Add(itm); while (ddr.Read()) { ListItem itms = new ListItem(ddr["group_type_name"] as string, ddr["grouptypeid"] as string); } lb.SelectedValue = lbSelected; } </code></pre> <p>procedure: </p> <pre><code>ALTER PROCEDURE [dbo].[asp_Group_Type] @driver char(1)='I', @group_type_id int=null OUTPUT, @group_type_name varchar(50)=null, @par_group_id int=null, @active bit AS DECLARE @SQL varchar(8000) DECLARE @boolWhere varchar(10) SET @boolWhere = ' WHERE ' SET NOCOUNT ON IF (@driver = 'I') BEGIN INSERT INTO [dbo].[group_type] ([group_type_name], [Par_Group_Id]) VALUES (RTRIM(LTRIM(@group_type_name)), @par_group_id) SELECT @group_type_id = SCOPE_IDENTITY() END IF (@driver = 'U') BEGIN UPDATE [dbo].[group_type] SET [group_type_name] = RTRIM(LTRIM(@group_type_name)) ,[Par_Group_Id] = @par_group_id WHERE [group_type_id] = @group_type_id END IF (@driver = 'S') BEGIN SET @SQL = ' SELECT [group_type_id] AS [grouptypeid], [group_type_id], [group_type_name],[Par_Group_Id] FROM [dbo].[group_type] ' IF (@group_type_id > 0) BEGIN SET @SQL = @SQL + @boolWhere + '[group_type_id] = ''' + CAST(@group_type_id AS VARCHAR) + '''' SET @boolWhere = ' AND ' END IF (@active > 0) BEGIN SET @SQL = @SQL + @boolWhere + ' [active] = ''' + CAST(@active AS VARCHAR) + '''' END SET @SQL = @SQL + ' ORDER BY [group_type_name] ' PRINT(@SQL) EXEC(@SQL) END </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload