Complete .Net Tutorial: March 2016

All of us have seen a comment box on various websites. In this Post, we will learn how to create a Simple Comment Box in ASP.NET. For demonstration, I have created a database (named as Database). The following is the table design for creating tbl_Comment.

Let's Begin:
1. Create an Empty ASP.NET Website and Add a Web Form (Default.aspx) to it.
2. Inside of div tag, create a table with 3 columns and 4 rows.
3. Drop the Label control and TextBox Control in the first and second column. Change the TextMode property for the Comment TextBox to MultiLine.
4. Drop Button Control and Set Id as btn_Submit and Text as Post Comment.
Preview:

5. Drop two Repeater Control after the table tag. One for displaying the comments and other for displaying paging.

Default.aspx Code:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>


<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <style type="text/css">
        .auto-style1 {
            width: 86px;
        }

        .auto-style2 {
            width: 201px;
        }
    </style>
    <link href="StyleSheet.css" rel="stylesheet" />
</head>
<body style="font-family: arial;">
    <form id="form1" runat="server">
      <div id="main" style="padding-left: 80px;padding-top: 20px;">
            <div class="formDesign">
                <table style="width: 100%;" cellpadding="6px">
<tr>
                        <td class="auto-style1">Name</td>
                        <td class="auto-style2">
                            <asp:TextBox ID="txtName" runat="server" Width="188px" ValidationGroup="AB"></asp:TextBox>
                        </td>
                        <td>
                            <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="txtName" ErrorMessage="Please Provide Name" ForeColor="#CC0000" ValidationGroup="AB">*</asp:RequiredFieldValidator>
                        </td>
                    </tr>
<%--
<tr>
                        <td class="auto-style1">Email</td>
                        <td class="auto-style2">
                            <asp:TextBox ID="txtEmail" runat="server" Width="185px"></asp:TextBox>
                        </td>
                        <td>
                            <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="txtEmail" Display="Dynamic" ErrorMessage="Please Provide Email" ForeColor="#CC0000">*</asp:RequiredFieldValidator>
                            <asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ControlToValidate="txtEmail" Display="Dynamic" ErrorMessage="Email ID is Incorrect" ForeColor="#CC0000" ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*">*</asp:RegularExpressionValidator>
                        </td>
                    </tr>
--%>
<tr>
                        <td class="auto-style1">Comment</td>
                        <td class="auto-style2">
                            <asp:TextBox ID="txtComment" runat="server" Height="93px" TextMode="MultiLine" Width="188px" ValidationGroup="AB"></asp:TextBox>
                        </td>
                        <td>
                            <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="txtComment" ErrorMessage="Please Provide Comment" ForeColor="#CC0000" ValidationGroup="AB">*</asp:RequiredFieldValidator>
                        </td>
                    </tr>
<tr>
                        <td class="auto-style1">Rating</td>
                        <td class="auto-style2">
                            <asp:RadioButton ID="RadioButton1" runat="server" Font-Bold="False" Text="1" Font-Names="Arial" Checked="True" GroupName="A" /> 
                            <asp:RadioButton ID="RadioButton2" runat="server" Font-Bold="False" Text="2" Font-Names="Arial" GroupName="A" /> 
                            <asp:RadioButton ID="RadioButton3" runat="server" Font-Bold="False" Text="3" Font-Names="Arial" GroupName="A" /> 
                            <asp:RadioButton ID="RadioButton4" runat="server" Font-Bold="False" Text="4" Font-Names="Arial" GroupName="A" /> 
                            <asp:RadioButton ID="RadioButton5" runat="server" Font-Bold="False" Text="5" Font-Names="Arial" GroupName="A" />
                        </td>
                        <td>
                             </td>
                    </tr>
<tr>
                        <td class="auto-style1"> </td>   
                        <td class="auto-style2">
                            <asp:Button ID="btn_Submit" runat="server" Text="Post Comment" OnClick="btn_Submit_Click" CssClass="buttonSubmit" ValidationGroup="AB" />
                        </td>
                        <td>
                            <asp:HiddenField ID="hfSelectedRecord" runat="server" />
                        </td>
                    </tr>
</table>
</div>
<h4 style="text-decoration:underline;">
Comments:</h4>
<asp:Repeater ID="Repeater1" runat="server" OnItemCommand="Repeater1_ItemCommand">
                <itemtemplate>
                    <div class="commentbox">
                        <b>
                            <%--old code--%>

                       <%-- <asp:Label ID="Label1" runat="server" Text='<%#Eval("Name") %>'>'></asp:Label></b> <br /><br />  (<asp:Label ID="Label2" runat="server" Text='<%#Eval("Email") %>'>'></asp:Label>):<br /><br />
                        <asp:Label ID="Label3" runat="server" Text='<%#Eval("Comment") %>'></asp:Label><br /><br />
                        <asp:Label ID="Label5" runat="server" Text="Rating : "></asp:Label>
                         <asp:Label ID="Label4" runat="server" Text='<%#Eval("Marks") %>'></asp:Label><br />--%>

                            <asp:Label ID="Label2" runat="server" Text='<%#Eval("Remarkby") %>'>'></asp:Label></b> <br /><br /> <%--(<asp:Label ID="Label2" runat="server" Text='<%#Eval("Email") %>'>'></asp:Label>):<br /><br />--%>
                        <asp:Label ID="Label6" runat="server" Text='<%#Eval("Remarks") %>'></asp:Label><br /><br />
                        <asp:Label ID="Label7" runat="server" Text="Rating : "></asp:Label>
                         <asp:Label ID="Label8" runat="server" Text='<%#Eval("Rating") %>'></asp:Label><br />

                        <div style="text-align:right">
  <asp:ImageButton ID="ImageButton4" runat="server" Height="20px" ImageUrl="~/Image/edit.png" ToolTip="Edit" Width="20px" CommandName="Edit" CommandArgument='<%#Eval("Id" )%>' />
                        <asp:ImageButton ID="ImageButton5" ValidationGroup="CZ" runat="server" ForeColor="Red" Height="20px" ImageUrl="~/Image/editing-delete-icon.png" ToolTip="Delete" Width="20px"  CommandName="Delete"  CommandArgument='<%#Eval("Id") %>' onclientclick="javascript:return confirm('Are you sure to delete record?')" /><br /></div>
</div>
</ItemTemplate>
            </asp:Repeater>
            <div style="overflow: hidden;">
                <asp:Repeater ID="rptPaging" runat="server" OnItemCommand="rptPaging_ItemCommand">
                    <itemtemplate>
                        <asp:LinkButton ID="btnPage"
                            Style="padding: 8px; margin: 2px; background: #007acc; border: solid 1px blue; font: 8px;"
                            CommandName="Page" CommandArgument="<%# Container.DataItem %>"
                            runat="server" ForeColor="White" Font-Bold="True" CausesValidation="false"><%# Container.DataItem %>
                        </asp:LinkButton>
                    </ItemTemplate>
                </asp:Repeater>
            </div>
</div>
</form>
</body>
</html>

Default.aspx.cs Code

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;
using System.Configuration;
using System.Collections;

public partial class _Default : System.Web.UI.Page
{
    string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
 
    protected void Page_Load(object sender, EventArgs e)
    {
       
        if (!IsPostBack)
        {
            fillData();
           // BindDropDownList();
        }
    
    }

    //FillData method for filling Repeater Control with Data
    private void fillData()
    {
        
        SqlConnection con = new SqlConnection(cs);
        con.Open();
        DataTable dt = new DataTable();
        SqlDataAdapter adapt = new SqlDataAdapter("Select * from tbl_Remarks Order by Id Desc", con);
        adapt.Fill(dt);
        con.Close();
        PagedDataSource pds = new PagedDataSource();
        DataView dv = new DataView(dt);
        pds.DataSource = dv;
        pds.AllowPaging = true;
        pds.PageSize = 4;
        pds.CurrentPageIndex = PageNumber;
        if (pds.PageCount > 1)
        {
            rptPaging.Visible = true;
            ArrayList arraylist = new ArrayList();
            for (int i = 0; i < pds.PageCount; i++)
                arraylist.Add((i + 1).ToString());
            rptPaging.DataSource = arraylist;
            rptPaging.DataBind();
        }
        else
        {
            rptPaging.Visible = false;
        }
        Repeater1.DataSource = pds;
        Repeater1.DataBind();
    }
    //btn_Submit Click Event
    protected void btn_Submit_Click(object sender, EventArgs e)
    {
        if (btn_Submit.Text == "Post Comment")
        { 
            InsertData();
        }
         else if (btn_Submit.Text == "Update Comment")
        { 
            UpdateData(); 
        }
       

    }
    public void InsertData()
    {
        string gender = string.Empty;
        if (RadioButton1.Checked)
        {
            gender = "1";
        }
        else if (RadioButton2.Checked)
        {
            gender = "2";
        }
        else if (RadioButton3.Checked)
        {
            gender = "3";
        }
        else if (RadioButton4.Checked)
        {
            gender = "4";
        }
        else if (RadioButton5.Checked)
        {
            gender = "5";
        }

        SqlConnection con = new SqlConnection(cs);
        con.Open();

        //Original Code
        /*SqlCommand cmd = new SqlCommand("insert into tbl_Comment(Name,Email,Comment,Marks) values(@name,@email,@comment,@marks)", con);
        cmd.Parameters.AddWithValue("@name", txtName.Text);
        cmd.Parameters.AddWithValue("@email", txtEmail.Text);
        cmd.Parameters.AddWithValue("@comment", txtComment.Text);
        cmd.Parameters.AddWithValue("@marks", gender);*/


        //Changed Code
       /* SqlCommand cmd = new SqlCommand("insert into tbl_Comment(Name,Comment,Marks) values(@name,@comment,@marks)", con);
        cmd.Parameters.AddWithValue("@name", txtName.Text);
        cmd.Parameters.AddWithValue("@comment", txtComment.Text);
        cmd.Parameters.AddWithValue("@marks", gender);*/

        //Latest
        SqlCommand cmd = new SqlCommand("insert into tbl_Remarks(Remarkby,Remarks,Rating) values(@name,@comment,@marks)", con);
        cmd.Parameters.AddWithValue("@name", txtName.Text);
        cmd.Parameters.AddWithValue("@comment", txtComment.Text);
        cmd.Parameters.AddWithValue("@marks", gender);

        cmd.ExecuteNonQuery();
        con.Close();
        //Displaying Javascript alert Comment Posted Successfully
       ScriptManager.RegisterStartupScript(this, this.GetType(), "popup", "alert('Comment Posted Successfully.');window.location='default.aspx';", true);
        fillData();
        txtName.Text = "";
        //txtEmail.Text = "";
        txtComment.Text = "";
        
        
    }
    public void UpdateData()
    {
        string gender = string.Empty;
        if (RadioButton1.Checked)
        {
            gender = "1";
        }
        else if (RadioButton2.Checked)
        {
            gender = "2";
        }
        else if (RadioButton3.Checked)
        {
            gender = "3";
        }
        else if (RadioButton4.Checked)
        {
            gender = "4";
        }
        else if (RadioButton5.Checked)
        {
            gender = "5";
        }

        //====== Getting connection string defined in the web.config file. Pointed to the database we want to use.
        SqlConnection con = new SqlConnection(cs);
        con.Open();

        //======= Insert Query.
        string cmdText = "UPDATE tbl_Remarks SET Remarkby=@Name,Remarks=@comment,Rating=@gender WHERE Id=@Id";

        //====== Providning information to SQL command object about which query to 
        //====== execute and from where to get database connection information.
        SqlCommand cmd = new SqlCommand(cmdText, con);

        //===== Adding parameters/Values.
        cmd.Parameters.AddWithValue("@Name", txtName.Text);
        cmd.Parameters.AddWithValue("@comment", txtComment.Text);
        cmd.Parameters.AddWithValue("@gender", gender);

        //====== Remember we have stored primary key in hiddenfield during 
        //====== binding values into textboxes method:(bindEmployeeDetailToEdit).
        //====== We will use same id to pass id parameter.
        cmd.Parameters.AddWithValue("@Id", Convert.ToInt32(hfSelectedRecord.Value));


        //===== To check current state of the connection object. If it is closed open the connection
        //===== to execute the insert query.
        if (con.State == ConnectionState.Closed)
        {
            con.Open();
        }

        //===== Execute Query.
        cmd.ExecuteNonQuery();

        //===== close the connection.
        con.Close();

        //===== Clear text from textboxes


        //===== Bind data to repeater so that repeater will display updated data.


        //===== Show Save button and hide update button.


        //===== Clear Hiddenfield
        hfSelectedRecord.Value = string.Empty;
        btn_Submit.Text = "Post Comment";
        fillData();
        txtName.Text = "";
        //txtEmail.Text = "";
        txtComment.Text = "";
    }
    public int PageNumber
    {
        get
        {
            if (ViewState["PageNumber"] != null)
                return Convert.ToInt32(ViewState["PageNumber"]);
            else
                return 0;
        }
        set
        {
            ViewState["PageNumber"] = value;
        }
    }
    protected void rptPaging_ItemCommand(object source, RepeaterCommandEventArgs e)
    {
        PageNumber = Convert.ToInt32(e.CommandArgument) - 1;
        fillData();
    }


    protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
    {
        switch (e.CommandName)
        {
            //==== This case will fire when link button placed
            //==== inside repeater having command name "Delete" is clicked.

            case ("Delete"):
                //==== Getting id of the selelected record(We have passed on link button's command argument property).
                int id = Convert.ToInt32(e.CommandArgument);

                //==== Call delete method and pass id as argument.
                deleteEmployee(id);

                break;

            //==== This case will fire when link button placed
            //==== inside repeater having command name "Edit" is clicked.
            case ("Edit"):

                //==== Getting id of the selelected record(We have passed on link button's command argument property).
                id = Convert.ToInt32(e.CommandArgument);

                //==== Call delete method and pass id as argument.

                bindEmployeeDetailToEdit(id);
                break;

        }
    }
    //===== Method to delete employee from database.
    void deleteEmployee(int id)
    {
        SqlConnection con = new SqlConnection(cs);
        con.Open();
        //====== Getting connection string defined in the web.config file. Pointed to the database we want to use.
     

        //======= Delete Query.

        string cmdText = "DELETE FROM tbl_Remarks WHERE Id=@Id";       

        //====== Providning information to SQL command object about which query to 
        //====== execute and from where to get database connection information.
        SqlCommand cmd = new SqlCommand(cmdText, con);

        //===== Adding parameters/Values.
        cmd.Parameters.AddWithValue("@Id", id);

        //===== To check current state of the connection object. If it is closed open the connection
        //===== to execute the insert query.
        if (con.State == ConnectionState.Closed)
        {
            con.Open();
        }
        //===== Execute Query.
        cmd.ExecuteNonQuery();

        //===== close the connection.
        con.Close();
        fillData();
        //===== Bind data to repeater so that repeater will display updated data.
       
    }

    void bindEmployeeDetailToEdit(int id)
    {
        btn_Submit.Text = "Update Comment";
        //====== Getting connection string defined in the web.config file. Pointed to the database we want to use.
        SqlConnection con = new SqlConnection(cs);
        con.Open();

        //======= Parameterized select Query.
        string cmdText = "SELECT * FROM tbl_Remarks WHERE Id=@Id";

        //====== Providning information to SQL command object about which query to 
        //====== execute and from where to get database connection information.
        SqlCommand cmd = new SqlCommand(cmdText, con);

        //===== Adding parameters/Values.
        cmd.Parameters.AddWithValue("@Id", id);

        //===== To check current state of the connection object. If it is closed open the connection
        //===== to execute the insert query.
        if (con.State == ConnectionState.Closed)
        {
            con.Open();
        }

        //===== Execute Query.
        SqlDataReader dr = cmd.ExecuteReader();

        //===== Check if data present.
        if (dr.HasRows)
        {
            //===== Read data from datareader.
            dr.Read();

            //===== Bind values to textboxes.
            txtName.Text = dr["Remarkby"].ToString();
            txtComment.Text = dr["Remarks"].ToString();
            
           

            //==== Store primary key of the selected record in hiddenfield for future reference.
            //==== This will help us when we write update method.
            hfSelectedRecord.Value = dr["id"].ToString();

        }
        dr.Dispose();

        //===== close the connection.
        con.Close();

        //==== Show Update button and hide Save button.
        //btnSave.Visible = false;
       // btnUpdate.Visible = true;

    }

    private void BindDropDownList()
    {
        SqlConnection connection = new SqlConnection(cs);

        DataTable dt = new DataTable();
        string id = string.Empty;
        string name = string.Empty;
        string newName = string.Empty;

       // SqlConnection connection = new SqlConnection(GetConnectionString());
        try
        {
            connection.Open();
            string sqlStatement = "SELECT * FROM tbl_Remarks";
            SqlCommand sqlCmd = new SqlCommand(sqlStatement, connection);
            SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd);

            sqlDa.Fill(dt);
            if (dt.Rows.Count > 0)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    id = dt.Rows[i]["Remarkby"].ToString();
                    name = dt.Rows[i]["Remarks"].ToString();
                    newName = id + " --> " + name;
                //    DropDownList1.Items.Add(new ListItem(newName, id));
                }
            }
        }
        catch (System.Data.SqlClient.SqlException ex)
        {
            string msg = "Fetch Error:";
            msg += ex.Message;
            throw new Exception(msg);
        }
        finally
        {
            connection.Close();
        }
    }


    
}

Web.config code

<?xml version="1.0"?>
<!--
  For more information on how to configure your ASP.NET application, please visit
  http://go.microsoft.com/fwlink/?LinkId=169433
  -->

<configuration>
<connectionstrings>
   
  <add name="DBCS" connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\Remarks.mdf;Integrated Security=True"/>
  </connectionStrings>
    <system.web>
      <compilation debug="true" targetFramework="4.5" />
      <httpruntime targetFramework="4.5" />
    </system.web>
    <appsettings>
      <add key="ValidationSettings:UnobtrusiveValidationMode" value="None" />
    </appSettings>
</configuration>

Complete .Net Tutorial

Create Comment Box In Asp.Net

Hosting your ASP.NET Project/Website in IIS

Visual Studio 2015 Installation Process