📄 userhome.aspx
字号:
sql1.SelectCommand.CommandText = "select * from tbaddcart"
Dim status As String
Dim type As String
Dim prod As String
Dim name As String
prod = "Harry Potter And The Order of The Phoenix"
name = "Unknown"
Dim price As String
price = "999"
type = "Game"
status = "Not Purchased"
sql1.Fill(ds, "tbaddcart")
demp1 = ds.Tables("tbaddcart")
dr1 = ds.Tables("tbaddcart").NewRow
dr1.Item(0) = Session("username")
dr1.Item(1) = prod
dr1.Item(2) = price
dr1.Item(3) = name
dr1.Item(4) = type
ds.Tables("tbaddcart").Rows.Add(dr1)
sql1.InsertCommand = New SqlCommand
sql1.InsertCommand.Connection = sqlcon
sql1.InsertCommand.CommandText = "insert into tbaddcart(CustomerId, ProductName, ProductPrice,Author,Type,Status) values('" & Session("username") & "','" & prod & "','" & price & "','" & name & "','" & type & "','" & status & "')"
sql1.Update(dr1.Table)
MsgBox("* Product has been added to cart", MsgBoxStyle.Information, "Product Added")
sqlcon.Close()
End Sub
Protected Sub btcd4_Click(ByVal sender As Object, ByVal e As System.EventArgs)
sqlcon = New SqlConnection("Data Source=.; database =BookStore;Integrated Security=True")
sql1.SelectCommand = New SqlCommand
sql1.SelectCommand.Connection = sqlcon
sql1.SelectCommand.CommandText = "select * from tbaddcart"
Dim status As String
Dim type As String
Dim prod As String
Dim name As String
prod = "Harley Davidson Motor Cycles - Gold Pack"
name = "Unknown"
Dim price As String
price = "199"
type = "Game"
status = "Not Purchased"
sql1.Fill(ds, "tbaddcart")
demp1 = ds.Tables("tbaddcart")
dr1 = ds.Tables("tbaddcart").NewRow
dr1.Item(0) = Session("username")
dr1.Item(1) = prod
dr1.Item(2) = price
dr1.Item(3) = name
dr1.Item(4) = type
ds.Tables("tbaddcart").Rows.Add(dr1)
sql1.InsertCommand = New SqlCommand
sql1.InsertCommand.Connection = sqlcon
sql1.InsertCommand.CommandText = "insert into tbaddcart(CustomerId, ProductName, ProductPrice,Author,Type,Status) values('" & Session("username") & "','" & prod & "','" & price & "','" & name & "','" & type & "','" & status & "')"
sql1.Update(dr1.Table)
MsgBox("* Product has been added to cart", MsgBoxStyle.Information, "Product Added")
sqlcon.Close()
End Sub
Protected Sub btcd5_Click(ByVal sender As Object, ByVal e As System.EventArgs)
sqlcon = New SqlConnection("Data Source=.; database =BookStore;Integrated Security=True")
sql1.SelectCommand = New SqlCommand
sql1.SelectCommand.Connection = sqlcon
sql1.SelectCommand.CommandText = "select * from tbaddcart"
Dim status As String
Dim type As String
Dim prod As String
Dim name As String
prod = "Counter-Strike 1"
name = "Unknown"
Dim price As String
price = "499"
type = "Game"
status = "Not Purchased"
sql1.Fill(ds, "tbaddcart")
demp1 = ds.Tables("tbaddcart")
dr1 = ds.Tables("tbaddcart").NewRow
dr1.Item(0) = Session("username")
dr1.Item(1) = prod
dr1.Item(2) = price
dr1.Item(3) = name
dr1.Item(4) = type
ds.Tables("tbaddcart").Rows.Add(dr1)
sql1.InsertCommand = New SqlCommand
sql1.InsertCommand.Connection = sqlcon
sql1.InsertCommand.CommandText = "insert into tbaddcart(CustomerId, ProductName, ProductPrice,Author,Type,Status) values('" & Session("username") & "','" & prod & "','" & price & "','" & name & "','" & type & "','" & status & "')"
sql1.Update(dr1.Table)
MsgBox("* Product has been added to cart", MsgBoxStyle.Information, "Product Added")
sqlcon.Close()
End Sub
</script>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<table style="width: 505px; height: 736px;">
<tr>
<td colspan="5" style="height: 31px; text-align: center">
<span style="font-size: 14pt">W E L C O M E </span>
<asp:Label ID="customer_name" runat="server" ForeColor="Maroon" Font-Size="Large"></asp:Label><span
style="font-size: 14pt"> I N O U R B O O K S T O R E</span></td>
</tr>
<tr>
<td colspan="5" style="height: 31px; text-align: center; background-image: url(images/footer_bg.gif);">
<span style="font-size: 16pt; color: #ffffff;">B O O K S F O R Y O U</span></td>
</tr>
<tr>
<td style="text-align: center">
<asp:Image ID="Image1" runat="server" Height="158px" ImageUrl="~/images/0070222924.jpg"
Width="133px" /><br />
Rs:550/-<asp:LinkButton ID="LinkButton1" runat="server">View Detail</asp:LinkButton><br />
<asp:Button ID="btbook1" runat="server" Text="Add To Cart" OnClick="btbook1_Click" /></td>
<td style="text-align: center">
<asp:Image ID="Image2" runat="server" Height="158px" ImageUrl="~/images/0099514540.jpg"
Width="138px" /><br />
RS:237/-<asp:LinkButton ID="LinkButton2" runat="server">View Detail</asp:LinkButton><asp:Button
ID="btbook2" runat="server" Text="Add To Cart" OnClick="btbook2_Click" /></td>
<td style="text-align: center">
<asp:Image ID="Image3" runat="server" Height="153px" ImageUrl="~/images/0141014598.jpg"
Width="125px" /><br />
RS:301/-<asp:LinkButton ID="LinkButton3" runat="server">View Detail</asp:LinkButton><asp:Button
ID="btbook3" runat="server" Text="Add To Cart" OnClick="btbook3_Click" /></td>
<td style="text-align: center">
<asp:Image ID="Image4" runat="server" Height="154px" ImageUrl="~/images/0330504258.jpg"
Width="134px" /><br />
RS:133/-
<asp:LinkButton ID="LinkButton4" runat="server">View Detail</asp:LinkButton><asp:Button
ID="btbook4" runat="server" Text="Add To Cart" OnClick="btbook4_Click" /></td>
<td style="text-align: center">
<asp:Image ID="Image5" runat="server" Height="157px" ImageUrl="~/images/184737-0292.jpg"
Width="143px" /><br />
RS:390/-
<asp:LinkButton ID="LinkButton5" runat="server">View Detail</asp:LinkButton><asp:Button
ID="btbook5" runat="server" Text="Add To Cart" OnClick="btbook5_Click" /></td>
</tr>
<tr>
<td colspan="5" style="background-image: url(images/footer_bg.gif); height: 36px">
</td>
</tr>
<tr>
<td style="height: 134px; text-align: center">
<asp:Image ID="Image6" runat="server" Height="169px" ImageUrl="~/images/81799-2162.jpg"
Width="144px" /><br />
RS:185/-
<asp:LinkButton ID="LinkButton6" runat="server">View Detail</asp:LinkButton><asp:Button
ID="btbook6" runat="server" Text="Add To Cart" OnClick="btbook6_Click" /></td>
<td style="height: 134px; text-align: center">
<asp:Image ID="Image7" runat="server" Height="162px" ImageUrl="~/images/9780330456524.jpg"
Width="136px" /><br />
RS:237/-
<asp:LinkButton ID="LinkButton7" runat="server">View Detail</asp:LinkButton><asp:Button
ID="btbook7" runat="server" Text="Add To Cart" OnClick="btbook7_Click" /></td>
<td style="height: 134px; text-align: center">
<asp:Image ID="Image8" runat="server" Height="153px" ImageUrl="~/images/9780340952214.jpg"
Width="128px" /><br />
RS:250/-
<asp:LinkButton ID="LinkButton8" runat="server">View Detail</asp:LinkButton><asp:Button
ID="btbook8" runat="server" Text="Add To Cart" OnClick="btbook8_Click" /></td>
<td style="height: 134px; text-align: center">
<asp:Image ID="Image9" runat="server" Height="153px" ImageUrl="~/images/9788122310481.jpg"
Width="134px" /><br />
RS:175/-
<asp:LinkButton ID="LinkButton9" runat="server">View Detail</asp:LinkButton><asp:Button
ID="btbook9" runat="server" Text="Add To Cart" OnClick="btbook9_Click" /></td>
<td style="height: 134px; text-align: center">
<asp:Image ID="Image10" runat="server" Height="153px" ImageUrl="~/images/9788129114686.jpg"
Width="133px" /><br />
RS:395/-
<asp:LinkButton ID="LinkButton10" runat="server">View Detail</asp:LinkButton><asp:Button
ID="btbook10" runat="server" Text="Add To Cart" OnClick="btbook10_Click" /></td>
</tr>
<tr>
<td colspan="5" style="background-image: url(images/footer_bg.gif); height: 29px">
</td>
</tr>
<tr>
<td colspan="5" style="height: 32px; text-align: center; background-image: url(images/footer_bg.gif);">
<span style="font-size: 16pt; color: #ffffff;">C D / D V D F O R Y O U</span></td>
</tr>
<tr>
<td style="text-align: center">
<asp:Image ID="Image11" runat="server" ImageUrl="~/images/game1.jpg" /><br />
RS:1299/-<asp:LinkButton ID="LinkButton11" runat="server">View Detail</asp:LinkButton><asp:Button
ID="btcd1" runat="server" Text="Add To Cart" OnClick="btcd1_Click" /></td>
<td style="text-align: center">
<asp:Image ID="Image12" runat="server" ImageUrl="~/images/game2.jpg" /><br />
RS:1299/-<asp:LinkButton ID="LinkButton12" runat="server">View Detail</asp:LinkButton><asp:Button
ID="btcd2" runat="server" Text="Add To Cart" OnClick="btcd2_Click" /></td>
<td style="text-align: center">
<asp:Image ID="Image13" runat="server" ImageUrl="~/images/game3.jpg" /><br />
RS:999/-
<asp:LinkButton ID="LinkButton13" runat="server">View Detail</asp:LinkButton><asp:Button
ID="btcd3" runat="server" Text="Add To Cart" OnClick="btcd3_Click" /></td>
<td style="text-align: center">
<asp:Image ID="Image14" runat="server" ImageUrl="~/images/game4.jpg" /><br />
RS:199/-
<asp:LinkButton ID="LinkButton14" runat="server">View Detail</asp:LinkButton><asp:Button
ID="btcd4" runat="server" Text="Add To Cart" OnClick="btcd4_Click" /></td>
<td style="text-align: center">
<asp:Image ID="Image15" runat="server" ImageUrl="~/images/game5.jpg" /><br />
RS:499/-
<asp:LinkButton ID="LinkButton15" runat="server">View Detail</asp:LinkButton><asp:Button
ID="btcd5" runat="server" Text="Add To Cart" OnClick="btcd5_Click" /></td>
</tr>
</table>
</asp:Content>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -