Difference between DELETE and TRUNCATE command

DELETE and TRUNCATE in SQL:

DELETE:

• Delete is a DML(Data manipulation language) command.
• DELETE statement only locks a row in table while performing DELETE operation.
• We can use WHERE clause. So that it deletes specified data by filtering with WHERE clause.
• DELETE activates a trigger. Because operation logs individually.
• Slower than TRUNCATE. because it keeps logs.
• Since DELETE keeps logs, Rollback is possible.

TRUNCATE:

• TRUNCATE is a DDL(Data Definition Language) command.
• TRUNCATE statement locks table and page, but not each row.
• Cannot use WHERE clause.
• No trigger activates. Since it doesn't log individually.
• Faster than DELETE in performance wise. Because, it doesn't keeps logs.
• Since it doesn't keeps logs, Rollback is not possible.

Binding Datatable to a Gridview in ASP.NET

How to Bind Datatable to Gridview in ASP.NET

This article will explain you about binding a data table to gridview in ASP.NET.......

Lets us assume we have got a Default.aspx web form and a Gridview called gvProducts in that web form.

Here is a sample code in code behind:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

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

{

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

BindProducts();

}

}

private void BindProducts()

{

DataTable tblProducts = new DataTable();

tblProducts.Columns.Add("Id", System.Type.GetType("System.Int32"));

tblProducts.Columns.Add("Name", System.Type.GetType("System.String"));

tblProducts.Columns.Add("Price", System.Type.GetType("System.Decimal"));

tblProducts.Columns.Add("Published", System.Type.GetType("System.Boolean"));

DataRow dr = tblProducts.NewRow();

dr["Id"] = "100";

dr["Name"] = "Apple";

dr["Price"] = "12.36";

dr["Published"] = "true";

tblProducts.Rows.Add(dr);

DataRow dr = tblProducts.NewRow();

dr["Id"] = "101";

dr["Name"] = "Orange";

dr["Price"] = "10.00";

dr["Published"] = "false";

tblProducts.Rows.Add(dr);

DataRow dr = tblProducts.NewRow();

dr["Id"] = "102";

dr["Name"] = "Banana";

dr["Price"] = "15.34";

dr["Published"] = "true";

tblProducts.Rows.Add(dr);

gvProducts.DataSource = tblProducts;

gvProducts.DataBind();

}

}