Complete .Net Tutorial: Create Comment Box In Asp.Net

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>

Author : Sandeep Kumar Jha

15 comments

comments

Credit Loan Solution

April 13, 2020 at 2:05 PM delete

Do you need Personal Loan?
Business Cash Loan?
Unsecured Loan
Fast and Simple Loan?
Quick Application Process?
Approvals within 24-72 Hours?
No Hidden Fees Loan?
Funding in less than 1 Week?
Get unsecured working capital?
Contact Us At : gaincreditloan1@gmail.com
Whatsapps +31-635-250-311 (WhatsApp Only)

April 20, 2020 at 2:51 PM delete

jbjbj

Mindest

February 2, 2021 at 9:49 AM delete

Positive site, where did u come up with the information on this posting? I'm pleased I discovered it though, ill be checking back soon to find out what additional posts you include. 代理翻墙软件

February 22, 2021 at 2:31 PM delete

I am a new user of this site so here i saw multiple articles and posts posted by this site,I curious more interest in some of them hope you will give more information on this topics in your next articles. 科学上网

Anonymous

March 15, 2021 at 12:18 PM delete

Your Blog is awesome to get info, please if you want some business leads so
MCA Leads

DesmondCuthbert

June 11, 2021 at 5:21 AM delete

VPN软件 is a Panama-based, no logs VPN service offering a 30 day risk-free trial with all of their VPN subscriptions. It is a fully-featured VPN service with excellent performance, strong security, and a very reasonable price.

GORILLA

September 9, 2021 at 8:25 AM delete

Very informative post! There is a lot of information here that can help any business get started with a successful social networking campaign. nursing test bank

seoexpert

October 7, 2021 at 8:51 AM delete

That appears to be without doubt terrific. A good number of teeny facts are meant experiencing great deal of background abilities. I will be interested the thing a large amount. Barbie Doll Boxes

Noah liam

December 23, 2021 at 5:46 AM delete

This blog is very informative. Packing can be a long hectic process but it can be made easier by following the tips that you have mentioned above. Thanks for sharing such important and useful information. Keep it up.
visit mentioned website for printing services.
Vape Cartridge Boxes
CBD Vape Packaging
dank vape packaging
pop vape boxes

Joe Conor

January 5, 2022 at 4:10 AM delete

Thank you for writing this quality informational content. Your writing technique is impressive and enjoyable to read. If you want about software developer services in bangalore .

johanwilliam

February 14, 2022 at 10:40 AM delete

Technumus is the most informative and knowledge increasing webisite. please follow visit and suppot us.WHAT IS THE PARAMETER OF INTEREST IN STATISTIC

March 27, 2022 at 1:40 AM delete

Create Comment Box In Asp.Net - Complete .Net Tutorial >>>>> Download Now

>>>>> Download Full

Create Comment Box In Asp.Net - Complete .Net Tutorial >>>>> Download LINK

>>>>> Download Now

Create Comment Box In Asp.Net - Complete .Net Tutorial >>>>> Download Full

>>>>> Download LINK

Anusha Peter

October 17, 2022 at 1:24 AM delete

Thanks for sharing this informative article. For more info click here.

Vicky White

November 24, 2023 at 9:49 AM delete

The content is highly informative and the way you have mentioned key factors in your blog is quite significant. I am android app developer and working at Android App Development Company. If you need any development services just contact me.

Sanam Naz

November 24, 2023 at 11:37 AM delete

Thank you for crafting this informative and high-quality content. Your writing style is not only impressive but also engaging, making it a pleasure to read. Being a oral health practitioner I offering top-notch oral services like Best Root Canal Treatment and much more. Just let me know for quality oral health procedures.

Complete .Net Tutorial

Create Comment Box In Asp.Net

Author : Sandeep Kumar Jha

Share this

15 comments