sharonchapman7
Programmer
Hi,
I have an asp html page that allows the user to input data into a web page. When they click the submit button it calls a default.aspx.vb. The ISPostback is always false so it skips my sql add parameters. Here is the code:
<pre lang="xml"><%@ Page Language="VB" AutoEventWireup="false" CodeFile="default.aspx.vb" Inherits="_default"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "<html xmlns="<head id="Head1" runat="server">
<title>GDR Request Form</title>
<script src="Scripts/jquery-1.8.2.js" type="text/javascript"></script>
<script src="Scripts/jQuery.maskedinput.js" type="text/javascript"></script>
<link href="Styles/style2.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form id="form1" runat="server">
<div id="content" style="text-align:center" >
<table class="ftitle2" >
<tr>
<td style="text-align:left" width="295px">
Organization name (if different from the Sponsor):</td>
<td>
<asp:TextBox ID="txtOrganization" runat="server" Width="466px"></asp:TextBox>
</td>
<td width="25px">
Date:</td>
<td>
<asp:TextBox ID="txtRequester_Date" runat="server" width="70px"
ToolTip="Please Enter The Request Date. (MM/DD/YYYY)"></asp:TextBox>
</td>
</tr>
</table>
</table>
<asp:Button ID="Button1" runat="server" Text="Submit" />
<br />
</div></pre>
***************************************************************************
default.aspx.vb
***************************************************************************
Imports System.Data.SqlClient
Imports System.Data
Partial Class _Default
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) _
Handles Me.Load
txtRequester_Date.Text = Date.Today
txtRequestDate.Text = Date.Today
If (IsPostBack) Then
' this creates the connection.
Dim sqlConn As New SqlConnection("Data Source=JITC-PC\GEOINT; Initial catalog=DEV_GEOINT; Integrated Security=SSPI;")
' create the command object
Dim sqlCmd As New SqlCommand("sp_InsertRequest", sqlConn)
' define the connection for the command object
sqlCmd.Connection = sqlConn
sqlCmd.CommandType = CommandType.StoredProcedure
' define the SQL parameter
sqlCmd.Parameters.AddWithValue("@Org", txtOrganization.Text)
sqlCmd.Parameters.AddWithValue("@REQ_Date", txtRequester_Date.Text)
' open the connection
sqlConn.Open()
' execute the data insertion
sqlCmd.ExecuteNonQuery()
' close SQL connection
sqlConn.Close()
' dispose of the connection object (mostly optional but good practice)
sqlConn.Dispose()
' Notify the submission was accepted
Response.Write("Thank-you for your Request!")
End If
End Sub
Private Function isempty(ByVal p1 As Object) As String
Throw New NotImplementedException
End Function
End Class
I have an asp html page that allows the user to input data into a web page. When they click the submit button it calls a default.aspx.vb. The ISPostback is always false so it skips my sql add parameters. Here is the code:
<pre lang="xml"><%@ Page Language="VB" AutoEventWireup="false" CodeFile="default.aspx.vb" Inherits="_default"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "<html xmlns="<head id="Head1" runat="server">
<title>GDR Request Form</title>
<script src="Scripts/jquery-1.8.2.js" type="text/javascript"></script>
<script src="Scripts/jQuery.maskedinput.js" type="text/javascript"></script>
<link href="Styles/style2.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form id="form1" runat="server">
<div id="content" style="text-align:center" >
<table class="ftitle2" >
<tr>
<td style="text-align:left" width="295px">
Organization name (if different from the Sponsor):</td>
<td>
<asp:TextBox ID="txtOrganization" runat="server" Width="466px"></asp:TextBox>
</td>
<td width="25px">
Date:</td>
<td>
<asp:TextBox ID="txtRequester_Date" runat="server" width="70px"
ToolTip="Please Enter The Request Date. (MM/DD/YYYY)"></asp:TextBox>
</td>
</tr>
</table>
</table>
<asp:Button ID="Button1" runat="server" Text="Submit" />
<br />
</div></pre>
***************************************************************************
default.aspx.vb
***************************************************************************
Imports System.Data.SqlClient
Imports System.Data
Partial Class _Default
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) _
Handles Me.Load
txtRequester_Date.Text = Date.Today
txtRequestDate.Text = Date.Today
If (IsPostBack) Then
' this creates the connection.
Dim sqlConn As New SqlConnection("Data Source=JITC-PC\GEOINT; Initial catalog=DEV_GEOINT; Integrated Security=SSPI;")
' create the command object
Dim sqlCmd As New SqlCommand("sp_InsertRequest", sqlConn)
' define the connection for the command object
sqlCmd.Connection = sqlConn
sqlCmd.CommandType = CommandType.StoredProcedure
' define the SQL parameter
sqlCmd.Parameters.AddWithValue("@Org", txtOrganization.Text)
sqlCmd.Parameters.AddWithValue("@REQ_Date", txtRequester_Date.Text)
' open the connection
sqlConn.Open()
' execute the data insertion
sqlCmd.ExecuteNonQuery()
' close SQL connection
sqlConn.Close()
' dispose of the connection object (mostly optional but good practice)
sqlConn.Dispose()
' Notify the submission was accepted
Response.Write("Thank-you for your Request!")
End If
End Sub
Private Function isempty(ByVal p1 As Object) As String
Throw New NotImplementedException
End Function
End Class