Hi All,
I've got the following .aspx file with the then following .cs code. The
page renders fine on first run, but once I click the submit, it just comes
back with a cannot be displayed page indicating that the page is not
available. Anyone see what probably obvious or stupid thing I'm missing?
TIA,
John
Test.aspx:
========
<%@dotnet.itags.org. Page Language="C#" src="http://pics.10026.com/?src=Temp.cs" Inherits="dgrdAccountSort" %>
<html>
<head>
</head>
<body>
<form runat="server">
<asp:datagrid id="grdAccount" runat="server" Height="100%"
Width="100%"></asp:datagrid>
<input type="submit" value="Submit Query" runat="server" />
</form>
</body>
</html
Temp.cs code:
==========
using System;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.OleDb;
public class dgrdAccountSort : Page
{
private string SortExpression;
protected DataGrid grdAccount;
protected void Page_Load(object Src, EventArgs e)
{
BindGridReader();
}
public void BindGridReader()
{
string SelectCommand = "SELECT * FROM AcctName";
if (SortExpression != null)
SelectCommand += " ORDER BY " + SortExpression;
OleDbConnection conn = new OleDbConnection(@dotnet.itags.org."Provider=vfpoledb.1;User
Id=;Password=;Data
Source=C:\temp\dotnet1.1\asp\essentials\samples\my testing\IntelligentOffice"
);
OleDbCommand cmd = new OleDbCommand( SelectCommand, conn );
conn.Open();
IDataReader reader = cmd.ExecuteReader();
grdAccount.DataSource = reader;
grdAccount.DataBind();
conn.Dispose();
}
}John,
Instead of Connection.Dispose();
Use Connection.Close(); and then Connection.Dispose() instead.
Connection.Dispose() tells the .Net garbage collector that it's okay to
dispose of an object when it gets around to it. It does not close the
connection.
Sincerely,
--
S. Justin Gengo, MCP
Web Developer
Free code library at:
www.aboutfortunate.com
"Out of chaos comes order."
Nietzche
"John Spiegel" <jspiegel@.c-comld.com> wrote in message
news:uoAcTxzaDHA.652@.tk2msftngp13.phx.gbl...
> Hi All,
> I've got the following .aspx file with the then following .cs code. The
> page renders fine on first run, but once I click the submit, it just comes
> back with a cannot be displayed page indicating that the page is not
> available. Anyone see what probably obvious or stupid thing I'm missing?
> TIA,
> John
> Test.aspx:
> ========
> <%@. Page Language="C#" src="http://pics.10026.com/?src=Temp.cs" Inherits="dgrdAccountSort" %>
> <html>
> <head>
> </head>
> <body>
> <form runat="server">
> <asp:datagrid id="grdAccount" runat="server" Height="100%"
> Width="100%"></asp:datagrid>
> <input type="submit" value="Submit Query" runat="server" />
> </form>
> </body>
> </html>
>
> Temp.cs code:
> ==========
> using System;
> using System.Web;
> using System.Web.UI;
> using System.Web.UI.WebControls;
> using System.Data;
> using System.Data.OleDb;
> public class dgrdAccountSort : Page
> {
> private string SortExpression;
> protected DataGrid grdAccount;
> protected void Page_Load(object Src, EventArgs e)
> {
> BindGridReader();
> }
>
> public void BindGridReader()
> {
> string SelectCommand = "SELECT * FROM AcctName";
> if (SortExpression != null)
> SelectCommand += " ORDER BY " + SortExpression;
> OleDbConnection conn = new OleDbConnection(@."Provider=vfpoledb.1;User
> Id=;Password=;Data
Source=C:\temp\dotnet1.1\asp\essentials\samples\my testing\IntelligentOffice"
> );
> OleDbCommand cmd = new OleDbCommand( SelectCommand, conn );
> conn.Open();
> IDataReader reader = cmd.ExecuteReader();
> grdAccount.DataSource = reader;
> grdAccount.DataBind();
> conn.Dispose();
> }
> }
Just a thought - have you tried closing the connection by setting the
commandbehavior of your command to do so after the Datareader is closed. And
then close the datareader after binding?
"John Spiegel" <jspiegel@.c-comld.com> wrote in message
news:uoAcTxzaDHA.652@.tk2msftngp13.phx.gbl...
> Hi All,
> I've got the following .aspx file with the then following .cs code. The
> page renders fine on first run, but once I click the submit, it just comes
> back with a cannot be displayed page indicating that the page is not
> available. Anyone see what probably obvious or stupid thing I'm missing?
> TIA,
> John
> Test.aspx:
> ========
> <%@. Page Language="C#" src="http://pics.10026.com/?src=Temp.cs" Inherits="dgrdAccountSort" %>
> <html>
> <head>
> </head>
> <body>
> <form runat="server">
> <asp:datagrid id="grdAccount" runat="server" Height="100%"
> Width="100%"></asp:datagrid>
> <input type="submit" value="Submit Query" runat="server" />
> </form>
> </body>
> </html>
>
> Temp.cs code:
> ==========
> using System;
> using System.Web;
> using System.Web.UI;
> using System.Web.UI.WebControls;
> using System.Data;
> using System.Data.OleDb;
> public class dgrdAccountSort : Page
> {
> private string SortExpression;
> protected DataGrid grdAccount;
> protected void Page_Load(object Src, EventArgs e)
> {
> BindGridReader();
> }
>
> public void BindGridReader()
> {
> string SelectCommand = "SELECT * FROM AcctName";
> if (SortExpression != null)
> SelectCommand += " ORDER BY " + SortExpression;
> OleDbConnection conn = new OleDbConnection(@."Provider=vfpoledb.1;User
> Id=;Password=;Data
Source=C:\temp\dotnet1.1\asp\essentials\samples\my testing\IntelligentOffice"
> );
> OleDbCommand cmd = new OleDbCommand( SelectCommand, conn );
> conn.Open();
> IDataReader reader = cmd.ExecuteReader();
> grdAccount.DataSource = reader;
> grdAccount.DataBind();
> conn.Dispose();
> }
> }
Just a thought - have you tried closing the connection by setting the
commandbehavior of your command to do so after the Datareader is closed. And
then close the datareader after binding?
"John Spiegel" <jspiegel@.c-comld.com> wrote in message
news:uoAcTxzaDHA.652@.tk2msftngp13.phx.gbl...
> Hi All,
> I've got the following .aspx file with the then following .cs code. The
> page renders fine on first run, but once I click the submit, it just comes
> back with a cannot be displayed page indicating that the page is not
> available. Anyone see what probably obvious or stupid thing I'm missing?
> TIA,
> John
> Test.aspx:
> ========
> <%@. Page Language="C#" src="http://pics.10026.com/?src=Temp.cs" Inherits="dgrdAccountSort" %>
> <html>
> <head>
> </head>
> <body>
> <form runat="server">
> <asp:datagrid id="grdAccount" runat="server" Height="100%"
> Width="100%"></asp:datagrid>
> <input type="submit" value="Submit Query" runat="server" />
> </form>
> </body>
> </html>
>
> Temp.cs code:
> ==========
> using System;
> using System.Web;
> using System.Web.UI;
> using System.Web.UI.WebControls;
> using System.Data;
> using System.Data.OleDb;
> public class dgrdAccountSort : Page
> {
> private string SortExpression;
> protected DataGrid grdAccount;
> protected void Page_Load(object Src, EventArgs e)
> {
> BindGridReader();
> }
>
> public void BindGridReader()
> {
> string SelectCommand = "SELECT * FROM AcctName";
> if (SortExpression != null)
> SelectCommand += " ORDER BY " + SortExpression;
> OleDbConnection conn = new OleDbConnection(@."Provider=vfpoledb.1;User
> Id=;Password=;Data
Source=C:\temp\dotnet1.1\asp\essentials\samples\my testing\IntelligentOffice"
> );
> OleDbCommand cmd = new OleDbCommand( SelectCommand, conn );
> conn.Open();
> IDataReader reader = cmd.ExecuteReader();
> grdAccount.DataSource = reader;
> grdAccount.DataBind();
> conn.Dispose();
> }
> }
John,
Sorry, but that was the only thing I could see that might have been wrong
with your code...
That said, I mostly program in VB.Net so maybe someone with more C#
experience could spot something else to try.
Good luck with it!
Sincerely,
--
S. Justin Gengo, MCP
Web Developer
Free code library at:
www.aboutfortunate.com
"Out of chaos comes order."
Nietzche
"John Spiegel" <jspiegel@.c-comld.com> wrote in message
news:e1doDH0aDHA.1280@.tk2msftngp13.phx.gbl...
> Thanks for getting involved! Unfortunately, I inserted a conn.Close()
> before the conn.Dispose() and it appears to do the same thing (work first
> time then die the second).
> FWIW, I'm using WebMatrix, the 1.1 version of .NET framework on a Win2K
pro
> machine.
> - John
> "S. Justin Gengo" <sjgengo@.aboutfortunate.com> wrote in message
> news:#wLKf6zaDHA.388@.TK2MSFTNGP10.phx.gbl...
> > John,
> > Instead of Connection.Dispose();
> > Use Connection.Close(); and then Connection.Dispose() instead.
> > Connection.Dispose() tells the .Net garbage collector that it's okay to
> > dispose of an object when it gets around to it. It does not close the
> > connection.
> > Sincerely,
> > --
> > S. Justin Gengo, MCP
> > Web Developer
> > Free code library at:
> > www.aboutfortunate.com
> > "Out of chaos comes order."
> > Nietzche
> > "John Spiegel" <jspiegel@.c-comld.com> wrote in message
> > news:uoAcTxzaDHA.652@.tk2msftngp13.phx.gbl...
> > > Hi All,
> > > > I've got the following .aspx file with the then following .cs code.
The
> > > page renders fine on first run, but once I click the submit, it just
> comes
> > > back with a cannot be displayed page indicating that the page is not
> > > available. Anyone see what probably obvious or stupid thing I'm
> missing?
> > > > TIA,
> > > > John
> > > > Test.aspx:
> > > ========
> > > > <%@. Page Language="C#" src="http://pics.10026.com/?src=Temp.cs" Inherits="dgrdAccountSort" %>
> > > <html>
> > > <head>
> > > </head>
> > > <body>
> > > <form runat="server">
> > > <asp:datagrid id="grdAccount" runat="server" Height="100%"
> > > Width="100%"></asp:datagrid>
> > > <input type="submit" value="Submit Query" runat="server" />
> > > </form>
> > > </body>
> > > </html>
> > > > > Temp.cs code:
> > > ==========
> > > using System;
> > > using System.Web;
> > > using System.Web.UI;
> > > using System.Web.UI.WebControls;
> > > using System.Data;
> > > using System.Data.OleDb;
> > > > public class dgrdAccountSort : Page
> > > {
> > > private string SortExpression;
> > > protected DataGrid grdAccount;
> > > > protected void Page_Load(object Src, EventArgs e)
> > > {
> > > BindGridReader();
> > > }
> > > > > public void BindGridReader()
> > > {
> > > string SelectCommand = "SELECT * FROM AcctName";
> > > if (SortExpression != null)
> > > SelectCommand += " ORDER BY " + SortExpression;
> > > > OleDbConnection conn = new
OleDbConnection(@."Provider=vfpoledb.1;User
> > > Id=;Password=;Data
> Source=C:\temp\dotnet1.1\asp\essentials\samples\my testing\IntelligentOffice"
> > > );
> > > OleDbCommand cmd = new OleDbCommand( SelectCommand, conn );
> > > > conn.Open();
> > > IDataReader reader = cmd.ExecuteReader();
> > > grdAccount.DataSource = reader;
> > > grdAccount.DataBind();
> > > > conn.Dispose();
> > > }
> > > }
> >
John,
Sorry, but that was the only thing I could see that might have been wrong
with your code...
That said, I mostly program in VB.Net so maybe someone with more C#
experience could spot something else to try.
Good luck with it!
Sincerely,
--
S. Justin Gengo, MCP
Web Developer
Free code library at:
www.aboutfortunate.com
"Out of chaos comes order."
Nietzche
"John Spiegel" <jspiegel@.c-comld.com> wrote in message
news:e1doDH0aDHA.1280@.tk2msftngp13.phx.gbl...
> Thanks for getting involved! Unfortunately, I inserted a conn.Close()
> before the conn.Dispose() and it appears to do the same thing (work first
> time then die the second).
> FWIW, I'm using WebMatrix, the 1.1 version of .NET framework on a Win2K
pro
> machine.
> - John
> "S. Justin Gengo" <sjgengo@.aboutfortunate.com> wrote in message
> news:#wLKf6zaDHA.388@.TK2MSFTNGP10.phx.gbl...
> > John,
> > Instead of Connection.Dispose();
> > Use Connection.Close(); and then Connection.Dispose() instead.
> > Connection.Dispose() tells the .Net garbage collector that it's okay to
> > dispose of an object when it gets around to it. It does not close the
> > connection.
> > Sincerely,
> > --
> > S. Justin Gengo, MCP
> > Web Developer
> > Free code library at:
> > www.aboutfortunate.com
> > "Out of chaos comes order."
> > Nietzche
> > "John Spiegel" <jspiegel@.c-comld.com> wrote in message
> > news:uoAcTxzaDHA.652@.tk2msftngp13.phx.gbl...
> > > Hi All,
> > > > I've got the following .aspx file with the then following .cs code.
The
> > > page renders fine on first run, but once I click the submit, it just
> comes
> > > back with a cannot be displayed page indicating that the page is not
> > > available. Anyone see what probably obvious or stupid thing I'm
> missing?
> > > > TIA,
> > > > John
> > > > Test.aspx:
> > > ========
> > > > <%@. Page Language="C#" src="http://pics.10026.com/?src=Temp.cs" Inherits="dgrdAccountSort" %>
> > > <html>
> > > <head>
> > > </head>
> > > <body>
> > > <form runat="server">
> > > <asp:datagrid id="grdAccount" runat="server" Height="100%"
> > > Width="100%"></asp:datagrid>
> > > <input type="submit" value="Submit Query" runat="server" />
> > > </form>
> > > </body>
> > > </html>
> > > > > Temp.cs code:
> > > ==========
> > > using System;
> > > using System.Web;
> > > using System.Web.UI;
> > > using System.Web.UI.WebControls;
> > > using System.Data;
> > > using System.Data.OleDb;
> > > > public class dgrdAccountSort : Page
> > > {
> > > private string SortExpression;
> > > protected DataGrid grdAccount;
> > > > protected void Page_Load(object Src, EventArgs e)
> > > {
> > > BindGridReader();
> > > }
> > > > > public void BindGridReader()
> > > {
> > > string SelectCommand = "SELECT * FROM AcctName";
> > > if (SortExpression != null)
> > > SelectCommand += " ORDER BY " + SortExpression;
> > > > OleDbConnection conn = new
OleDbConnection(@."Provider=vfpoledb.1;User
> > > Id=;Password=;Data
> Source=C:\temp\dotnet1.1\asp\essentials\samples\my testing\IntelligentOffice"
> > > );
> > > OleDbCommand cmd = new OleDbCommand( SelectCommand, conn );
> > > > conn.Open();
> > > IDataReader reader = cmd.ExecuteReader();
> > > grdAccount.DataSource = reader;
> > > grdAccount.DataBind();
> > > > conn.Dispose();
> > > }
> > > }
> >
Not yet, I'll give it a shot! I did find some very similar code code that
is working so I can use it to find my mistake. Thanks for the advice, Rick!
- John
"Rick Spiewak" <rickspiewak@.mindspring.com> wrote in message
news:#uNhx04aDHA.2436@.TK2MSFTNGP12.phx.gbl...
> Just a thought - have you tried closing the connection by setting the
> commandbehavior of your command to do so after the Datareader is closed.
And
> then close the datareader after binding?
> "John Spiegel" <jspiegel@.c-comld.com> wrote in message
> news:uoAcTxzaDHA.652@.tk2msftngp13.phx.gbl...
> > Hi All,
> > I've got the following .aspx file with the then following .cs code. The
> > page renders fine on first run, but once I click the submit, it just
comes
> > back with a cannot be displayed page indicating that the page is not
> > available. Anyone see what probably obvious or stupid thing I'm
missing?
> > TIA,
> > John
> > Test.aspx:
> > ========
> > <%@. Page Language="C#" src="http://pics.10026.com/?src=Temp.cs" Inherits="dgrdAccountSort" %>
> > <html>
> > <head>
> > </head>
> > <body>
> > <form runat="server">
> > <asp:datagrid id="grdAccount" runat="server" Height="100%"
> > Width="100%"></asp:datagrid>
> > <input type="submit" value="Submit Query" runat="server" />
> > </form>
> > </body>
> > </html>
> > Temp.cs code:
> > ==========
> > using System;
> > using System.Web;
> > using System.Web.UI;
> > using System.Web.UI.WebControls;
> > using System.Data;
> > using System.Data.OleDb;
> > public class dgrdAccountSort : Page
> > {
> > private string SortExpression;
> > protected DataGrid grdAccount;
> > protected void Page_Load(object Src, EventArgs e)
> > {
> > BindGridReader();
> > }
> > public void BindGridReader()
> > {
> > string SelectCommand = "SELECT * FROM AcctName";
> > if (SortExpression != null)
> > SelectCommand += " ORDER BY " + SortExpression;
> > OleDbConnection conn = new OleDbConnection(@."Provider=vfpoledb.1;User
> > Id=;Password=;Data
Source=C:\temp\dotnet1.1\asp\essentials\samples\my testing\IntelligentOffice"
> > );
> > OleDbCommand cmd = new OleDbCommand( SelectCommand, conn );
> > conn.Open();
> > IDataReader reader = cmd.ExecuteReader();
> > grdAccount.DataSource = reader;
> > grdAccount.DataBind();
> > conn.Dispose();
> > }
> > }
Not yet, I'll give it a shot! I did find some very similar code code that
is working so I can use it to find my mistake. Thanks for the advice, Rick!
- John
"Rick Spiewak" <rickspiewak@.mindspring.com> wrote in message
news:#uNhx04aDHA.2436@.TK2MSFTNGP12.phx.gbl...
> Just a thought - have you tried closing the connection by setting the
> commandbehavior of your command to do so after the Datareader is closed.
And
> then close the datareader after binding?
> "John Spiegel" <jspiegel@.c-comld.com> wrote in message
> news:uoAcTxzaDHA.652@.tk2msftngp13.phx.gbl...
> > Hi All,
> > I've got the following .aspx file with the then following .cs code. The
> > page renders fine on first run, but once I click the submit, it just
comes
> > back with a cannot be displayed page indicating that the page is not
> > available. Anyone see what probably obvious or stupid thing I'm
missing?
> > TIA,
> > John
> > Test.aspx:
> > ========
> > <%@. Page Language="C#" src="http://pics.10026.com/?src=Temp.cs" Inherits="dgrdAccountSort" %>
> > <html>
> > <head>
> > </head>
> > <body>
> > <form runat="server">
> > <asp:datagrid id="grdAccount" runat="server" Height="100%"
> > Width="100%"></asp:datagrid>
> > <input type="submit" value="Submit Query" runat="server" />
> > </form>
> > </body>
> > </html>
> > Temp.cs code:
> > ==========
> > using System;
> > using System.Web;
> > using System.Web.UI;
> > using System.Web.UI.WebControls;
> > using System.Data;
> > using System.Data.OleDb;
> > public class dgrdAccountSort : Page
> > {
> > private string SortExpression;
> > protected DataGrid grdAccount;
> > protected void Page_Load(object Src, EventArgs e)
> > {
> > BindGridReader();
> > }
> > public void BindGridReader()
> > {
> > string SelectCommand = "SELECT * FROM AcctName";
> > if (SortExpression != null)
> > SelectCommand += " ORDER BY " + SortExpression;
> > OleDbConnection conn = new OleDbConnection(@."Provider=vfpoledb.1;User
> > Id=;Password=;Data
Source=C:\temp\dotnet1.1\asp\essentials\samples\my testing\IntelligentOffice"
> > );
> > OleDbCommand cmd = new OleDbCommand( SelectCommand, conn );
> > conn.Open();
> > IDataReader reader = cmd.ExecuteReader();
> > grdAccount.DataSource = reader;
> > grdAccount.DataBind();
> > conn.Dispose();
> > }
> > }
I appreciate the time looking into it! It's been a long time since I've
picked up a new language so now I'm trying to basically do two at once!
Yea! <g
"S. Justin Gengo" <sjgengo@.aboutfortunate.com> wrote in message
news:#Xz3CQ6aDHA.2672@.tk2msftngp13.phx.gbl...
> John,
> Sorry, but that was the only thing I could see that might have been wrong
> with your code...
> That said, I mostly program in VB.Net so maybe someone with more C#
> experience could spot something else to try.
> Good luck with it!
> Sincerely,
> --
> S. Justin Gengo, MCP
> Web Developer
> Free code library at:
> www.aboutfortunate.com
> "Out of chaos comes order."
> Nietzche
>
> "John Spiegel" <jspiegel@.c-comld.com> wrote in message
> news:e1doDH0aDHA.1280@.tk2msftngp13.phx.gbl...
> > Thanks for getting involved! Unfortunately, I inserted a conn.Close()
> > before the conn.Dispose() and it appears to do the same thing (work
first
> > time then die the second).
> > FWIW, I'm using WebMatrix, the 1.1 version of .NET framework on a Win2K
> pro
> > machine.
> > - John
> > "S. Justin Gengo" <sjgengo@.aboutfortunate.com> wrote in message
> > news:#wLKf6zaDHA.388@.TK2MSFTNGP10.phx.gbl...
> > > John,
> > > > Instead of Connection.Dispose();
> > > > Use Connection.Close(); and then Connection.Dispose() instead.
> > > > Connection.Dispose() tells the .Net garbage collector that it's okay
to
> > > dispose of an object when it gets around to it. It does not close the
> > > connection.
> > > > Sincerely,
> > > > --
> > > S. Justin Gengo, MCP
> > > Web Developer
> > > > Free code library at:
> > > www.aboutfortunate.com
> > > > "Out of chaos comes order."
> > > Nietzche
> > > > > "John Spiegel" <jspiegel@.c-comld.com> wrote in message
> > > news:uoAcTxzaDHA.652@.tk2msftngp13.phx.gbl...
> > > > Hi All,
> > > > > > I've got the following .aspx file with the then following .cs code.
> The
> > > > page renders fine on first run, but once I click the submit, it just
> > comes
> > > > back with a cannot be displayed page indicating that the page is not
> > > > available. Anyone see what probably obvious or stupid thing I'm
> > missing?
> > > > > > TIA,
> > > > > > John
> > > > > > Test.aspx:
> > > > ========
> > > > > > <%@. Page Language="C#" src="http://pics.10026.com/?src=Temp.cs" Inherits="dgrdAccountSort" %>
> > > > <html>
> > > > <head>
> > > > </head>
> > > > <body>
> > > > <form runat="server">
> > > > <asp:datagrid id="grdAccount" runat="server" Height="100%"
> > > > Width="100%"></asp:datagrid>
> > > > <input type="submit" value="Submit Query" runat="server" />
> > > > </form>
> > > > </body>
> > > > </html>
> > > > > > > > Temp.cs code:
> > > > ==========
> > > > using System;
> > > > using System.Web;
> > > > using System.Web.UI;
> > > > using System.Web.UI.WebControls;
> > > > using System.Data;
> > > > using System.Data.OleDb;
> > > > > > public class dgrdAccountSort : Page
> > > > {
> > > > private string SortExpression;
> > > > protected DataGrid grdAccount;
> > > > > > protected void Page_Load(object Src, EventArgs e)
> > > > {
> > > > BindGridReader();
> > > > }
> > > > > > > > public void BindGridReader()
> > > > {
> > > > string SelectCommand = "SELECT * FROM AcctName";
> > > > if (SortExpression != null)
> > > > SelectCommand += " ORDER BY " + SortExpression;
> > > > > > OleDbConnection conn = new
> OleDbConnection(@."Provider=vfpoledb.1;User
> > > > Id=;Password=;Data
> > > Source=C:\temp\dotnet1.1\asp\essentials\samples\my testing\IntelligentOffice"
> > > > );
> > > > OleDbCommand cmd = new OleDbCommand( SelectCommand, conn );
> > > > > > conn.Open();
> > > > IDataReader reader = cmd.ExecuteReader();
> > > > grdAccount.DataSource = reader;
> > > > grdAccount.DataBind();
> > > > > > conn.Dispose();
> > > > }
> > > > }
> > > > > >
FYI, As it turns out, the error seems to be tied to my not limiting the
amount of the table it displayed on the page. Once I narrowed it down to 20
rows at a time, the error went away. I'm not clear as to whether that's a
configurable limitation or not.
- John
"John Spiegel" <jspiegel@.c-comld.com> wrote in message
news:uoAcTxzaDHA.652@.tk2msftngp13.phx.gbl...
> Hi All,
> I've got the following .aspx file with the then following .cs code. The
> page renders fine on first run, but once I click the submit, it just comes
> back with a cannot be displayed page indicating that the page is not
> available. Anyone see what probably obvious or stupid thing I'm missing?
> TIA,
> John
> Test.aspx:
> ========
> <%@. Page Language="C#" src="http://pics.10026.com/?src=Temp.cs" Inherits="dgrdAccountSort" %>
> <html>
> <head>
> </head>
> <body>
> <form runat="server">
> <asp:datagrid id="grdAccount" runat="server" Height="100%"
> Width="100%"></asp:datagrid>
> <input type="submit" value="Submit Query" runat="server" />
> </form>
> </body>
> </html>
>
> Temp.cs code:
> ==========
> using System;
> using System.Web;
> using System.Web.UI;
> using System.Web.UI.WebControls;
> using System.Data;
> using System.Data.OleDb;
> public class dgrdAccountSort : Page
> {
> private string SortExpression;
> protected DataGrid grdAccount;
> protected void Page_Load(object Src, EventArgs e)
> {
> BindGridReader();
> }
>
> public void BindGridReader()
> {
> string SelectCommand = "SELECT * FROM AcctName";
> if (SortExpression != null)
> SelectCommand += " ORDER BY " + SortExpression;
> OleDbConnection conn = new OleDbConnection(@."Provider=vfpoledb.1;User
> Id=;Password=;Data
Source=C:\temp\dotnet1.1\asp\essentials\samples\my testing\IntelligentOffice"
> );
> OleDbCommand cmd = new OleDbCommand( SelectCommand, conn );
> conn.Open();
> IDataReader reader = cmd.ExecuteReader();
> grdAccount.DataSource = reader;
> grdAccount.DataBind();
> conn.Dispose();
> }
> }
