|
- List.aspx 디자인
<div>
게시판 리스트
<asp:GridView ID="ctlBasicList" runat="server" BackColor="White"
AutoGenerateColumns="false"
BorderColor="#999999" BorderStyle="Outset" BorderWidth="10px"
CellPadding="3"
ForeColor="Black" GridLines="Vertical">
<div>
<FooterStyle BackColor="#CCCCCC" />
<PagerStyle BackColor="#999999" ForeColor="Black"
HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#000099" Font-Bold="True"
ForeColor="White" />
<HeaderStyle BackColor="Black" Font-Bold="True"
ForeColor="White" />
<AlternatingRowStyle BackColor="#CCCCCC" />
<Columns>
<asp:BoundField HeaderText="번호" DataField="Num" />
<asp:HyperLinkField HeaderText ="제목"
DataNavigateUrlFields ="Num"
DataNavigateUrlFormatString="View.aspx?Num={0}"
DataTextField="Title"
ItemStyle-Width ="350px" />
<asp:BoundField HeaderText="작성자" DataField="Name" />
<asp:BoundField HeaderText="작성일" DataField="PostDate"
DataFormatString="{0:yyyy-MM-dd}" />
<asp:BoundField HeaderText="조회수"
DataField="ReadCount" />
</Columns>
</asp:GridView>
검색:<asp:DropDownList ID="lstSearchField" runat="server">
<asp:ListItem Value="Name">이름</asp:ListItem>
<asp:ListItem Value="Title" Selected="True">제목</asp:ListItem>
<asp:ListItem Value="Content">내용</asp:ListItem>
</asp:DropDownList>
<asp:TextBox ID="txtSearchQuery" runat="server"></asp:TextBox>
<asp:Button ID="btnSearch" runat="server" Text="검색"
onclick="btnSearch_Click" /><br />
<asp:Button ID="btnWrite" runat="server" Text="글쓰기"
onclick="btnWrite_Click" />
</div>
</form>
</body>
</html>
----------------------------------------------------------------------
List.CS
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
public partial class Basic_List : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//그리드뷰 컨트롤에 이터 출력
if (!Page.IsPostBack)
{
//그리드뷰 컨트롤에 데이터 출력
DisplayData();
}
}
private void DisplayData()
{
//커넥션
SqlConnection con = new SqlConnection
(ConfigurationManager.ConnectionStrings
["ConnectionString"].ConnectionString);
//커맨드
SqlCommand cmd = new SqlCommand("ListBasic", con);
//데이터어댑터
SqlDataAdapter da = new SqlDataAdapter(cmd);
//데이터셋
DataSet ds = new DataSet();
//Fill()
da.Fill(ds,"Basic");
//바인딩
this.ctlBasicList.DataSource = ds.Tables[0];
this.ctlBasicList.DataBind();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
//검색 페이지로 필드명과 검색어 전달
string strUrl =
String.Format(
"Search.aspx?SearchField={0}&SearchQuery={1}"
, lstSearchField.SelectedValue
, txtSearchQuery.Text
);
Response.Redirect(strUrl);
}
protected void btnWrite_Click(object sender, EventArgs e)
{
Response.Redirect("Write.aspx");
}
} | 
WebBasic10월6일.zip