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. Add RequiredFieldValidator for all TextBox in the third column. Add another validation i.e. RegularExpressionValidator for txtEmail TextBox. Set the Validation Expression to Internet e-mail address.
Preview:
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>
<form id="form1" runat="server">
<div>
<div class="formDesign">
<table style="width: 100%;">
<tr>
<td class="auto-style1">Name</td>
<td class="auto-style2">
<asp:TextBox ID="txtName" runat="server" Width="185px"></asp:TextBox>
</td>
<td>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="txtName" ErrorMessage="Please Provide Name" ForeColor="#CC0000">*</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="44px" TextMode="MultiLine" Width="185px"></asp:TextBox>
</td>
<td>
<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="txtComment" ErrorMessage="Please Provide Comment" ForeColor="#CC0000">*</asp:RequiredFieldValidator>
</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"
/>
</td>
<td> </td>
</tr>
</table>
</div>
<h4 style="text-decoration:underline;">Comments:</h4>
<asp:Repeater ID="Repeater1"
runat="server">
<ItemTemplate>
<div class="commentbox">
<b>
<asp:Label ID="Label1" runat="server" Text='<%#Eval("Name") %>'>'></asp:Label></b> (<asp:Label ID="Label2" runat="server" Text='<%#Eval("Email") %>'>'></asp:Label>):<br />
<asp:Label ID="Label3" runat="server" Text='<%#Eval("Comment") %>'></asp:Label><br />
</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>
|
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();
}
}
//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_Comment 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)
{
SqlConnection con =
new SqlConnection(cs);
con.Open();
SqlCommand cmd =
new SqlCommand("insert into tbl_Comment(Name,Email,Comment)
values(@name,@email,@comment)",con);
cmd.Parameters.AddWithValue("@name",txtName.Text);
cmd.Parameters.AddWithValue("@email", txtEmail.Text);
cmd.Parameters.AddWithValue("@comment", txtComment.Text);
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 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();
}
}
|
[Download Source Code via Google Drive]
