C
CBKowitz
Trying a simple (Ha Ha) gridview and SQLDatasource combination. When I run
the page nothing shows. Here's the code:
<%@ Page Language="vb" AutoEventWireup="false"
Inherits="TestSystemSecurity.SecurityFormList" enableViewState="True"
CodeFile="SecurityFormList.aspx.vb" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<title>Security Form List</title>
<%
writeLoadSteps()
%>
<script src="numjs.js"></script>
<script language="javascript">
window.name = "SecFormList"
function submitIt()
{
document.frmSecurityFormList.recAdded.value = 1;
document.frmSecurityFormList.submit();
}
</script>
</HEAD>
<body onload="loadSteps()">
<div align="center">
<form id="frmSecurityFormList" method="post" runat="server">
<INPUT value="0" type="hidden" name="recAdded">
<asp:label id="lblTitle" runat="server" Height="24px" SkinID=DB_14B
Width="761px">
View / Update Security Form List
</asp:label>
<br>
<br>
<asp:GridView ID="gvSecurityList" runat="server" Width="1005px"
SkinID="RainyDay8" PageSize="15" AutoGenerateColumns=False CellPadding="3"
AutoGenerateDeleteButton="True" AutoGenerateEditButton="True"
DataSourceID="sqlDSFormList" AllowPaging="True">
<Columns>
<asp:BoundField DataField="ID" SortExpression="ID"
ReadOnly="True" HeaderText="ID">
<HeaderStyle Width="30px"></HeaderStyle>
</asp:BoundField>
<asp:BoundField DataField="FORM NAME" SortExpression="FORM NAME"
HeaderText="Form Name">
<HeaderStyle Width="250px"></HeaderStyle>
</asp:BoundField>
<asp:BoundField DataField="CONTROL NAME" SortExpression="CONTROL
NAME" HeaderText="Control Name">
<HeaderStyle Width="150px"></HeaderStyle>
</asp:BoundField>
<asp:BoundField DataField="DESCRIPTION"
SortExpression="DESCRIPTION" HeaderText="Description">
<HeaderStyle Width="300px"></HeaderStyle>
</asp:BoundField>
<asp:BoundField DataField="ROLES" SortExpression="ROLES"
HeaderText="Security Roles">
<HeaderStyle Width="150px"></HeaderStyle>
</asp:BoundField>
</Columns>
</asp:GridView>
<br>
<asp:SqlDataSource ID="sqlDSFormList" runat="server"
ConnectionString="Connection String Not Shown"
DeleteCommand="spDeleteSecurityFormListTable"
DeleteCommandType="StoredProcedure"
InsertCommand="spInsertSecurityFormListTable"
InsertCommandType="StoredProcedure"
ProviderName="System.Data.SqlClient"
SelectCommand="spSelectSecurityFormListTable"
SelectCommandType="StoredProcedure"
UpdateCommand="spUpdateSecurityFormListTable"
UpdateCommandType="StoredProcedure">
<DeleteParameters>
<asp
arameter Name="IdxId" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asparameter Name="FormName" Type="String" />
<asparameter Name="ControlName" Type="String" />
<asparameter Name="Description" Type="String" />
<asparameter Name="Roles" Type="String" />
<asparameter Name="IdxId" Type="Int32" />
</UpdateParameters>
<SelectParameters>
<asp:SessionParameter DefaultValue="-1" Name="IdxId"
SessionField="IdxID" Type="Int32" />
<asp:SessionParameter DefaultValue="" Name="Role"
SessionField="ViewRole" Type="String" />
</SelectParameters>
<InsertParameters>
<asparameter Name="FormName" Type="String" />
<asparameter Name="ControlName" Type="String" />
<asparameter Name="Description" Type="String" />
<asparameter Name="Roles" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
<br>
<asp:ImageButton id="btnExit" runat="server"
ImageUrl="images/exit.gif"></asp:ImageButton>
<asp:ImageButton id="btnAdd" runat="server"
ImageUrl="images/add.gif"></asp:ImageButton>
</form>
</div>
</body>
</HTML>
the page nothing shows. Here's the code:
<%@ Page Language="vb" AutoEventWireup="false"
Inherits="TestSystemSecurity.SecurityFormList" enableViewState="True"
CodeFile="SecurityFormList.aspx.vb" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<title>Security Form List</title>
<%
writeLoadSteps()
%>
<script src="numjs.js"></script>
<script language="javascript">
window.name = "SecFormList"
function submitIt()
{
document.frmSecurityFormList.recAdded.value = 1;
document.frmSecurityFormList.submit();
}
</script>
</HEAD>
<body onload="loadSteps()">
<div align="center">
<form id="frmSecurityFormList" method="post" runat="server">
<INPUT value="0" type="hidden" name="recAdded">
<asp:label id="lblTitle" runat="server" Height="24px" SkinID=DB_14B
Width="761px">
View / Update Security Form List
</asp:label>
<br>
<br>
<asp:GridView ID="gvSecurityList" runat="server" Width="1005px"
SkinID="RainyDay8" PageSize="15" AutoGenerateColumns=False CellPadding="3"
AutoGenerateDeleteButton="True" AutoGenerateEditButton="True"
DataSourceID="sqlDSFormList" AllowPaging="True">
<Columns>
<asp:BoundField DataField="ID" SortExpression="ID"
ReadOnly="True" HeaderText="ID">
<HeaderStyle Width="30px"></HeaderStyle>
</asp:BoundField>
<asp:BoundField DataField="FORM NAME" SortExpression="FORM NAME"
HeaderText="Form Name">
<HeaderStyle Width="250px"></HeaderStyle>
</asp:BoundField>
<asp:BoundField DataField="CONTROL NAME" SortExpression="CONTROL
NAME" HeaderText="Control Name">
<HeaderStyle Width="150px"></HeaderStyle>
</asp:BoundField>
<asp:BoundField DataField="DESCRIPTION"
SortExpression="DESCRIPTION" HeaderText="Description">
<HeaderStyle Width="300px"></HeaderStyle>
</asp:BoundField>
<asp:BoundField DataField="ROLES" SortExpression="ROLES"
HeaderText="Security Roles">
<HeaderStyle Width="150px"></HeaderStyle>
</asp:BoundField>
</Columns>
</asp:GridView>
<br>
<asp:SqlDataSource ID="sqlDSFormList" runat="server"
ConnectionString="Connection String Not Shown"
DeleteCommand="spDeleteSecurityFormListTable"
DeleteCommandType="StoredProcedure"
InsertCommand="spInsertSecurityFormListTable"
InsertCommandType="StoredProcedure"
ProviderName="System.Data.SqlClient"
SelectCommand="spSelectSecurityFormListTable"
SelectCommandType="StoredProcedure"
UpdateCommand="spUpdateSecurityFormListTable"
UpdateCommandType="StoredProcedure">
<DeleteParameters>
<asp
arameter Name="IdxId" Type="Int32" /></DeleteParameters>
<UpdateParameters>
<asp
arameter Name="FormName" Type="String" /><asp
arameter Name="ControlName" Type="String" /><asp
arameter Name="Description" Type="String" /><asp
arameter Name="Roles" Type="String" /><asp
arameter Name="IdxId" Type="Int32" /></UpdateParameters>
<SelectParameters>
<asp:SessionParameter DefaultValue="-1" Name="IdxId"
SessionField="IdxID" Type="Int32" />
<asp:SessionParameter DefaultValue="" Name="Role"
SessionField="ViewRole" Type="String" />
</SelectParameters>
<InsertParameters>
<asp
arameter Name="FormName" Type="String" /><asp
arameter Name="ControlName" Type="String" /><asp
arameter Name="Description" Type="String" /><asp
arameter Name="Roles" Type="String" /></InsertParameters>
</asp:SqlDataSource>
<br>
<asp:ImageButton id="btnExit" runat="server"
ImageUrl="images/exit.gif"></asp:ImageButton>
<asp:ImageButton id="btnAdd" runat="server"
ImageUrl="images/add.gif"></asp:ImageButton>
</form>
</div>
</body>
</HTML>