Welcome Guest Search | Active Topics | Sign In | Register

deleting a row from the EO.Web.Grid Options
James
Posted: Wednesday, August 26, 2009 4:13:32 PM
Rank: Member
Groups: Member

Joined: 7/7/2009
Posts: 12
I'm using a right click menu to delete a record from my grid. When this option is chosen...it opens a new page which contains the query to delete the record...and then redirects back to the page with the grid on it. The query works great but when it redirects back to the main page...I get an:

Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index]
System.Collections.ArrayList.get_Item(Int32 index) +7485640
EO.Web.GridCellCollection.get_Item(Int32 columnIndex) +39
EO.Web.Grid.a(Int32 A_0, Int32 A_1) +213
EO.Web.Internal.c7.a(h6 A_0) +910
EO.Web.Internal.bs.aa() +316
EO.Web.WebControlBase.a(Object A_0) +127
EO.Web.Grid.a(Object A_0) +36
System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +183
System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134
System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221
System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134
System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221
System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134
System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221
System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134
System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221
System.Web.UI.Page.LoadAllState() +312
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1661

Any idea what this could be?

eo_support
Posted: Wednesday, August 26, 2009 4:29:43 PM
Rank: Administration
Groups: Administration

Joined: 5/27/2007
Posts: 24,194
Hi,

We do not know why the page would try to load view state when you are redirecting back to the main page. When you do a redirect, it will be a regular HTTP GET, which means the whole page will be re-fetched from the server again brand new (so that it reflects the change you've made). However the call stack indicates that it tries to load view state, which only occurs on an HTTP POST. So something must be missing here. Can you clarify?

Thanks!
James
Posted: Wednesday, August 26, 2009 4:47:23 PM
Rank: Member
Groups: Member

Joined: 7/7/2009
Posts: 12
my page with the grid (default.aspx) uses javascript on the right click Context menu to do a href.location to the page which runs the delete query (on page load)...when the query is complete....I do a response.redirect back to default.aspx. What else should I look at?
eo_support
Posted: Wednesday, August 26, 2009 4:53:45 PM
Rank: Administration
Groups: Administration

Joined: 5/27/2007
Posts: 24,194
Hi,

That still does not connect the dots. What appears to be missing to us is when you do a Response.Redirect the page should not load view state at all. However the stack trace you posts is loading view state.

It will be better if you can create a test page that reproduces the error so that we can run it here and see what's really happening. Also make sure you update to the latest version first because it maybe some problems that have already been fixed.

Thanks
James
Posted: Wednesday, August 26, 2009 8:26:29 PM
Rank: Member
Groups: Member

Joined: 7/7/2009
Posts: 12
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<%@ Register TagPrefix="eo" NameSpace="EO.Web" Assembly="EO.Web" %>
<%@ Register Assembly="EO.Web" Namespace="EO.Web" TagPrefix="eo" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>Project Status Notes Listing</title>

<script type="text/javascript">

var g_itemIndex = -1;
var g_cellIndex = -1;

function LoadIt(){
document.body.style.cursor = "default";
}

function UnLoadIt(){
document.body.style.cursor = "wait";
}

function ShowContextMenu(e, grid, item, cell)
{
//PS Notes Listing (Right Click Menu)
//Save the target cell index
g_itemIndex = item.getIndex();
g_cellIndex = cell.getColIndex();

//Show the context menu
var menu = eo_GetObject("<%=ContextMenu1.ClientID%>");
eo_ShowContextMenu(e, "<%=ContextMenu1.ClientID%>");

//Return true to indicate that we have
//displayed a context menu
return true;
}

function ShowContextMenu2(e, grid, item, cell)
{
//Risk Listing (Right Click Menu)
//Save the target cell index
g_itemIndex = item.getIndex();
g_cellIndex = cell.getColIndex();

//Show the context menu
var menu = eo_GetObject("<%=ContextMenu2.ClientID%>");
eo_ShowContextMenu(e, "<%=ContextMenu2.ClientID%>");

//Return true to indicate that we have
//displayed a context menu
return true;
}

function ShowContextMenu3(e, grid, item, cell)
{
//Critical Items Listing (Right Click Menu)
//Save the target cell index
g_itemIndex = item.getIndex();
g_cellIndex = cell.getColIndex();

//Show the context menu
var menu = eo_GetObject("<%=ContextMenu3.ClientID%>");
eo_ShowContextMenu(e, "<%=ContextMenu3.ClientID%>");

//Return true to indicate that we have
//displayed a context menu
return true;
}

function PlaySound(soundObj){
var sound = document.getElementById(soundObj);
sound.Play();
}

function GridDblClick() {
var i;
var x;
for (i=0;i<3;i++){
if(document.form1.RadioButtonList1[i].checked){
x = i;
}
}

switch (x){
case 0:
var grid = eo_GetObject("<%=Grid1.ClientID%>");
var index = grid.getSelectedItem().getIndex();
var selectedItem = grid.getItem(index);
location.href="EditNotes.aspx?id=" + selectedItem.getCell(0).getValue();
break;

case 1:
var grid = eo_GetObject("<%=Grid2.ClientID%>");
var index = grid.getSelectedItem().getIndex();
var selectedItem = grid.getItem(index);
location.href="EditRisk.aspx?id=" + selectedItem.getCell(0).getValue();
break;

case 2:
var grid = eo_GetObject("<%=Grid3.ClientID%>");
var index = grid.getSelectedItem().getIndex();
var selectedItem = grid.getItem(index);
location.href="EditCriticalIssues.aspx?id=" + selectedItem.getCell(0).getValue();
break;
}
}

function OnContextMenuItemClicked1(e, eventInfo){
// PS Notes Right Click Menu
var ans;
var grid = eo_GetObject("<%=Grid1.ClientID%>");
var selectedItem = grid.getItem(g_itemIndex);
var item = eventInfo.getItem();

switch (item.getText())
{
case "View Issue Desc. / Action Required":
var w;
w = document.body.clientWidth - 50;
eo_GetObject("MsgBox1").setSize(w, 200);

var note;
var issueheader;
var actionheader;
PlaySound("sound1");
var issuedesc = selectedItem.getCell(6).getValue();
var actionreq = selectedItem.getCell(7).getValue();
issuedesc = issuedesc.replace(/\n/g, '<br>');
actionreq = actionreq.replace(/\n/g, '<br>');
issueheader = '<b><u>Issue Description</u></b><br>';
actionheader = '<b><u>Action Required</u></b><br>';
note = issueheader + issuedesc + '<br><br>' + actionheader + actionreq;

eo_MsgBox(
"MsgBox1", //ID of the MsgBox control
"Issue Description / Action Required", //Message box title
note, //Message text
null, //Icon
[
{
Text: "Ok", //Ok button
ClientSideHandler: ""
}
]);
break;

case "Edit Note":
location.href="EditNotes.aspx?id=" + selectedItem.getCell(0).getValue();
break;

case "Add New Note":
location.href="EditNotes.aspx";
break;

case "Edit Risk Info for this Note":
if(selectedItem.getCell(31).getValue()==0){
ans = confirm('Risk Info. has not been attached to this note. Would you like to attach new Risk Info.?');
if(ans==true){
location.href="EditRisk.aspx?";
}
}
else{
location.href="EditRisk.aspx?&id=" + selectedItem.getCell(31).getValue();
}
break;

case "Attach New Risk Info":
location.href="EditRisk.aspx";
break;

case "Edit Critical Issue for this Note":
if(selectedItem.getCell(32).getValue()==0){
ans = confirm('Critical Issue Info. has not been attached to this note. Would you like to attach new Critical Issue Info.?');
if(ans==true){
location.href="EditCriticalIssues.aspx";
}
}
else{
location.href="EditCriticalIssues.aspx?id=" + selectedItem.getCell(32).getValue();
}
break;

case "Attach New Critical Issue":
location.href="EditCriticalIssues.aspx?";
break;

case "Delete Record":
ans = confirm('Are you sure that you want to delete this row?');
CursorWait();
if(ans==true){
location.href="EditNotes.aspx?flag=D&id=" + selectedItem.getCell(0).getValue();
}
break;
}
}

function OnContextMenuItemClicked2(e, eventInfo){
// Risk Right Click Menu
var ans;
var grid = eo_GetObject("<%=Grid2.ClientID%>");
var selectedItem = grid.getItem(g_itemIndex);
var item = eventInfo.getItem();

switch (item.getText())
{
case "View Risk Description":
var w;
w = document.body.clientWidth - 50;
eo_GetObject("MsgBox1").setSize(w, 200);

var note;
var issueheader;
PlaySound("sound1");
var riskdesc = selectedItem.getCell(5).getValue();
riskdesc = riskdesc.replace(/\n/g, '<br>');
riskheader = '<b><u>Risk Description</u></b><br>';
note = riskheader + riskdesc;

eo_MsgBox(
"MsgBox1", //ID of the MsgBox control
"Risk Description", //Message box title
note, //Message text
null, //Icon
[
{
Text: "Ok", //Ok button
ClientSideHandler: ""
}
]);
break;

case "View Trigger Pt. / Mitg. Actions":
var w;
w = document.body.clientWidth - 50;
eo_GetObject("MsgBox1").setSize(w, 200);

var note;
var triggerheader;
var actheader;
PlaySound("sound1");
var trigger = selectedItem.getCell(10).getValue();
var act = selectedItem.getCell(11).getValue();
trigger = trigger.replace(/\n/g, '<br>');
act = act.replace(/\n/g, '<br>');
triggerheader = '<b><u>Trigger Point</u></b><br>';
actheader = '<b><u>Mitigation Actions</u></b><br>';
note = triggerheader + trigger + '<br><br>' + actheader + act;

eo_MsgBox(
"MsgBox1", //ID of the MsgBox control
"Trigger Point / Mitigation Actions", //Message box title
note, //Message text
null, //Icon
[
{
Text: "Ok", //Ok button
ClientSideHandler: ""
}
]);
break;

case "Edit Risk Item":
location.href="EditRisk.aspx?id=" + selectedItem.getCell(0).getValue();
break;

case "Add New Risk Item":
location.href="EditRisk.aspx";
break;

case "Close Risk Item":
alert('close risk item');
break;

case "Delete Risk Item":
ans = confirm('Are you sure that you want to delete this row?');
CursorWait();
if(ans==true){
location.href="EditRisk.aspx?flag=D&id=" + selectedItem.getCell(0).getValue();
}
break;
}
}

function OnContextMenuItemClicked3(e, eventInfo){
// Critical Items Right Click Menu
var ans;
var grid = eo_GetObject("<%=Grid3.ClientID%>");
var selectedItem = grid.getItem(g_itemIndex);
var item = eventInfo.getItem();

switch (item.getText())
{
case "View Critical Issue Desc.":
var w;
w = document.body.clientWidth - 50;
eo_GetObject("MsgBox1").setSize(w, 200);

var note;
var critheader;
PlaySound("sound1");
var critdesc = selectedItem.getCell(6).getValue();
critdesc = critdesc.replace(/\n/g, '<br>');
critheader = '<b><u>Critical Issue Description</u></b><br>';
note = critheader + critdesc;

eo_MsgBox(
"MsgBox1", //ID of the MsgBox control
"Critical Issue Description", //Message box title
note, //Message text
null, //Icon
[
{
Text: "Ok", //Ok button
ClientSideHandler: ""
}
]);
break;

case "Edit Critical Issue":
location.href="EditCriticalIssues.aspx?id=" + selectedItem.getCell(0).getValue();
break;

case "Add New Critical Issue":
location.href="EditCriticalIssues.aspx";
break;

case "Close Critical Issue":
alert('close critical issue');
break;

case "Delete Critical Issue":
ans = confirm('Are you sure that you want to delete this row?');
CursorWait();
if(ans==true){
location.href="EditCriticalIssues.aspx?flag=D&id=" + selectedItem.getCell(0).getValue();
}
break;
}
}

function CursorWait(){
document.body.style.cursor = 'wait';
}

function CursorDefault(){
document.body.style.cursor = 'default';
}

function CallbackBeforeExecute(){
CursorWait();
}

</script>

<style type="text/css">
.style1
{
height: 13px;
}
</style>

</head>
<body style="background-color: #C0C0C0">
<embed src="images\pop.wav" autostart="false" width="0" height="0" id="sound1" enablejavascript="true">
<form id="form1" runat="server">
<eo:CallbackPanel runat="server" id="CallbackPanel1" Triggers="{ControlID:ddIssueCat;Parameter:},{ControlID:ddResourceGroup;Parameter:},{ControlID:ddStatus;Parameter:},{ControlID:ddPhase;Parameter:},{ControlID:ddProject;Parameter:},{ControlID:ddPM;Parameter:},{ControlID:RadioButtonList1;Parameter:}"
Height="550px" AutoDisableContents="True" SafeGuardUpdate="False"
ClientSideBeforeExecute="CallbackBeforeExecute"
ClientSideAfterExecute="CursorDefault"
LoadingHTML="&lt;table border=0&gt;
&lt;tr&gt;
&lt;td style=&quot;width:800px; font:100% Tahoma;&quot;&gt;
&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;
&lt;center&gt;Processing...
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;"
Width="95%"
ClientSideOnLoad="LoadIt"
ClientSideOnMessage="" ClientSideOnUnload="UnLoadIt"
LoadingDialogID="" LoadingPanelID="Panel1">

<table style="border: 1px solid #000000; background-color: #FFFFEA;">
<tr style="height: 5px">
<td class="style1" colspan="8" style="height: 5px">&nbsp;</td>
</tr>
<tr><td>&nbsp;&nbsp;</td>
<td>
<asp:Label ID="Label1" runat="server" Font-Names="Tahoma" Font-Size="Smaller"
Text="PM: "></asp:Label>
<br />
<asp:DropDownList ID="ddPM" runat="server" Font-Names="Tahoma"
Font-Size="Smaller" Width="150px">
</asp:DropDownList>
&nbsp;&nbsp;</td>
<td>
<asp:Label ID="Label2" runat="server" Font-Names="Tahoma" Font-Size="Smaller"
Text="Project: "></asp:Label>
<br />
<asp:DropDownList ID="ddProject" runat="server" Font-Names="Tahoma"
Font-Size="Smaller" Width="75px">
</asp:DropDownList>
&nbsp;&nbsp;</td>
<td>
<asp:Label ID="Label3" runat="server" Font-Names="Tahoma" Font-Size="Smaller"
Text="Phase: "></asp:Label>
<br />
<asp:DropDownList ID="ddPhase" runat="server" Font-Names="Tahoma"
Font-Size="Smaller" Width="50px">
</asp:DropDownList>
&nbsp;&nbsp;</td>
<td>
<asp:Label ID="Label4" runat="server" Font-Names="Tahoma" Font-Size="Smaller"
Text="Status: "></asp:Label>
<br />
<asp:DropDownList ID="ddStatus" runat="server" AutoPostBack="True"
Font-Names="Tahoma" Font-Size="Smaller" Width="150px">
<asp:ListItem>[All]</asp:ListItem>
<asp:ListItem Selected="True">New/Open</asp:ListItem>
<asp:ListItem>Open</asp:ListItem>
<asp:ListItem>New</asp:ListItem>
<asp:ListItem>Closed</asp:ListItem>
</asp:DropDownList>
&nbsp;&nbsp;</td>
<td style="width: 180px">
<asp:Label ID="Label5" runat="server" Font-Names="Tahoma" Font-Size="Smaller"
Text="Issue Category: "></asp:Label>
<br />
<asp:DropDownList ID="ddIssueCat" runat="server" AutoPostBack="True"
Font-Names="Tahoma" Font-Size="Smaller" Width="150px">
<asp:ListItem Selected="True">[All]</asp:ListItem>
<asp:ListItem>Budget</asp:ListItem>
<asp:ListItem>Delivery</asp:ListItem>
<asp:ListItem>Customer</asp:ListItem>
<asp:ListItem>Vendor</asp:ListItem>
<asp:ListItem>Tech Hurdle</asp:ListItem>
<asp:ListItem>Resource</asp:ListItem>
<asp:ListItem>Other</asp:ListItem>
</asp:DropDownList>
&nbsp;&nbsp;</td>
<td style="width: 180px">
<asp:Label ID="Label6" runat="server" Font-Names="Tahoma" Font-Size="Smaller"
Text="Resource Group: "></asp:Label>
<br />
<asp:DropDownList ID="ddResourceGroup" runat="server" AutoPostBack="True"
Font-Names="Tahoma" Font-Size="Smaller" Width="150px">
<asp:ListItem Selected="True">[All]</asp:ListItem>
<asp:ListItem>AE</asp:ListItem>
<asp:ListItem>PM</asp:ListItem>
<asp:ListItem>CE</asp:ListItem>
<asp:ListItem>ME</asp:ListItem>
<asp:ListItem>TR</asp:ListItem>
<asp:ListItem>MA</asp:ListItem>
<asp:ListItem>CA</asp:ListItem>
<asp:ListItem>Matl</asp:ListItem>
<asp:ListItem>Mgmt</asp:ListItem>
</asp:DropDownList>
&nbsp;&nbsp;</td>
<td>
&nbsp;&nbsp;</td>
</tr>
<tr style="height: 5px">
<td colspan="8">
&nbsp;</td>
</tr>
</table>
<table>
<tr>
<td><asp:Label ID="Label8" runat="server" Font-Names="Tahoma" Font-Size="Smaller" Text="Choose Grid:"></asp:Label></td>
<td><asp:RadioButtonList ID="RadioButtonList1" runat="server" Font-Names="Tahoma"
Font-Size="Smaller" RepeatDirection="Horizontal"
Width="400px">
<asp:ListItem Selected="True">PM Notes Listing</asp:ListItem>
<asp:ListItem>Risk Items Listing</asp:ListItem>
<asp:ListItem>Critical Issues Listing</asp:ListItem>
</asp:RadioButtonList></td>
</tr>
</table>
<asp:Panel ID="Panel1" runat="server">
&nbsp;&nbsp;
<div ondblclick="GridDblClick()">
<eo:Grid ID="Grid1" runat="server" BorderColor="#7F9DB9" BorderWidth="1px"
ColumnHeaderAscImage="00050104" ColumnHeaderDescImage="00050105"
ColumnHeaderDividerImage="divider.gif" FixedColumnCount="7" Font-Names="Tahoma"
Font-Size="8.75pt" GoToBoxVisible="True" GridLineColor="220, 223, 228"
ItemHeight="17" LoadingHTML="test" AllowColumnReorder="True"
GridLines="Both" Height="500px" Width="95%" Font-Bold="False"
Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
Font-Underline="False" ClientSideOnContextMenu="ShowContextMenu"
ColumnHeaderHeight="92" ClientSideOnLoad="LoadIt" ClientSideOnSort="LoadIt"
ClientSideOnUnload="UnLoadIt" EnableKeyboardNavigation="True"
ImageBaseDirectory="~\images" StyleIDField="StyleSet"
StyleSetIDField="StyleSet">
<FooterStyle CssText="padding-bottom:4px;padding-left:4px;padding-right:4px;padding-top:4px;">
</FooterStyle>
<ItemStyles>
<eo:GridItemStyleSet>
<ItemStyle CssText="cursor:default; background-color: white"></ItemStyle>
<itemhoverstyle csstext="cursor:default; background-color: whitesmoke" />
<selectedstyle csstext="cursor:default; background-color:#316ac5;color:white;" />
<FixedColumnCellStyle CssText="cursor:default; border-right: #d6d2c2 1px solid; padding-right: 10px; border-top: #faf9f4 1px solid; border-left: #faf9f4 1px solid; border-bottom: #d6d2c2 1px solid; background-color: #ebeadb; text-align: right; color: black;"></FixedColumnCellStyle>
<cellstyle csstext="cursor:default; padding-left:8px;padding-top:2px;" />
</eo:GridItemStyleSet>
<eo:GridItemStyleSet StyleSetID="RED">
<ItemStyle CssText="cursor:default; background-color: white; color:red;"></ItemStyle>
<itemhoverstyle csstext="cursor:default; background-color: whitesmoke" />
<selectedstyle csstext="cursor:default; background-color:#316ac5;color:white;" />
<FixedColumnCellStyle CssText="cursor:default; border-right: #d6d2c2 1px solid; padding-right: 10px; border-top: #faf9f4 1px solid; border-left: #faf9f4 1px solid; border-bottom: #d6d2c2 1px solid; background-color: #ebeadb; text-align: right; color: black;"></FixedColumnCellStyle>
<cellstyle csstext="cursor:default; padding-left:8px;padding-top:2px;" />
</eo:GridItemStyleSet>
<eo:GridItemStyleSet StyleSetID="GRAY">
<ItemStyle CssText="cursor:default; background-color: white; color:gray;"></ItemStyle>
<itemhoverstyle csstext="cursor:default; background-color: whitesmoke" />
<selectedstyle csstext="cursor:default; background-color:#316ac5;color:white;" />
<FixedColumnCellStyle CssText="cursor:default; border-right: #d6d2c2 1px solid; padding-right: 10px; border-top: #faf9f4 1px solid; border-left: #faf9f4 1px solid; border-bottom: #d6d2c2 1px solid; background-color: #ebeadb; text-align: right; color: black;"></FixedColumnCellStyle>
<cellstyle csstext="cursor:default; padding-left:8px;padding-top:2px;" />
</eo:GridItemStyleSet>
</ItemStyles>
<ColumnHeaderTextStyle CssText="font-size: 8px" />
<gotoboxstyle
csstext="BORDER-RIGHT: #7f9db9 1px solid; BORDER-TOP: #7f9db9 1px solid; BORDER-LEFT: #7f9db9 1px solid; WIDTH: 40px; BORDER-BOTTOM: #7f9db9 1px solid"></gotoboxstyle>
<contentpanestyle
csstext="border-bottom-color:#7f9db9;border-bottom-style:solid;border-bottom-width:1px;border-left-color:#7f9db9;border-left-style:solid;border-left-width:1px;border-right-color:#7f9db9;border-right-style:solid;border-right-width:1px;border-top-color:#7f9db9;border-top-style:solid;border-top-width:1px;"></contentpanestyle>
<Columns>
<eo:StaticColumn Width="10" DataField="id" HeaderText="&lt;br&gt;Id" AllowSort="False" ReadOnly="True" Visible="False">
<CellStyle CssText="text-align:left;" /></eo:StaticColumn>
<eo:StaticColumn Width="65" DataField="order_no"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Project"
AllowSort="True" ReadOnly="True">
<CellStyle CssText="text-align:left;" /></eo:StaticColumn>
<eo:StaticColumn Width="200" DataField="ProjectDesc"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Description"
AllowSort="True" ReadOnly="True">
<CellStyle CssText="text-align:left;" /></eo:StaticColumn>
<eo:StaticColumn Width="40" DataField="item"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Item"
AllowSort="True" ReadOnly="True">
<CellStyle CssText="text-align:center;" /></eo:StaticColumn>
<eo:StaticColumn Width="40" DataField="item_rev"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Rev"
AllowSort="True" ReadOnly="True">
<CellStyle CssText="text-align:center;" /></eo:StaticColumn>
<eo:StaticColumn Width="30" DataField="phase"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Ph"
AllowSort="True" ReadOnly="True">
<CellStyle CssText="text-align:center;" /></eo:StaticColumn>
<eo:StaticColumn Width="250" DataField="issue_desc"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Issue Description"
AllowSort="True" ReadOnly="True">
<CellStyle CssText="text-align: left; border-right-style: solid; border-right-width: thin; border-right-color: #000000;" />
</eo:StaticColumn>
<eo:StaticColumn Width="250" DataField="action"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Action Required"
AllowSort="True" ReadOnly="True"></eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="assigned"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Assigned"
ReadOnly="True"></eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="datereq"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Date Req."
ReadOnly="True" Width="80"></eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="init"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Initiated"
ReadOnly="True" Width="80"></eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="cat_budg1"
HeaderText="&lt;img src='images\issue_budget.gif'&gt;" ReadOnly="True"
DataFormat="<img src='images\blackx.gif' {0} />" Width="30">
<CellStyle CssText="vertical-align:top; text-align: center;" /></eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="cat_deliv1"
HeaderText="&lt;img src='images\issue_delivery.gif'&gt;" ReadOnly="True"
DataFormat="<img src='images\blackx.gif' {0} />" Width="30">
<CellStyle CssText="vertical-align:top; text-align: center;" /></eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="cat_cust1"
HeaderText="&lt;img src='images\issue_customer.gif'&gt;" ReadOnly="True"
DataFormat="<img src='images\blackx.gif' {0} />" Width="30">
<CellStyle CssText="vertical-align:top; text-align: center;" /></eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="cat_vend1"
HeaderText="&lt;img src='images\issue_vendor.gif'&gt;" ReadOnly="True"
DataFormat="<img src='images\blackx.gif' {0} />" Width="30">
<CellStyle CssText="vertical-align:top; text-align: center;" /></eo:StaticColumn>
<eo:StaticColumn DataField="cat_tech1"
HeaderText="&lt;img src='images\issue_tech.gif'&gt;" AllowSort="True" ReadOnly="True"
DataFormat="<img src='images\blackx.gif' {0} />" Width="30">
<CellStyle CssText="vertical-align:top; text-align: center;" />
</eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="cat_resource1"
HeaderText="&lt;img src='images\issue_resource.gif'&gt;" ReadOnly="True"
DataFormat="<img src='images\blackx.gif' {0} />" Width="30">
<CellStyle CssText="vertical-align:top; text-align: center;" />
</eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="cat_other1"
HeaderText="&lt;img src='images\issue_other.gif'&gt;" ReadOnly="True"
DataFormat="<img src='images\blackx.gif' {0} />" Width="30">
<CellStyle CssText="vertical-align:top; text-align: center;" />
</eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="rg_ae1" HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;AE"
ReadOnly="True"
DataFormat="<img src='images\blackx.gif' {0} />" Width="30">
<CellStyle CssText="text-align: center;" />
</eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="rg_pm1" HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;PM"
ReadOnly="True"
DataFormat="<img src='images\blackx.gif' {0} />" Width="30">
<CellStyle CssText="vertical-align:top; text-align: center;" /></eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="rg_ce1" HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;CE"
ReadOnly="True"
DataFormat="<img src='images\blackx.gif' {0} />" Width="30">
<CellStyle CssText="vertical-align:top; text-align: center;" /></eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="rg_me1" HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;ME"
ReadOnly="True"
DataFormat="<img src='images\blackx.gif' {0} />" Width="30">
<CellStyle CssText="vertical-align:top; text-align: center;" /></eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="rg_tr1" HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;TR"
ReadOnly="True"
DataFormat="<img src='images\blackx.gif' {0} />" Width="30">
<CellStyle CssText="vertical-align:top; text-align: center;" /></eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="rg_ma1" HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;MA"
ReadOnly="True"
DataFormat="<img src='images\blackx.gif' {0} />" Width="30">
<CellStyle CssText="vertical-align:top; text-align: center;" /></eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="rg_ca1" HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;CA"
ReadOnly="True"
DataFormat="<img src='images\blackx.gif' {0} />" Width="30">
<CellStyle CssText="vertical-align:top; text-align: center;" /></eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="rg_matl1"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Matl" ReadOnly="True"
DataFormat="<img src='images\blackx.gif' {0} />" Width="40">
<CellStyle CssText="vertical-align:top; text-align: center;" /></eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="rg_mgmt1"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Mgmt" ReadOnly="True"
DataFormat="<img src='images\blackx.gif' {0} />" Width="45">
<CellStyle CssText="vertical-align:top; text-align: center;" /></eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="status"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Status"
ReadOnly="True" Width="55"></eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="PM" HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Proj. Mgr."
ReadOnly="True" Width="175"></eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="crit_action1"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Crit.&lt;br&gt;Action" ReadOnly="True"
DataFormat="<img src='images\blackx.gif' {0} />" Width="60">
<CellStyle CssText="vertical-align:top; text-align: center;" /></eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="risk_item1"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Risk&lt;br&gt;Item" ReadOnly="True"
DataFormat="<img src='images\blackx.gif' {0} />" Width="60">
<CellStyle CssText="vertical-align:top; text-align: center;" /></eo:StaticColumn>
<eo:StaticColumn Width="20" DataField="riskid" HeaderText="&lt;br&gt;RiskId" AllowSort="False" ReadOnly="True" Visible="False">
<CellStyle CssText="text-align:left;" /></eo:StaticColumn>
<eo:StaticColumn Width="20" DataField="critid" HeaderText="&lt;br&gt;CritId" AllowSort="False" ReadOnly="True" Visible="False">
<CellStyle CssText="text-align:left;" /></eo:StaticColumn>
</Columns>

<columnheaderstyle
csstext="background-image:url('~/double.gif');padding-left:8px;padding-top:3px;"></columnheaderstyle>
</eo:Grid>
<eo:Grid ID="Grid2" runat="server" BorderColor="#7F9DB9" BorderWidth="1px"
ColumnHeaderAscImage="00050104" ColumnHeaderDescImage="00050105"
ColumnHeaderDividerImage="divider.gif" FixedColumnCount="6" Font-Names="Tahoma"
Font-Size="8.75pt" GoToBoxVisible="True" GridLineColor="220, 223, 228"
ItemHeight="17" LoadingHTML="test" AllowColumnReorder="True"
GridLines="Both" Height="500px" Width="95%" Font-Bold="False"
Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
Font-Underline="False" ClientSideOnContextMenu="ShowContextMenu2"
ColumnHeaderHeight="92" ClientSideOnLoad="LoadIt" ClientSideOnSort="LoadIt"
ClientSideOnUnload="UnLoadIt" EnableKeyboardNavigation="True"
ImageBaseDirectory="~\images" StyleIDField="StyleSet"
StyleSetIDField="StyleSet">
<FooterStyle CssText="padding-bottom:4px;padding-left:4px;padding-right:4px;padding-top:4px;">
</FooterStyle>
<ItemStyles>
<eo:GridItemStyleSet>
<ItemStyle CssText="cursor:default; background-color: white"></ItemStyle>
<itemhoverstyle csstext="cursor:default; background-color: whitesmoke" />
<selectedstyle csstext="cursor:default; background-color:#316ac5;color:white;" />
<FixedColumnCellStyle CssText="cursor:default; border-right: #d6d2c2 1px solid; padding-right: 10px; border-top: #faf9f4 1px solid; border-left: #faf9f4 1px solid; border-bottom: #d6d2c2 1px solid; background-color: #ebeadb; text-align: right; color: black;"></FixedColumnCellStyle>
<cellstyle csstext="cursor:default; padding-left:8px;padding-top:2px;" />
</eo:GridItemStyleSet>
<eo:GridItemStyleSet StyleSetID="RED">
<ItemStyle CssText="cursor:default; background-color: white; color:red;"></ItemStyle>
<itemhoverstyle csstext="cursor:default; background-color: whitesmoke" />
<selectedstyle csstext="cursor:default; background-color:#316ac5;color:white;" />
<FixedColumnCellStyle CssText="cursor:default; border-right: #d6d2c2 1px solid; padding-right: 10px; border-top: #faf9f4 1px solid; border-left: #faf9f4 1px solid; border-bottom: #d6d2c2 1px solid; background-color: #ebeadb; text-align: right; color: black;"></FixedColumnCellStyle>
<cellstyle csstext="cursor:default; padding-left:8px;padding-top:2px;" />
</eo:GridItemStyleSet>
<eo:GridItemStyleSet StyleSetID="GRAY">
<ItemStyle CssText="cursor:default; background-color: white; color:gray;"></ItemStyle>
<itemhoverstyle csstext="cursor:default; background-color: whitesmoke" />
<selectedstyle csstext="cursor:default; background-color:#316ac5;color:white;" />
<FixedColumnCellStyle CssText="cursor:default; border-right: #d6d2c2 1px solid; padding-right: 10px; border-top: #faf9f4 1px solid; border-left: #faf9f4 1px solid; border-bottom: #d6d2c2 1px solid; background-color: #ebeadb; text-align: right; color: black;"></FixedColumnCellStyle>
<cellstyle csstext="cursor:default; padding-left:8px;padding-top:2px;" />
</eo:GridItemStyleSet>
</ItemStyles>
<ColumnHeaderTextStyle CssText="font-size: 8px" />
<gotoboxstyle
csstext="BORDER-RIGHT: #7f9db9 1px solid; BORDER-TOP: #7f9db9 1px solid; BORDER-LEFT: #7f9db9 1px solid; WIDTH: 40px; BORDER-BOTTOM: #7f9db9 1px solid"></gotoboxstyle>
<contentpanestyle
csstext="border-bottom-color:#7f9db9;border-bottom-style:solid;border-bottom-width:1px;border-left-color:#7f9db9;border-left-style:solid;border-left-width:1px;border-right-color:#7f9db9;border-right-style:solid;border-right-width:1px;border-top-color:#7f9db9;border-top-style:solid;border-top-width:1px;"></contentpanestyle>
<Columns>
<eo:StaticColumn Width="10" DataField="id" HeaderText="&lt;br&gt;Id" AllowSort="False" ReadOnly="True" Visible="False">
<CellStyle CssText="text-align:left;" /></eo:StaticColumn>
<eo:StaticColumn Width="65" DataField="order_no"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Project"
AllowSort="True" ReadOnly="True">
<CellStyle CssText="text-align:left;" /></eo:StaticColumn>
<eo:StaticColumn Width="200" DataField="ProjectDesc"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Description"
AllowSort="True" ReadOnly="True">
<CellStyle CssText="text-align:left;" /></eo:StaticColumn>
<eo:StaticColumn Width="40" DataField="item"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Item"
AllowSort="True" ReadOnly="True">
<CellStyle CssText="text-align:center;" /></eo:StaticColumn>
<eo:StaticColumn Width="30" DataField="phase"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Ph"
AllowSort="True" ReadOnly="True">
<CellStyle CssText="text-align:center;" /></eo:StaticColumn>
<eo:StaticColumn Width="250" DataField="risk_desc"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Risk Description"
AllowSort="True" ReadOnly="True">
<CellStyle CssText="text-align: left; border-right-style: solid; border-right-width: thin; border-right-color: #000000;" />
</eo:StaticColumn>
<eo:StaticColumn Width="90" AllowSort="True" DataField="est_risk"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Est.&lt;br&gt;Risk ($)"
ReadOnly="True"></eo:StaticColumn>
<eo:StaticColumn Width="50" AllowSort="True" DataField="probability"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Prob.&lt;br&gt;(%)"
ReadOnly="True"></eo:StaticColumn>
<eo:StaticColumn Width="65" AllowSort="True" DataField="delivery_impact"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;Delivery&lt;br&gt;Impact&lt;br&gt;(wks)"
ReadOnly="True"></eo:StaticColumn>
<eo:StaticColumn Width="90" AllowSort="True" DataField="risk_covered_CTC"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;Risk&lt;br&gt;Covered&lt;br&gt;in CTC ($)"
ReadOnly="True"></eo:StaticColumn>
<eo:StaticColumn Width="250" DataField="trigger_pt"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Trigger Point"
AllowSort="True" ReadOnly="True"></eo:StaticColumn>
<eo:StaticColumn Width="250" AllowSort="True" DataField="risk_mitigation"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Risk Mitigation Actions Taken"
ReadOnly="True"></eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="init"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Initiated"
ReadOnly="True" Width="80"></eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="status"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Status"
ReadOnly="True" Width="55"></eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="PM" HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Proj. Mgr."
ReadOnly="True" Width="175"></eo:StaticColumn>
<eo:StaticColumn Width="75" AllowSort="True" DataField="notes_id"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Notes Item"
ReadOnly="True"></eo:StaticColumn>
</Columns>
<columnheaderstyle
csstext="background-image:url('~/double.gif');padding-left:8px;padding-top:3px;"></columnheaderstyle>
</eo:Grid>
<eo:Grid ID="Grid3" runat="server" BorderColor="#7F9DB9" BorderWidth="1px"
ColumnHeaderAscImage="00050104" ColumnHeaderDescImage="00050105"
ColumnHeaderDividerImage="divider.gif" FixedColumnCount="6" Font-Names="Tahoma"
Font-Size="8.75pt" GoToBoxVisible="True" GridLineColor="220, 223, 228"
ItemHeight="17" LoadingHTML="test" AllowColumnReorder="True"
GridLines="Both" Height="500px" Width="95%" Font-Bold="False"
Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
Font-Underline="False" ClientSideOnContextMenu="ShowContextMenu3"
ColumnHeaderHeight="92" ClientSideOnLoad="LoadIt" ClientSideOnSort="LoadIt"
ClientSideOnUnload="UnLoadIt" EnableKeyboardNavigation="True"
ImageBaseDirectory="~\images" StyleIDField="StyleSet"
StyleSetIDField="StyleSet">
<FooterStyle CssText="padding-bottom:4px;padding-left:4px;padding-right:4px;padding-top:4px;">
</FooterStyle>
<ItemStyles>
<eo:GridItemStyleSet>
<ItemStyle CssText="cursor:default; background-color: white"></ItemStyle>
<itemhoverstyle csstext="cursor:default; background-color: whitesmoke" />
<selectedstyle csstext="cursor:default; background-color:#316ac5;color:white;" />
<FixedColumnCellStyle CssText="cursor:default; border-right: #d6d2c2 1px solid; padding-right: 10px; border-top: #faf9f4 1px solid; border-left: #faf9f4 1px solid; border-bottom: #d6d2c2 1px solid; background-color: #ebeadb; text-align: right; color: black;"></FixedColumnCellStyle>
<cellstyle csstext="cursor:default; padding-left:8px;padding-top:2px;" />
</eo:GridItemStyleSet>
<eo:GridItemStyleSet StyleSetID="RED">
<ItemStyle CssText="cursor:default; background-color: white; color:red;"></ItemStyle>
<itemhoverstyle csstext="cursor:default; background-color: whitesmoke" />
<selectedstyle csstext="cursor:default; background-color:#316ac5;color:white;" />
<FixedColumnCellStyle CssText="cursor:default; border-right: #d6d2c2 1px solid; padding-right: 10px; border-top: #faf9f4 1px solid; border-left: #faf9f4 1px solid; border-bottom: #d6d2c2 1px solid; background-color: #ebeadb; text-align: right; color: black;"></FixedColumnCellStyle>
<cellstyle csstext="cursor:default; padding-left:8px;padding-top:2px;" />
</eo:GridItemStyleSet>
<eo:GridItemStyleSet StyleSetID="GRAY">
<ItemStyle CssText="cursor:default; background-color: white; color:gray;"></ItemStyle>
<itemhoverstyle csstext="cursor:default; background-color: whitesmoke" />
<selectedstyle csstext="cursor:default; background-color:#316ac5;color:white;" />
<FixedColumnCellStyle CssText="cursor:default; border-right: #d6d2c2 1px solid; padding-right: 10px; border-top: #faf9f4 1px solid; border-left: #faf9f4 1px solid; border-bottom: #d6d2c2 1px solid; background-color: #ebeadb; text-align: right; color: black;"></FixedColumnCellStyle>
<cellstyle csstext="cursor:default; padding-left:8px;padding-top:2px;" />
</eo:GridItemStyleSet>
</ItemStyles>
<ColumnHeaderTextStyle CssText="font-size: 8px" />
<gotoboxstyle
csstext="BORDER-RIGHT: #7f9db9 1px solid; BORDER-TOP: #7f9db9 1px solid; BORDER-LEFT: #7f9db9 1px solid; WIDTH: 40px; BORDER-BOTTOM: #7f9db9 1px solid"></gotoboxstyle>
<contentpanestyle
csstext="border-bottom-color:#7f9db9;border-bottom-style:solid;border-bottom-width:1px;border-left-color:#7f9db9;border-left-style:solid;border-left-width:1px;border-right-color:#7f9db9;border-right-style:solid;border-right-width:1px;border-top-color:#7f9db9;border-top-style:solid;border-top-width:1px;"></contentpanestyle>
<Columns>
<eo:StaticColumn Width="10" DataField="id" HeaderText="&lt;br&gt;Id" AllowSort="False" ReadOnly="True" Visible="False">
<CellStyle CssText="text-align:left;" /></eo:StaticColumn>
<eo:StaticColumn Width="65" DataField="order_no"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Project"
AllowSort="True" ReadOnly="True">
<CellStyle CssText="text-align:left;" /></eo:StaticColumn>
<eo:StaticColumn Width="200" DataField="ProjectDesc"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Description"
AllowSort="True" ReadOnly="True">
<CellStyle CssText="text-align:left;" /></eo:StaticColumn>
<eo:StaticColumn Width="40" DataField="item"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Item"
AllowSort="True" ReadOnly="True">
<CellStyle CssText="text-align:center;" /></eo:StaticColumn>
<eo:StaticColumn Width="30" DataField="phase"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Ph"
AllowSort="True" ReadOnly="True">
<CellStyle CssText="text-align:center;" /></eo:StaticColumn>
<eo:StaticColumn Width="250" DataField="critical_desc"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Critical Issue Description"
AllowSort="True" ReadOnly="True">
<CellStyle CssText="text-align: left; border-right-style: solid; border-right-width: thin; border-right-color: #000000;" />
</eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="cat_fin" HeaderText="&lt;img src='images\issue_financial.gif'&gt;"
ReadOnly="True"
DataFormat="<img src='images\blackx.gif' {0} />" Width="30">
<CellStyle CssText="text-align: center;" />
</eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="cat_deliv" HeaderText="&lt;img src='images\issue_delivery.gif'&gt;"
ReadOnly="True"
DataFormat="<img src='images\blackx.gif' {0} />" Width="30">
<CellStyle CssText="vertical-align:top; text-align: center;" /></eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="cat_cust" HeaderText="&lt;img src='images\issue_complaint.gif'&gt;"
ReadOnly="True"
DataFormat="<img src='images\blackx.gif' {0} />" Width="30">
<CellStyle CssText="vertical-align:top; text-align: center;" /></eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="cat_status" HeaderText="&lt;img src='images\issue_status.gif'&gt;"
ReadOnly="True"
DataFormat="<img src='images\blackx.gif' {0} />" Width="30">
<CellStyle CssText="vertical-align:top; text-align: center;" /></eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="cat_other" HeaderText="&lt;img src='images\issue_other.gif'&gt;"
ReadOnly="True"
DataFormat="<img src='images\blackx.gif' {0} />" Width="30">
<CellStyle CssText="vertical-align:top; text-align: center;" /></eo:StaticColumn>
<eo:StaticColumn Width="80" AllowSort="True" DataField="impact"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;Impact&lt;br&gt;of &lt;br&gt;Issue ($)"
ReadOnly="True"></eo:StaticColumn>
<eo:StaticColumn Width="60" AllowSort="True" DataField="delivery_impact"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;Delivery&lt;br&gt;Impact&lt;br&gt;(wk)"
ReadOnly="True"></eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="step7rpt" HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;7 Step&lt;br&gt;Req'd?"
ReadOnly="True"
DataFormat="<img src='images\blackx.gif' {0} />" Width="50">
<CellStyle CssText="vertical-align:top; text-align: center;" /></eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="init"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Initiated"
ReadOnly="True" Width="80"></eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="status"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Status"
ReadOnly="True" Width="55"></eo:StaticColumn>
<eo:StaticColumn AllowSort="True" DataField="PM" HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Proj. Mgr."
ReadOnly="True" Width="175"></eo:StaticColumn>
<eo:StaticColumn Width="75" AllowSort="True" DataField="notes_id"
HeaderText="&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;Notes Item"
ReadOnly="True"></eo:StaticColumn>
</Columns>
<columnheaderstyle
csstext="background-image:url('~/double.gif');padding-left:8px;padding-top:3px;"></columnheaderstyle>
</eo:Grid>
</div>
<p>
</p>
<p>
</p>
<asp:Label ID="Label7" runat="server" Text="Records: " Font-Bold="True"
Font-Names="Tahoma" Font-Size="Smaller"></asp:Label>
<asp:Label ID="Message" runat="server" Font-Names="Tahoma" Font-Size="Smaller"></asp:Label>
</asp:Panel>
</eo:CallbackPanel>
<eo:ContextMenu ID="ContextMenu1" runat="server" Width="400px" ClientSideOnItemClick="OnContextMenuItemClicked1">
<TopGroup Style-CssText="cursor:hand;font-family:Verdana;font-size:11px;">
<Items>
<eo:MenuItem Text-Html="Edit Note" LeftIcon-Url="00101007"></eo:MenuItem>
<eo:MenuItem Text-Html="Edit Risk Info for this Note" LeftIcon-Url="00101007"></eo:MenuItem>
<eo:MenuItem Text-Html="Edit Critical Issue for this Note" LeftIcon-Url="00101007"></eo:MenuItem>
<eo:MenuItem IsSeparator="True"></eo:MenuItem>
<eo:MenuItem Text-Html="View Issue Desc. / Action Required" RaisesServerEvent="False"
Image-Mode="NotSet" LeftIcon-Url="00101006"></eo:MenuItem>
<eo:MenuItem IsSeparator="True"></eo:MenuItem>
<eo:MenuItem Text-Html="Add New Note" LeftIcon-SelectedUrl="http:"
LeftIcon-Url="00101001"></eo:MenuItem>
<eo:MenuItem Text-Html="Attach New Risk Info" LeftIcon-Url="00101059"></eo:MenuItem>
<eo:MenuItem Text-Html="Attach New Critical Issue" LeftIcon-Url="00101059"></eo:MenuItem>
<eo:MenuItem IsSeparator="True"></eo:MenuItem>
<eo:MenuItem Text-Html="Close Revision(s)" RaisesServerEvent="False"
LeftIcon-Url="00101023"></eo:MenuItem>
<eo:MenuItem IsSeparator="True"></eo:MenuItem>
<eo:MenuItem Text-Html="Delete Note" RaisesServerEvent="True"
LeftIcon-Url="00000208"></eo:MenuItem>
</Items>
</TopGroup>
<LookItems>
<eo:MenuItem IsSeparator="True" ItemID="_Separator" NormalStyle-CssText="background-color:#E0E0E0;height:1px;width:1px;"></eo:MenuItem>
<eo:MenuItem HoverStyle-CssText="color:#F7B00A;padding-left:5px;padding-right:5px;" ItemID="_Default"
NormalStyle-CssText="padding-left:5px;padding-right:5px;">
<SubMenu ExpandEffect-Type="GlideTopToBottom" Style-CssText="border-right: #e0e0e0 1px solid; padding-right: 3px; border-top: #e0e0e0 1px solid; padding-left: 3px; font-size: 12px; padding-bottom: 3px; border-left: #e0e0e0 1px solid; cursor: hand; color: #606060; padding-top: 3px; border-bottom: #e0e0e0 1px solid; font-family: arial; background-color: #f7f8f9"
CollapseEffect-Type="GlideTopToBottom" OffsetX="3" ShadowDepth="0" OffsetY="-4" ItemSpacing="5"></SubMenu>
</eo:MenuItem>
</LookItems>
</eo:ContextMenu>
<eo:ContextMenu ID="ContextMenu2" runat="server" Width="400px" ClientSideOnItemClick="OnContextMenuItemClicked2">
<TopGroup Style-CssText="cursor:hand;font-family:Verdana;font-size:11px;">
<Items>
<eo:MenuItem Text-Html="Edit Risk Item" LeftIcon-Url="00101007"></eo:MenuItem>
<eo:MenuItem IsSeparator="True"></eo:MenuItem>
<eo:MenuItem Text-Html="View Risk Description" RaisesServerEvent="False"
Image-Mode="NotSet" LeftIcon-Url="00101006"></eo:MenuItem>
<eo:MenuItem Text-Html="View Trigger Pt. / Mitg. Actions" RaisesServerEvent="False"
Image-Mode="NotSet" LeftIcon-Url="00101006"></eo:MenuItem>
<eo:MenuItem IsSeparator="True"></eo:MenuItem>
<eo:MenuItem Text-Html="Add New Risk Item" LeftIcon-SelectedUrl="http:"
LeftIcon-Url="00101001"></eo:MenuItem>
<eo:MenuItem IsSeparator="True"></eo:MenuItem>
<eo:MenuItem Text-Html="Close Risk Item" RaisesServerEvent="False"
LeftIcon-Url="00101023"></eo:MenuItem>
<eo:MenuItem IsSeparator="True"></eo:MenuItem>
<eo:MenuItem Text-Html="Delete Risk Item" RaisesServerEvent="True"
LeftIcon-Url="00000208"></eo:MenuItem>
</Items>
</TopGroup>
<LookItems>
<eo:MenuItem IsSeparator="True" ItemID="_Separator" NormalStyle-CssText="background-color:#E0E0E0;height:1px;width:1px;"></eo:MenuItem>
<eo:MenuItem HoverStyle-CssText="color:#F7B00A;padding-left:5px;padding-right:5px;" ItemID="_Default"
NormalStyle-CssText="padding-left:5px;padding-right:5px;">
<SubMenu ExpandEffect-Type="GlideTopToBottom" Style-CssText="border-right: #e0e0e0 1px solid; padding-right: 3px; border-top: #e0e0e0 1px solid; padding-left: 3px; font-size: 12px; padding-bottom: 3px; border-left: #e0e0e0 1px solid; cursor: hand; color: #606060; padding-top: 3px; border-bottom: #e0e0e0 1px solid; font-family: arial; background-color: #f7f8f9"
CollapseEffect-Type="GlideTopToBottom" OffsetX="3" ShadowDepth="0" OffsetY="-4" ItemSpacing="5"></SubMenu>
</eo:MenuItem>
</LookItems>
</eo:ContextMenu>
<eo:ContextMenu ID="ContextMenu3" runat="server" Width="400px" ClientSideOnItemClick="OnContextMenuItemClicked3">
<TopGroup Style-CssText="cursor:hand;font-family:Verdana;font-size:11px;">
<Items>
<eo:MenuItem Text-Html="Edit Critical Issue" LeftIcon-Url="00101007"></eo:MenuItem>
<eo:MenuItem IsSeparator="True"></eo:MenuItem>
<eo:MenuItem Text-Html="View Critical Issue Desc." RaisesServerEvent="False"
Image-Mode="NotSet" LeftIcon-Url="00101006"></eo:MenuItem>
<eo:MenuItem IsSeparator="True"></eo:MenuItem>
<eo:MenuItem Text-Html="Add New Critical Issue" LeftIcon-SelectedUrl="http:"
LeftIcon-Url="00101001"></eo:MenuItem>
<eo:MenuItem IsSeparator="True"></eo:MenuItem>
<eo:MenuItem Text-Html="Close Critical Issue" RaisesServerEvent="False"
LeftIcon-Url="00101023"></eo:MenuItem>
<eo:MenuItem IsSeparator="True"></eo:MenuItem>
<eo:MenuItem Text-Html="Delete Critical Issue" RaisesServerEvent="True"
LeftIcon-Url="00000208"></eo:MenuItem>
</Items>
</TopGroup>
<LookItems>
<eo:MenuItem IsSeparator="True" ItemID="_Separator" NormalStyle-CssText="background-color:#E0E0E0;height:1px;width:1px;"></eo:MenuItem>
<eo:MenuItem HoverStyle-CssText="color:#F7B00A;padding-left:5px;padding-right:5px;" ItemID="_Default"
NormalStyle-CssText="padding-left:5px;padding-right:5px;">
<SubMenu ExpandEffect-Type="GlideTopToBottom" Style-CssText="border-right: #e0e0e0 1px solid; padding-right: 3px; border-top: #e0e0e0 1px solid; padding-left: 3px; font-size: 12px; padding-bottom: 3px; border-left: #e0e0e0 1px solid; cursor: hand; color: #606060; padding-top: 3px; border-bottom: #e0e0e0 1px solid; font-family: arial; background-color: #f7f8f9"
CollapseEffect-Type="GlideTopToBottom" OffsetX="3" ShadowDepth="0" OffsetY="-4" ItemSpacing="5"></SubMenu>
</eo:MenuItem>
</LookItems>
</eo:ContextMenu>
<eo:MsgBox ID="MsgBox1" runat="server" CloseButtonUrl="00020440"
ControlSkinID="None" HeaderHtml="Dialog Title"
HeaderHtmlFormat="&lt;div style=&quot;padding-top:4px&quot;&gt;{0}&lt;/div&gt;"
HeaderImageHeight="27" HeaderImageUrl="00020441" Width="900px" MinHeight="100"
MinWidth="150" ShowButton="" IconUrl=""
MsgBoxButtonSpacing="10" AllowResize="True">
<HeaderStyleActive CssText="background-image:url(00020442);color:#444444;font-family:'trebuchet ms';font-size:10pt;font-weight:bold;padding-bottom:7px;padding-left:8px;padding-right:0px;padding-top:0px;" />
<BorderImages BottomBorder="00020409,00020429"
BottomLeftCorner="00020408,00020428" BottomRightCorner="00020410,00020430"
LeftBorder="00020406,00020426" RightBorder="00020407,00020427"
TopBorder="00020402,00020422" TopLeftCorner="00020401,00020421"
TopLeftCornerBottom="00020404,00020424" TopRightCorner="00020403,00020423"
TopRightCornerBottom="00020405,00020425" />
<FooterStyleActive CssText="background-color:#f0f0f0; padding-right: 4px; padding-left: 4px; font-size: 8pt; padding-bottom: 4px; padding-top: 4px; font-family: tahoma" />
<MsgBoxButtonStyle CssText="width: 60px" />
<ContentStyleActive CssText="background-color:#f0f0f0;font-family:tahoma;font-size:8pt;padding-bottom:4px;padding-left:4px;padding-right:4px;padding-top:4px" />
<MsgBoxTextStyle CssText="font-family:Tahoma;font-size:Small;padding-bottom:3px;padding-left:3px;padding-right:3px;padding-top:3px;" />
</eo:MsgBox>
</form>
</body>
</html>
James
Posted: Wednesday, August 26, 2009 8:28:49 PM
Rank: Member
Groups: Member

Joined: 7/7/2009
Posts: 12
This is the code behind that gets run when I delete a row from Grid2 [see "DELETE: record" comment]:

Imports System
Imports System.Data
Imports System.Data.Common
Imports System.Data.OleDb
Imports System.Data.SqlClient
Partial Class EditNotes
Inherits System.Web.UI.Page

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim vID = CInt(Request.QueryString("id"))
Dim vFlag = Request.QueryString("flag")
Dim ctr = 0
Dim vSQLString As String, vSQLString2 As String, vSQLString3 As String, vSQLString4 As String, vNextItem As Integer
Dim vNewID As String, vTemp As String, vProject As String, vPhase As String
Dim vIssue As String, vActionReq As String, vResAssn As String, vStatus As String
Dim vDateRes As Date, vIssueCat(6) As Integer, vResGroup(8) As Integer, x As Integer
Dim vProjDesc As String, vPhaseDesc As String, vCustomer As String, vPM As String

'**********************************************************************
'*** INITIALIZE *******************************************************
'**********************************************************************

vIssue = ""
vActionReq = ""
vResAssn = ""
vPM = ""
vCustomer = ""
vProjDesc = ""
vPhaseDesc = ""
vProject = ""
vPhase = ""
vNewID = ""
vStatus = ""
Me.Status.Enabled = False

'*** "E" = EXIT WITHOUT SAVING
If Me.actionflag.Text = "E" Then
Response.Redirect("Default.aspx")
Else
'*** Create Connection
Dim conn As SqlConnection = New SqlConnection("server=DAYTON03;uid=testuser;pwd=password;database=AAA;")

'*** Check for ID to tell if it's a NEW RECORD or EXISTING RECORD
If IsDBNull(vID) = True Or vID = 0 Then
vTemp = Request.Form("NotesID")
If vTemp = "" Or IsDBNull(vTemp) = True Then
vID = 0
Else
vID = CInt(vTemp)
End If
End If

'**********************************************************************
'*** DELETE: Record ***************************************************
'**********************************************************************
If vFlag = "D" Then
If vID > 0 Then
Try
vSQLString = "delete from atw_notes where ID=" & vID

'*** Create command and open connection
Dim comm = New SqlCommand(vSQLString, conn)
If (conn.State = ConnectionState.Open) Then
'Do nothing
Else
comm.Connection.Open()
End If

'*** Create DataReader and Execute
Dim sqlRead5 As SqlDataReader
sqlRead5 = comm.ExecuteReader(CommandBehavior.CloseConnection)

'*** Close DataReader
sqlRead5.Close()
conn.Close()
conn.Dispose()

Catch ex As Exception

End Try

Response.Redirect("Default.aspx")
End If

End If

'**********************************************************************
'*** USER INPUT: GET DATA IF PAGE IS POSTBACK *************************
'**********************************************************************
If Page.IsPostBack Then

Try

'*** Get user input
vIssue = Me.IssueDesc.Text
If InStr(vIssue, "'") > 0 Then
vIssue = Replace(vIssue, "'", "''")
End If
vActionReq = Me.ActionReq.Text
If InStr(vActionReq, "'") > 0 Then
vActionReq = Replace(vActionReq, "'", "''")
End If
vResAssn = Me.ResourceAssign.Text
If InStr(vResAssn, "'") > 0 Then
vResAssn = Replace(vResAssn, "'", "''")
End If
vDateRes = Me.ResolveDate.SelectedDateString

For x = 0 To 6
If Me.IssueCat.Items(x).Selected = True Then
vIssueCat(x) = 1
Else
vIssueCat(x) = 0
End If
Next
For x = 0 To 8
If Me.ResGroupEffected.Items(x).Selected = True Then
vResGroup(x) = 1
Else
vResGroup(x) = 0
End If
Next
vStatus = Me.Status.SelectedValue
vProject = Me.Project.SelectedValue
vPhase = Me.Phase.SelectedValue

Catch

End Try
End If

'**********************************************************************
'*** UPDATE: If page is being posted back and ID > 0 then save ********
'**********************************************************************
If Page.IsPostBack And vID > 0 Then
'*** SAVE

Try

'*** Create SQL update statement
vSQLString = "update atw_notes set order_no='" & vProject & "', phase='" & vPhase & "', issue_desc='" & vIssue & "'," & _
"[action]='" & vActionReq & "', assigned='" & vResAssn & "', datereq='" & vDateRes & "', cat_budg=" & vIssueCat(0) & ", " & _
"cat_deliv=" & vIssueCat(1) & ", cat_cust=" & vIssueCat(2) & ", cat_vend=" & vIssueCat(3) & ", cat_tech=" & vIssueCat(4) & ", " & _
"cat_resource=" & vIssueCat(5) & ", cat_other=" & vIssueCat(6) & ", rg_ae=" & vResGroup(0) & ", rg_pm=" & vResGroup(1) & ", " & _
"rg_ce=" & vResGroup(2) & ", rg_me=" & vResGroup(3) & ", rg_tr=" & vResGroup(4) & ", rg_ma=" & vResGroup(5) & ", " & _
"rg_ca=" & vResGroup(6) & ", rg_matl=" & vResGroup(7) & ", rg_mgmt=" & vResGroup(8) & ", status='" & vStatus & "' where id=" & vID

'*** Create command and open connection
Dim comm = New SqlCommand(vSQLString, conn)
If (conn.State = ConnectionState.Open) Then
'Do nothing
Else
comm.Connection.Open()
End If

'*** Create DataReader and Execute
Dim sqlAdp As SqlDataAdapter
sqlAdp = comm.ExecuteScalar

'*** Close DataReader
sqlAdp.Dispose()

Catch

End Try

End If

'**********************************************************************
'*** INSERT DATA: If page is being posted back and no ID **************
'**********************************************************************
If Page.IsPostBack And vID = 0 And vProject <> "[Select]" And vProject <> "" And vPhase <> "[Select]" And vPhase <> "" Then
Try
'*** Check existing records to get next item sequence
vSQLString4 = "select max(item)item from atw_notes where order_no='" & vProject & "' and phase='" & vPhase & "'"

'*** Create command and open connection
Dim comm = New SqlCommand(vSQLString4, conn)
If (conn.State = ConnectionState.Open) Then
'Do nothing
Else
comm.Connection.Open()
End If

'*** Create DataReader and Execute
Dim sqlRead4 As SqlDataReader
sqlRead4 = comm.ExecuteReader(CommandBehavior.CloseConnection)

'*** Read through DataReader and get max item
While (sqlRead4.Read())
If sqlRead4.IsDBNull(0) = True Then
vNextItem = 0
Else
vNextItem = sqlRead4.GetInt32(0)
End If
End While

If vNextItem > 0 Then
vNextItem = vNextItem + 1
Else
vNextItem = 1
End If

'*** Close DataReader
sqlRead4.Close()

Catch ex As Exception

End Try

Try

'*** Create SQL insert statement
vSQLString = "insert into atw_notes values ('" & vProject & "','" & vPhase & "',0,0,0,0," & vNextItem & ",1,'" & vIssue & "'," & vIssueCat(0) & "," & vIssueCat(1) & "," & vIssueCat(2) & "," & vIssueCat(3) & "," & vIssueCat(4) & "," & vIssueCat(5) & "," & vIssueCat(6) & ",'" & vActionReq & "','" & Now.ToString & "','" & vResAssn & "','" & vDateRes & "'," & vResGroup(0) & "," & vResGroup(1) & "," & vResGroup(2) & "," & vResGroup(3) & "," & vResGroup(4) & "," & vResGroup(5) & "," & vResGroup(6) & "," & vResGroup(7) & "," & vResGroup(8) & ",'New',0,0)"

'*** Create command and open connection
Dim comm = New SqlCommand(vSQLString, conn)
If (conn.State = ConnectionState.Open) Then
'Do nothing
Else
comm.Connection.Open()
End If

'*** Create DataReader and Execute
Dim sqlRead5 As SqlDataReader
sqlRead5 = comm.ExecuteReader(CommandBehavior.CloseConnection)

'*** Close DataReader
sqlRead5.Close()

Response.Redirect("Default.aspx")

'vID = vNewID
'Me.NotesID.Text = vNewID

Catch ex As Exception

End Try

End If

'*** "S" = SAVE AND EXIT: ALREADY SAVED THE DATA...SO EXIT
If Me.actionflag.Text = "S" Then
Response.Redirect("Default.aspx")
End If

'**********************************************************************
'*** DISPLAY THE DATA *************************************************
'**********************************************************************
If vID > 0 Then

Me.Status.Enabled = True

'*** Display Detail
Try
'*** Create Connection
vSQLString = "SELECT id,Parent,Customer,ProjectDesc,fullorderno,order_no,phase,jobstatus,PhaseDesc,PM,item,item_rev,issue_desc," & _
"cat_budg,cat_deliv,cat_cust,cat_vend,cat_tech,cat_resource,cat_other,[action],[Init],assigned,datereq," & _
"rg_ae,rg_pm,rg_ce,rg_me,rg_tr,rg_ma,rg_ca,rg_matl,rg_mgmt,status,crit_action," & _
"risk_item from vPS_Notes_Grid where id=" & vID

'*** Create command and open connection
Dim comm = New SqlCommand(vSQLString, conn)
If (conn.State = ConnectionState.Open) Then
'Do nothing
Else
comm.Connection.Open()
End If

'*** Create DataReader and Execute
Dim sqlRead As SqlDataReader
sqlRead = comm.ExecuteReader(CommandBehavior.CloseConnection)

'*** Read through DataReader and assign values to each control
While (sqlRead.Read())
vProject = sqlRead.GetString(5)
vPhase = sqlRead.GetString(6)
Me.Project.SelectedValue = sqlRead.GetString(5)
Me.Phase.SelectedValue = sqlRead.GetString(6)
Me.ProjDesc.Text = sqlRead.GetString(3)
Me.Item.Text = sqlRead.GetInt32(10)
Me.IssueDesc.Text = sqlRead.GetString(12)
Me.ActionReq.Text = sqlRead.GetString(20)
Me.Status.SelectedValue = sqlRead.GetString(33).Trim
Me.PM.Text = sqlRead.GetString(9)
Me.Initiated.Text = sqlRead.GetDateTime(21)
Me.ResolveDate.SelectedDateString = sqlRead.GetDateTime(23)
Me.ResourceAssign.Text = sqlRead.GetString(22)

'*** Issue Category Checkbox List
For x = 13 To 19
If sqlRead.GetBoolean(x) = True Then
Me.IssueCat.Items(ctr).Selected = True
End If
ctr = ctr + 1
Next
ctr = 0

'*** Resource Group Checkbox List
For x = 24 To 32
If sqlRead.GetBoolean(x) = True Then
Me.ResGroupEffected.Items(ctr).Selected = True
End If
ctr = ctr + 1
Next

'*** Margins
Me.SoldMargin.Text = 0
Me.EstMargin.Text = 0

End While

'*** Close DataReader
sqlRead.Close()

Catch

End Try

End If

If vProject = "" Then
vProject = Me.Project.Text
End If
If vPhase = "" Then
vPhase = Me.Phase.Text
End If

'*** POPULATE THE PROJECT DROPDOWN...NO MATTER WHAT
Try
vSQLString2 = "select OrderNo,ProjDesc,Customer,PM from vJobHeader_01Full order by OrderNo"

'*** Create command and open connection
Dim comm2 = New SqlCommand(vSQLString2, conn)
If (conn.State = ConnectionState.Open) Then
'Do nothing
Else
comm2.Connection.Open()
End If

'*** Create DataReader and Execute
Dim sqlRead2 As SqlDataReader
sqlRead2 = comm2.ExecuteReader(CommandBehavior.CloseConnection)

Me.Project.Items.Clear()

'*** Read through DataReader and assign values to each control
Me.Project.Items.Add(New ListItem("[Select]", "[Select]"))
While (sqlRead2.Read())
If vProject = sqlRead2.GetString(0) Then
vProjDesc = sqlRead2.GetString(1)
vCustomer = sqlRead2.GetString(2)
vPM = sqlRead2.GetString(3)
End If

Me.Project.Items.Add(New ListItem(sqlRead2.GetString(0), sqlRead2.GetString(0)))
End While

If vProject <> "[Select]" And vProject <> "" Then
Me.Project.SelectedValue = vProject
Me.ProjDesc.Text = vProjDesc
Me.PM.Text = vPM
End If

'*** Close DataReader
sqlRead2.Close()

Catch ex As Exception

End Try

'*** POPULATE THE PHASE DROPDOWN...ONLY IF THERE IS A VALUE IN THE PROJECT DROPDOWN
If (vProject <> "[Select]" And vProject <> "") Or vID > 0 Then

Try
Me.Phase.Enabled = True
vSQLString3 = "select [order-no],substring([order-no],charindex('--',[order-no])+2,100)phase,[item-desc] from JobHeader where ([parent-order]='" & vProject & "' or left([parent-order],6)='" & vProject & "--') and company='01' and [order-no] <> '" & vProject & "' order by [order-no]"

'*** Create command and open connection
Dim comm3 = New SqlCommand(vSQLString3, conn)
If (conn.State = ConnectionState.Open) Then
'Do nothing
Else
comm3.Connection.Open()
End If

'*** Create DataReader and Execute
Dim sqlRead3 As SqlDataReader
sqlRead3 = comm3.ExecuteReader(CommandBehavior.CloseConnection)

Me.Phase.Items.Clear()

'*** Read through DataReader and assign values to each control
Me.Phase.Items.Add(New ListItem("[Select]", "[Select]"))
While (sqlRead3.Read())
If vPhase = sqlRead3.GetString(1) Then
vPhaseDesc = sqlRead3.GetString(2)
End If

Me.Phase.Items.Add(New ListItem(sqlRead3.GetString(1), sqlRead3.GetString(1)))
End While

If vPhase <> "[Select]" And vPhase <> "" Then
Me.Phase.SelectedValue = vPhase
Me.PhaseDesc.Text = vPhaseDesc
End If

'*** Close DataReader
sqlRead3.Close()

Catch ex As Exception

End Try
Else
Me.Phase.Enabled = False
End If

'*** Close Connection
conn.Close()
conn.Dispose()

End If

Me.actionflag.Text = ""
Me.UI_ChangedASP.Text = ""
End Sub

End Class
eo_support
Posted: Wednesday, August 26, 2009 9:14:13 PM
Rank: Administration
Groups: Administration

Joined: 5/27/2007
Posts: 24,194
Hi,

We will need you to isolate the problem into a test page first. Please see here for more details:

http://www.essentialobjects.com/forum/postst3013_I-run-into-a-problem-can-I-send-over-my-code-so-that-you-can-take-a-look.aspx

Thanks!
James
Posted: Wednesday, August 26, 2009 9:27:26 PM
Rank: Member
Groups: Member

Joined: 7/7/2009
Posts: 12
the project is not on an external web site. Not sure how I can send a test page.

I did just uprade to the latest version...and now I get a different error.

Microsoft JScript runtime error: 'this.abp[...]' is null or not an object.

It comes from this section of code in the EO.Web.Grid: if(n!=null)this.abp[n].blx();

If I continue through the error...everything is cool. Will that help at all?
James
Posted: Wednesday, August 26, 2009 11:17:10 PM
Rank: Member
Groups: Member

Joined: 7/7/2009
Posts: 12
I figured it out. I didn't add the 2nd and 3rd context menu to the callback trigger.
Thanks for your help anyway.
eo_support
Posted: Thursday, August 27, 2009 7:11:57 AM
Rank: Administration
Groups: Administration

Joined: 5/27/2007
Posts: 24,194
Great. Thanks for the update!


You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.