S
Steven Reid
Hi All,
I am trying to create a little form where I can enter a SQL query and
return the data in a datagrid. A lot of the times the first time I
open the page and enter a query the datagrid returns data and is fine.
But when I try to resubmit the query or enter another query, the form
just resets and nothing is returned and the form is cleared. I can
use the back button and the sql query statement reappears in the form
but I cant get the form to submit consistantly!
Here is the code to the form
<%@ Page language="c#" Codebehind="RunSQL.aspx.cs"
AutoEventWireup="false" Inherits="Docs.Manager.RunSQL" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>RunSQL</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio 7.0">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name=vs_defaultClientScript content="JavaScript">
<meta name=vs_targetSchema
content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="RunSQL" method="post" runat="server">
<a href="runsql.aspx">RESET</a><br>
<asp:Label ID="lMessage" Runat=server>Before Run
Script</asp:Label><br>
<asp:TextBox id=TextBox1 runat="server" Width="354px"
Height="207px" TextMode="MultiLine"></asp:TextBox><br>
<asp:Button id=Button1 runat="server" Width="353px" Height="28px"
Text="Run"></asp:Button><br>
<asp
ataGrid id=DataGrid1 runat="server" Width="352px"
Height="163px"></aspataGrid><br>
</form>
</body>
</HTML>
Thanks
Steven Reid
I am trying to create a little form where I can enter a SQL query and
return the data in a datagrid. A lot of the times the first time I
open the page and enter a query the datagrid returns data and is fine.
But when I try to resubmit the query or enter another query, the form
just resets and nothing is returned and the form is cleared. I can
use the back button and the sql query statement reappears in the form
but I cant get the form to submit consistantly!
Here is the code to the form
<%@ Page language="c#" Codebehind="RunSQL.aspx.cs"
AutoEventWireup="false" Inherits="Docs.Manager.RunSQL" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>RunSQL</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio 7.0">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name=vs_defaultClientScript content="JavaScript">
<meta name=vs_targetSchema
content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="RunSQL" method="post" runat="server">
<a href="runsql.aspx">RESET</a><br>
<asp:Label ID="lMessage" Runat=server>Before Run
Script</asp:Label><br>
<asp:TextBox id=TextBox1 runat="server" Width="354px"
Height="207px" TextMode="MultiLine"></asp:TextBox><br>
<asp:Button id=Button1 runat="server" Width="353px" Height="28px"
Text="Run"></asp:Button><br>
<asp
ataGrid id=DataGrid1 runat="server" Width="352px"Height="163px"></asp
ataGrid><br></form>
</body>
</HTML>
Thanks
Steven Reid