Archive
How to merge two data tables in ASP.Net/C# OR Merge 2 DataTables and store in a new one in ASP.Net/C#
Merge multiple data-tables data into a another data-table using C#/ASP.Net
Here we are going to demonstrate a sample application which shows merge two data tables in ASP.Net. In this sample we are having two data tables with some data and merge data of each tables data. We binds first data table to a data grid second one to another grid and third data grid binds with merged data table.

Merge data tables in C#/ASP.Net
ASPX Page for Example of merge two datatables in C#/ASP.Net
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="MergeDataTable.aspx.cs" Inherits="ExperimentLab.MergeDataTable" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> </head> <body> <form id="form1" runat="server"> <div> First DataTable <asp:GridView ID="gdDataTableOne" runat="server" /><br /> Second DataTable <asp:GridView ID="gdDataTableTwo" runat="server" /><br /> Merged DattaTable <asp:GridView ID="gdDataTableMergedData" runat="server" /><br /> </div> </form> </body> </html> -*******
CODE BEHIND Page for Merge datatable in C#/ASP.Net
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; namespace ExperimentLab { public partial class MergeDataTable : System.Web.UI.Page { DataTable dtOne = new DataTable(); DataTable dtTwo = new DataTable(); protected void Page_Load(object sender, EventArgs e) { fillDataTableOne(); fillDataTableTwo(); mergeDataTables(); } private void mergeDataTables() { dtOne.Merge(dtTwo, false); gdDataTableMergedData.DataSource = dtOne; gdDataTableMergedData.DataBind(); } private void fillDataTableOne() { dtOne.Columns.Add("EmpID", typeof(Int32)); dtOne.Columns.Add("EmployeeName", typeof(string)); dtOne.Columns.Add("Department", typeof(string)); dtOne.Columns.Add("City", typeof(string)); DataRow dtOnerow = dtOne.NewRow(); // Create New Row dtOnerow["EmpID"] = 1; //Bind Data to Columns dtOnerow["EmployeeName"] = "Ram"; dtOnerow["Department"] = "Admin"; dtOnerow["City"] = "Kochi"; dtOne.Rows.Add(dtOnerow); dtOnerow = dtOne.NewRow(); // Create New Row dtOnerow["EmpID"] = 2; //Bind Data to Columns dtOnerow["EmployeeName"] = "Mahesh"; dtOnerow["Department"] = "Finance"; dtOnerow["City"] = "Delhi"; dtOne.Rows.Add(dtOnerow); dtOnerow = dtOne.NewRow(); // Create New Row dtOnerow["EmpID"] = 3; //Bind Data to Columns dtOnerow["EmployeeName"] = "Raj"; dtOnerow["Department"] = "Admin"; dtOnerow["City"] = "Kolkata"; dtOne.Rows.Add(dtOnerow); dtOnerow = dtOne.NewRow(); // Create New Row dtOnerow["EmpID"] = 4; //Bind Data to Columns dtOnerow["EmployeeName"] = "Virbal"; dtOnerow["Department"] = "HR"; dtOnerow["City"] = "Mumbai"; dtOne.Rows.Add(dtOnerow); gdDataTableOne.DataSource = dtOne; gdDataTableOne.DataBind(); } private void fillDataTableTwo() { dtTwo.Columns.Add("EmpID", typeof(Int32)); dtTwo.Columns.Add("EmployeeName", typeof(string)); dtTwo.Columns.Add("Department", typeof(string)); dtTwo.Columns.Add("City", typeof(string)); DataRow dtTworow = dtTwo.NewRow(); // Create New Row dtTworow["EmpID"] = 5; //Bind Data to Columns dtTworow["EmployeeName"] = "John"; dtTworow["Department"] = "Delivery"; dtTworow["City"] = "Goa"; dtTwo.Rows.Add(dtTworow); dtTworow = dtTwo.NewRow(); // Create New Row dtTworow["EmpID"] = 6; //Bind Data to Columns dtTworow["EmployeeName"] = "Jacob"; dtTworow["Department"] = "Finance"; dtTworow["City"] = "Kolkata"; dtTwo.Rows.Add(dtTworow); dtTworow = dtTwo.NewRow(); // Create New Row dtTworow["EmpID"] = 7; //Bind Data to Columns dtTworow["EmployeeName"] = "Srini"; dtTworow["Department"] = "HR"; dtTworow["City"] = "Jaipur"; dtTwo.Rows.Add(dtTworow); dtTworow = dtTwo.NewRow(); // Create New Row dtTworow["EmpID"] = 8; //Bind Data to Columns dtTworow["EmployeeName"] = "Gopal"; dtTworow["Department"] = "InfraStructure"; dtTworow["City"] = "Chennai"; dtTwo.Rows.Add(dtTworow); gdDataTableTwo.DataSource = dtTwo; gdDataTableTwo.DataBind(); } } }
How to implement Password validation in ASP.Net/C# OR Implement Password strength using Jquery in ASP.Net
DOWNLOAD SOURCE CODE FOR PASSWORD STRENGTH CHECKER
How to show Password Strength image to user in ASP.Net
Register/change password pages on most of the application showing password strength information to user while entering password in the textbox. It allows to user to enter a strong password for register the pages. We can implement Password Strength Checker in different methods in ASP.Net application. Its better to do it in the client side itself so that user doesn’t feels post back in the page.
Implement Password Strength Checker using Jquery
Here we are going to demonstrate a sample application to implement Password Strength Checker using Jquery. The application shows the status of entered password by each alphabet changes in the textbox such as Week, Good, Strong etc..
ASPX/HTML Page for Password Strength Checker
<!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>jQuery Validation Plugin Password Extension demo</title> <link rel="stylesheet" type="text/css" media="screen" href="../jquery.validate.password.css" /> <script type="text/javascript" src="../lib/jquery.js"></script> <script type="text/javascript" src="../lib/jquery.validate.js"></script> <script type="text/javascript" src="../jquery.validate.password.js"></script> <script id="demo" type="text/javascript"> $(document).ready(function () { $("#register").validate(); $("#password").valid(); }); </script> <style> label, input { float: left; } input { margin-left: 1em; } label.error { display: none !important; } .password-meter { float: left; } </style> </head> <body> <form id="register"> <div> Password Strength Checker Demo Using JQuery.. powered by <a href="http://tuvian.con"> tuvian</a> </div> <br /> <br /> <label for="password"> Password:</label> <input class="password" name="password" id="password" /> <div class="password-meter"> <div class="password-meter-message"> </div> <div class="password-meter-bg"> <div class="password-meter-bar"> </div> </div> </div> </form> </body> </html>
DOWNLOAD SOURCE CODE FOR PASSWORD STRENGTH CHECKER
Recent Comments