Learn C# ASP.NET MVC WCF SQL Angular: Comment Box in ASP.NET C#

In this article I am going to explain how to write standard code to create comment box in ASP.NET c#.

Create a SQL table for insert comment

CREATE TABLE InsComment (

CommentId BIGINT identity(1, 1)

,NAME VARCHAR(50)

,Comment VARCHAR(500)

)

Now I am writing a XSLT file code to display comment after Save (Create a XSLT fie in "XSLT" floder with name "History.xslt")

Solution Explorer look like

<?xml version="1.0" encoding="utf-8"?>

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:template match="/">

<xsl:for-each select="Comments/Comment">

</div>

<div style="font-weight:bold; float:left; width:100px;">Comment:</div>

</div>

</div>

</xsl:for-each>

</xsl:template>

</xsl:stylesheet>

Default.aspx Code

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

.drp

{

background: #F4F4F4;

border: 1px solid #DEDCDD;

color: #555555;

height: 25px;

padding-left: 10px;

margin-bottom:10px;

-moz-transition: all 0.3s linear;

-o-transition: all 0.3s linear;

-webkit-transition: all 0.3s linear;

transition: all 0.3s linear;

font-family: Arial, Helvetica, sans-serif;

font-size: 12px;

}

.drp:focus { outline:none; border:1px solid #F90; }

.med-form-col-1-8 { width:12.5%; }

.med-form-col-2-8 { width:25%; }

.med-form-col-3-8 { width:37.5%; }

.med-form-col-4-8 { width:50%; }

.med-form-col-5-8 { width:62.5%; }

.med-form-col-6-8 { width:75%; }

.med-form-col-7-8 { width:87.5%; }

.med-form-col-8-8 { width:100%; }

.med-form-col-1-8,

.med-form-col-2-8,

.med-form-col-3-8,

.med-form-col-4-8,

.med-form-col-5-8,

.med-form-col-6-8,

.med-form-col-7-8,

.med-form-col-8-8

{

float:left;

padding:1px 10px;

box-sizing: border-box;

-moz-box-sizing: border-box;

-ms-box-sizing: border-box;

-webkit-box-sizing: border-box;

-khtml-box-sizing: border-box;

}

.med-form-col-1-8 label,

.med-form-col-2-8 label,

.med-form-col-3-8 label,

.med-form-col-4-8 label,

.med-form-col-5-8 label,

.med-form-col-6-8 label,

.med-form-col-7-8 label,

.med-form-col-8-8 label,

{

display:block !important;

width:100% !important;

margin:0 !important;

float:none !important;

}

.med-form-item.large, .med-form-item.large .drp { width:100%; }

.med-form-item.medium, .med-form-item.medium .drp { width:75%; }

.med-form-item.small, .med-form-item.small .drp { width:55%; }

.frmlbl { color: #50505b; padding: 0px 10px 0px 0px; font-size: 14px; font-weight:400; !important }

.clr { clear:both; }

@media only screen and (max-width:600px) {

.med-form-col-1-8,

.med-form-col-2-8,

.med-form-col-3-8,

.med-form-col-4-8,

.med-form-col-5-8,

.med-form-col-6-8,

.med-form-col-7-8,

.med-form-col-8-8

{

display:block !important;

width:100% !important;

margin:0 !important;

float:none !important;

}

.btn { height: 50px; margin: 0; padding: 0 20px; vertical-align: middle; background: #9c9c9c; border: 0; font-family: 'Raleway', sans-serif; font-size: 16px; font-weight: 300; line-height: 50px; color: #fff; -moz-border-radius: 4px; -webkit-border-radius: 4px; border-radius: 4px; text-shadow: none; -moz-box-shadow: none; -webkit-box-shadow: none; box-shadow: none; -o-transition: all .3s; -moz-transition: all .3s; -webkit-transition: all .3s; -ms-transition: all .3s; transition: all .3s; }

</style>

function Enablebutton(val) {

if (val.value.trim() != "") {

document.getElementById('#btnsavecomment').disabled = false;

$('#btnsavecomment').attr("style", "background-color:Yellow");

}

else {

document.getElementById('#btnsavecomment').disabled = true;

$('#btnsavecomment').removeAttr("style");

}

</script>

</head>

<body>

<legend>Comment</legend>

<asp:LinkButton ID="btnlink" runat="server" Text="View all" onclick="btnlink_Click" ></asp:LinkButton>

<asp:LinkButton ID="btnlinktop" runat="server" Text="Last one" onclick="btnlinktop_Click"></asp:LinkButton>

</label>

<asp:Xml ID="xmlContacts" runat="server"></asp:Xml>

<asp:TextBox ID="txtcomment" onkeyup="Enablebutton(this);" runat="server" MaxLength="500" Height="80" CssClass="drp" TextMode="MultiLine">

</asp:TextBox>

</div>

</div>

<asp:Label ID="lblmsg" runat="server"></asp:Label>

<asp:Button ID="btnsavecomment" OnClick="btnsavecomment_Click" runat="server" Text="Post comment" CssClass="btn btn-primary" />

</div>

</fieldset>

</form>

</body>

</html>

Default.aspx.cs code

using System;

using System.Linq;

using System.Data;

using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page

{

string constr = "Data Source=.;Initial Catalog=Test;uid=******;pwd=**********";

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

Getcomments();

}

private string Getxml(DataTable dt)

{

DataTable dtclone = dt.Clone();

foreach (DataColumn column in dtclone.Columns)

{

column.DataType = typeof(string);

}

foreach (DataRow row in dt.Rows)

{

dtclone.ImportRow(row);

}

foreach (DataRow row in dtclone.Rows)

{

for (int i = 0; i < dtclone.Columns.Count; i++)

{

dtclone.Columns[i].ReadOnly = false;

if (string.IsNullOrEmpty(row[i].ToString()))

{

row[i] = string.Empty;

}

else

{

row[i] = Convert.ToString(row[i]).Trim();

}

DataSet dsclone = new DataSet();

dsclone.Tables.Add(dtclone);

dsclone.DataSetName = "Comments";

dsclone.Tables[0].TableName = "Comment";

return dsclone.GetXml();

}

private void Getcomments(string loadtype = "L")

{

SqlDataAdapter da = new SqlDataAdapter("select CommentId,NAME,Comment from InsComment",constr);

DataSet ds = new DataSet();

da.Fill(ds);

if (ds != null)

{

if (ds.Tables.Count > 0)

{

if (ds.Tables[0].Rows.Count > 0)

{

lbltotcomment.Text = "Comments " + Convert.ToString(ds.Tables[0].Rows.Count);

var dt = ds.Tables[0];

if (loadtype == "L")

{

dt= ds.Tables[0].AsEnumerable()

.Where((r, i) => i >= dt.Rows.Count-1).CopyToDataTable();

}

string xml = Getxml(dt);

btnlink.Visible = true;

btnlinktop.Visible = true;

xmlContacts.DocumentContent = xml;

xmlContacts.TransformSource = Server.MapPath("~/XSLT/History.xslt");

}

else

{

lbltotcomment.Text = "Comments 0";

btnlink.Visible = false;

btnlinktop.Visible = false;

}

else

{

lbltotcomment.Text = "Comments 0";

btnlink.Visible = false;

}

protected void btnsavecomment_Click(object sender, EventArgs e)

{

try

{

using (SqlConnection connection = new SqlConnection(constr))

{

connection.Open();

SqlCommand myCommand = new SqlCommand("Insert into InsComment (NAME,Comment) values ('Varun',@Comment)", connection);

myCommand.Parameters.Add("@Comment", SqlDbType.VarChar, 500);

myCommand.Parameters["@Comment"].Value = txtcomment.Text.Trim();

myCommand.CommandType = CommandType.Text;

int res = myCommand.ExecuteNonQuery();

connection.Close();

if (res > 0)

{

txtcomment.Text = string.Empty;

Getcomments();

lblmsg.Text = "Save Successfully";

}

else

{

lblmsg.Text = "Data Not Saved";

}

catch (Exception ex)

{

lblmsg.Text = ex.Message.ToString();

}

protected void btnlinktop_Click(object sender, EventArgs e)

{

Getcomments();

btnlinktop.Enabled = false;

btnlink.Enabled = true;

}

protected void btnlink_Click(object sender, EventArgs e)

{

Getcomments("A");

btnlinktop.Enabled = true;

btnlink.Enabled = false;

}

OutPut

2 comments:

AnonymousOctober 22, 2018 at 1:30 PM
Whats up are using Wordpress for your site platform?
I'm new to the blog world but I'm trying to get started and set up my own. Do
you require any coding expertise to make your own blog?
Any help would be greatly appreciated!
AnonymousJanuary 4, 2019 at 8:53 AM
Hello, for all time i used to check blog posts here in the early hours in the break of day, because i love to gain knowledge of
more and more.

Tuesday, March 29, 2016

Comment Box in ASP.NET C#

2 comments: