Comments by Member 10479432 (Top 6 by date)

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">

<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">

Search

<p>
<asp:Label ID="lblKeyword" runat="server" Text="Keyword:">
 <asp:TextBox ID="txtSearch" runat="server">
</p>
<p>
<asp:Label ID="lblDocType" runat="server" Text="Document type:">
<asp:DropDownList ID="ddlDocType" runat="server"
DataSourceID="DocTypeSqlDataSource" DataTextField="doc_typeName"
DataValueField="doc_typeName">
<asp:ListItem Selected="True">--All--

<asp:SqlDataSource ID="DocTypeSqlDataSource" runat="server"
ConnectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True"
ProviderName="System.Data.SqlClient"


SelectCommand="SELECT [doc_typeName] FROM [ViewDoc]">

</p>
<p>
<asp:Label ID="lblSearchby" runat="server" Text="Search by:">
<asp:DropDownList ID="DropDownList1" runat="server">
<asp:ListItem>Title
<asp:ListItem>Author

</p>
<p>
<asp:Button ID="btnSearch" runat="server" Text="Search" />
</p>

---

<p>
<asp:Label ID="lblResult" runat="server" Text="Search Result" Font-Size="medium" Font-Bold="true">
</p>
<p>

<asp:GridView ID="GVResult" runat="server" AutoGenerateColumns="False"
DataSourceID="DocNameSqlDataSource" EmptyDataText="No Record Found"
Visible="False" CellPadding="4" ForeColor="#333333" GridLines="None">
<alternatingrowstyle backcolor="White">
<columns>
<asp:BoundField DataField="doc_typeName" HeaderText="doc_typeName"
SortExpression="doc_typeName" />
<asp:BoundField DataField="doc_name" HeaderText="doc_name"
SortExpression="doc_name" />
<asp:BoundField DataField="dateUpload" HeaderText="dateUpload"
SortExpression="dateUpload" />

<footerstyle backcolor="#990000" font-bold="True" forecolor="White">
<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
<rowstyle backcolor="#FFFBD6" forecolor="#333333">
<SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
<sortedascendingcellstyle backcolor="#FDF5AC">
<sortedascendingheaderstyle backcolor="#4D0000">
<sorteddescendingcellstyle backcolor="#FCF6C0">
<sorteddescendingheaderstyle backcolor="#820000">

<asp:SqlDataSource ID="DocNameSqlDataSource" runat="server"
ConnectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True"
ProviderName="System.Data.SqlClient"


SelectCommand="SELECT * FROM [ViewDocSearch] WHERE (([doc_name] LIKE '%' + @doc_name + '%') AND ([doc_typeName] = @doc_typeName))">
<SelectParameters>
<asp:ControlParameter ControlID="txtSearch" Name="doc_name"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="DropDownList1" Name="doc_typeName"
PropertyName="SelectedValue" Type="String" />
</SelectParameters>

</p>
<

http://www.youtube.com/watch?v=GWbBxs1wfv0.. i refer to this vdeo since it is same with what should i do. the problem is, the data cannot be display in the grid view and i'm using one textbox and one dropdown list. not both dropdown list.

i cannot display the selected data in the grid view.

actually i'm new to this. can you show me how to start with it?