I have an .aspx file that has the following HTML in it for a button that takes the user to the maiin page "project3.html" I am new to HTML and ASP.NET and don't know how this button should work.
Here is the HTML for the button:
<p><p align="center"><INPUT type='submit' value="Back to Main"><a href="project3.html"></a>
</p>
<p><p align="center"><INPUT type='submit' value="Back to Main"><a href="project3.html"></a></p>
Here is the whole page. I don't think I have form tag set up right:
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script runat="server">
Sub Page_Load(sender as Object, e as EventArgs)
If Not Page.IsPostBack
BindData()
End If
End Sub
Dim objConn as New OleDbConnection(strConnStr)
objConn.Open()
'2. Create a command object for the query
Const strSQL as String = "SELECT * FROM sale ORDER by sale_id"
Dim objCmd as New OleDbCommand(strSQL, objConn)
'3. Create/Populate the DataReader
Dim objDR as OleDbDataReader
objDR = objCmd.ExecuteReader()
dgSale.DataSource = objDR
dgSale.DataBind()
End Sub
Sub dgSale_Delete(sender As Object, e As DataGridCommandEventArgs)
'Get the sale_id of the row whose Delete button was clicked
Dim Selected_sale_id as String = dgSale.DataKeys(e.Item.ItemIndex)
Dim objConn as New OleDbConnection(strConnStr)
objConn.Open()
'2. Create a command object for the query
Dim strDelSQL as String = "DELETE FROM sale WHERE sale_id =" & Selected_sale_id
Dim objCmd as New OleDbCommand(strDelSQL, objConn)
objCmd.ExecuteNonQuery()
objConn.Close()
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.Ole
<script runat="server">
Sub Page_Load(sender as Object, e as EventArgs)
If Not Page.IsPostBack
BindData()
End If
End Sub
Sub BindData()
'1. Create a connection
Const strConnStr as String = "Provider=OraOLEDB.Oracle;
"Data Source=(DESCRIPTION=(ADDRE
"(PORT=1521))(CONNECT_DATA
Dim objConn as New OleDbConnection(strConnStr
objConn.Open()
'2. Create a command object for the query
Const strSQL as String = "SELECT * FROM sale ORDER by sale_id"
Dim objCmd as New OleDbCommand(strSQL, objConn)
'3. Create/Populate the DataReader
Dim objDR as OleDbDataReader
objDR = objCmd.ExecuteReader()
dgSale.DataSource = objDR
dgSale.DataBind()
End Sub
Sub dgSale_Delete(sender As Object, e As DataGridCommandEventArgs)
'Get the sale_id of the row whose Delete button was clicked
Dim Selected_sale_id as String = dgSale.DataKeys(e.Item.Ite
'TODO: Delete the record from the database
'1. Create a connection
Const strConnStr as String = "Provider=OraOLEDB.Oracle;
"Data Source=(DESCRIPTION=(ADDRE
"(PORT=1521))(CONNECT_DATA
Dim objConn as New OleDbConnection(strConnStr
objConn.Open()
'2. Create a command object for the query
Dim strDelSQL as String = "DELETE FROM sale WHERE sale_id =" & Selected_sale_id
Dim objCmd as New OleDbCommand(strDelSQL, objConn)
objCmd.ExecuteNonQuery()
objConn.Close()
'TODO: Rebind the DataGrid
BindData()
End Sub
</script>
<html>
<head>
</head>
<body>
<form runat="server">
<asp:DataGrid id="dgSale" table align="center" runat="server"
AutoGenerateColumns="False
HeaderStyle-BackColor="Bla
HeaderStyle-ForeColor="Whi
HeaderStyle-HorizontalAlig
HeaderStyle-Font-Bold="Tru
OnDeleteCommand="dgSale_De
DataKeyField="sale_id">
<Columns>
<asp:ButtonColumn Text="Delete" CommandName="Delete" />
<asp:BoundColumn DataField="sale_id" HeaderText="Sale ID" />
<asp:BoundColumn DataField="agent_id" HeaderText="Agent ID" />
<asp:BoundColumn DataField="home_id" HeaderText="Home ID" />
<asp:BoundColumn DataField="cust_id" HeaderText="Customer ID" />
<asp:BoundColumn DataField="contract_id" HeaderText="Contract ID" />
<asp:BoundColumn DataField="sale_date" HeaderText="Sale Date" DataFormatString={0:dd.MM.
<asp:BoundColumn DataField="actual_amount" HeaderText="Actual Amount" DataFormatString="{0:C2}" />
</Columns>
</asp:DataGrid>
<form action = "project3.html" method="get"
<p><p align="center"><a href="project3.html"><inpu
</p>
</form>
</form>
</body>
</html>