CodeSense/SQL.aspx at master · njain006/CodeSense · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="SQL.aspx.cs" Inherits="SQL" %>

<asp:ContentID="Content1"ContentPlaceHolderID="head"Runat="Server">
</asp:Content>
<asp:ContentID="Content2"ContentPlaceHolderID="ContentPlaceHolder1"Runat="Server">
 <divstyle="height: 100%; background-color: #FFFFFF; width: 1450px; margin-left: 243px; margin-right: 0px;"
align="center">
 <divstyle="height: 199px; width: 1123px; background-image: url('images/SQL.jpg'); margin-left: 130px;"
align="left"><br />
 <br />
 <br />
 <br />
 <br />
 <br />
 <br />
 <divstyle="border-top: mediuminset#C0C0C0; border-left: mediumoutset#C0C0C0; border-right: mediuminset#C0C0C0; height: 63px; width: 556px; background-color: #FFFFFF; margin-left: 208px; margin-bottom: 0px;"
align="center">
 <asp:LabelID="Label1"runat="server"Font-Bold="True"
Font-Names="Times New Roman"Font-Size="XX-Large"Text="SQL"></asp:Label>
 </div></div><br /><br />
 <divalign="center"

style="border-top: mediuminset#C0C0C0; border-bottom: mediumoutset#C0C0C0; border-left: mediumoutset#C0C0C0; border-right: mediuminset#C0C0C0; height: 100%; width: 1205px; margin-left: 67px; border-style: noneinsetoutsetoutset; background-color: #FFFFFF;">

 <br />
 <br />
 <br />
 <asp:DataListID="DataList1"runat="server"DataKeyField="Post_ID"
DataSourceID="SqlDataSource1"RepeatColumns="3">
 <ItemTemplate>
 <ahref='Blog1.aspx?id=<%# Eval("Post_ID") %>'>
 <asp:ImageID="Image3"runat="server"Height="230px"
ImageUrl='<%# Eval("Image") %>'Width="312px" />
 </a>
 <br />
 <br />
 <asp:TextBoxID="TextBox1"runat="server"MaxLength="20"ReadOnly="True"
Text='<%# Eval("Post_Content") %>'></asp:TextBox>
 <br />
 <br />
 </ItemTemplate>
 </asp:DataList>
 <asp:SqlDataSourceID="SqlDataSource1"runat="server"
ConnectionString="<%$ ConnectionStrings:CodeSenseBlogConnectionString %>"
SelectCommand="SELECT Post.Post_ID, Post.Post_Content, Post.Image FROM Category INNER JOIN Post ON Category.Category_ID = Post.Category_ID WHERE (Category.Category_Name = @categoryname)">
 <SelectParameters>
 <asp:ControlParameterControlID="Label1"Name="categoryname"
PropertyName="Text"Type="String" />
 </SelectParameters>
 </asp:SqlDataSource>

 </div>


</div>
</asp:Content>