Learn C# ASP.NET MVC WCF SQL Angular: March 2016

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

ADO	ADO.Net
Used connected data usage	Used disconnected data environment
Provided by record set	Provided by data set
Data is stored in binary format	Data is stored in XML format
It is COM based library	It is CLR based library
XML integration is not possible	XML integration is possible
ADO allows to create client-side cursors only	ADO.NET gives you the choice of either using client-side or server-side cursors
Join cannot be allow	Allow
Constraint cannot allow	Allow
Trigger cannot allow	Allow

Learn C# ASP.NET MVC WCF SQL Angular

Wednesday, March 30, 2016

What is the difference between ADO and ADO.Net?

Update multiple rows with different values SQL server

What is difference between Dispose and finalize method in c#?

Tuesday, March 29, 2016

Comment Box in ASP.NET C#