Intersoft Community - Multiple

Webgrid column value depending on multiple values

beyti77 — Wed, 04 Apr 2012 10:03:18 GMT

The first thing I'm trying to achieve is, get a columns value that is calculated using 2 other columns, like:

"User" table has the "PrimarySectorId" and "PrimarySectorTypeId" columns.

And I have 8 different "Sector" tables like "SectorA", "SectorB", .... "SectorH".

There is a "WorkAreaId" column in every sector table that is a foreign key relation with "WorkArea" table's Id.

"PrimarySectorTypeId" is a enum value (integer) that differentiates the sectors.

Therefore, all I need to do is to bind the users to a webgrid and include a WorkArea column, so I need to get both the "PrimarySectorId" and "PrimarySectorTypeId" to get the correct "WorkArea" value.

But as far as I know, I can just use a <value list> and take only one value to calculate a column value.

I'd really like to get it by myself but it has been so long and no step forward I could get.

Thanks in advance.

Note: It would be lovely if someone could include a sample of many to many realationship binding to a webgrid.

Script Access to “Paste Multiple Rows from Clipboard”

danjransom@gmail.com — Tue, 09 Feb 2010 14:49:12 GMT

Is there any way to access the “Paste Multiple Rows from Clipboard” feature from javascript outside of the row context menu? We want users to be able to paste multiple rows at a single time into an empty grid. However, if the grid is empty and there are no rows, there is no way to access the “Paste Multiple Rows from Clipboard” command.

Is there a way to perform this function from a button outside the grid? Alternatively, is there a way to show the row context menu even when there are no rows?

Multiple SpellCheckers

ewoudt@counton.com.au — Sun, 08 Nov 2009 19:00:22 GMT

Hello,

Thanks in advance for any help,

I have a repeater creating textboxes and i need to have them all spellchecked so i create a spell check button for every text box and programmatically create the Spell Checker, (i'm not aware that i can use one spell checker for more than one control)

Here is my code: .cs ( on the ItemDataBound event of the repeater)

Panel pnl = (Panel)e.Item.FindControl("pnlSpellCheck");
WebSpellChecker wsCheck = new WebSpellChecker { ID = "wsCheck" e.Item.ItemIndex, TargetControlId = txtTextBox.UniqueID, Height = 500, Width = 700, TargetControlIdValue = "value", CssClass = "SpellCheck" };
pnl.Controls.Add(wsCheck);
WebButton btn = (WebButton)pnl.FindControl("btnSpellCheck");
btn.OnClientClick = "CheckSpell('" e.Item.ItemIndex "')";

Javascript:

function CheckSpell(id) {
var sp = ISGetObject("wsCheck" id);
sp.CheckSpell();
return false;
}

Markup: (inside a repeater)

<asp:Panel id="pnlSpellCheck" runat="server">
<ISWebDesktop:WebButton ID="btnSpellCheck" runat="server" Height="20px" OnClientClick="CheckSpell"
Text="Spell Check" Width="150px">
<ButtonStyle>
<Normal CssClass="FPB-Button-N">
</Normal>
<Over CssClass="FPB-Button-O">
</Over>
<Active CssClass="FPB-Button-A">
</Active>
</ButtonStyle>
</ISWebDesktop:WebButton>
</asp:Panel>

I get a javascript popup:

An error occurred: