Asp.net programming we consider all important topic for knowledge about controls,web Services, JSON, Ajax, database, and interview related Question. In this Asp.net and sql server tutorial blog we give many examples of jquery as like How Play YouTube Video in Your Asp.net Website by URL, How to Play YouTube Videos in Asp.net by using Jquery , Jquery Change div background on mouseover in asp.net , JQuery UI Datepicker (Calendar) etc.

Wednesday, July 2, 2014

How to make effective FRQ page in web application

How to make effective FRQ page in web application:

Effective FRQ page in web application refer to the frequently ask Questions list in web application .basically it have some important Question and its answers for use understanding regarding to the web site /application.In the modern web application development we are consider FAQ page in the other pages.




In FRQ pages we consider some important Question by client site and Admin or which responsive to meatiness of web site give the Answers of these Question.And these Questions always display in the web site FRQ page
some web site the visitors also give the Answers of these FRQ questions .in this way the user  has permission to post the answers.    
here we give the code and screen short .but we store all question in the data base first by the Admin End .we make this code for some fix Questions.

Code for aspx page :

<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true"
    CodeFile="frmFAQ.aspx.cs" Inherits="frmFAQ" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
    <table style="width: 100%" border="1">
        <tr>
            <td align="center" style="width: 100%" valign="top">
                <h5 class="GWS_heading">
                   FAQs :
                </h5>
                <br />
                <asp:Label ID="Msg" runat="server" Visible="False" ForeColor="Red" Font-Bold="True"
                    Font-Size="12px"></asp:Label>
                <asp:GridView ID="GrdFAQ" runat="server" RowStyle-HorizontalAlign="Left" CellPadding="3"
                    AutoGenerateColumns="False" Width="100%">
                    <Columns>
                        <asp:TemplateField Visible="false">
                            <ItemTemplate>
                                <asp:Label runat="server" ID="lblWeb_faqid" Text='<%#Eval("Web_faqid")%>'></asp:Label>
                            </ItemTemplate>
                        </asp:TemplateField>
                        <%--<asp:TemplateField HeaderText="SNo.">
                            <ItemTemplate>
                              
                            </ItemTemplate>
                        </asp:TemplateField>--%>
                        <asp:TemplateField HeaderText="FAQ">
                            <ItemTemplate>
                                <table>
                                    <tr>
                                        <td>
                                           <b> Qus <%#Container.DataItemIndex+1 %> :<asp:Label runat="server" ID="lblFAQ_Qus" Text='<%#Eval("FAQ_Qus")%>'></asp:Label></b>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td>
                                            Ans :<asp:Label runat="server" ID="lblFAQ_Ans" Text='<%#Eval("FAQ_Ans")%>'></asp:Label>
                                        </td>
                                    </tr>
                                   
                                </table>
                            </ItemTemplate>
                        </asp:TemplateField>
                    </Columns>
                    <RowStyle BackColor="#84CF96" />
                    <HeaderStyle BackColor="#4C945E" />
                  
                </asp:GridView>
            </td>
        </tr>
    </table>
</asp:Content>
         



How to make effective FRQ page in web application
How to make effective FRQ page in web application


Code for aspx.cs page :

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;


public partial class frmFAQ : System.Web.UI.Page
{
    Web_clsMasterAll objweb = new Web_clsMasterAll();

    protected void Page_Load(object sender, EventArgs e)
    {
        if(!IsPostBack)
        {
            FillGrid();
            this.GrdFAQ.Attributes.Add("bordercolor", "c3cecc");
        }
    }

    public void FillGrid()
    {

        DataSet dsFAQ = new DataSet();
        try
        {
            dsFAQ = objweb.SELECT_FAQ();
            if (dsFAQ.Tables[0].Rows.Count > 0)
            {
                GrdFAQ.DataSource = dsFAQ;
                GrdFAQ.DataBind();

            }
            else
            {
                GrdFAQ.DataSource = "";
                GrdFAQ.DataBind();
                Msg.Text = "There is no data ..";
            }

        }
        catch (Exception ex)
        {


        }



    }
}