Archive
How to implement SQL Bulk Copy in SQL Server OR Bulk insert into SQL Server using SQL BulkCopy
SqlBulkCopy for insert multiple rows of data into table in SQL Server
Sometimes we need to insert bulk amount of data into a table in SQL. We can insert bulk data to SQL in different methods. Here we are going to demonstrate how to insert large amount of data using SQL Bulk Copy method.
Example of SQL BulkCopy method
Here we are going to insert multiple rows of sample data into Employee table. First of all create a table in SQL named Employee. After that create sample data for employee table and finally this multiple rows of employee data insert into table using SQL bulk copy method.
Create a Table in SQL
CREATE TABLE Employee ( ID INT, EmpName varchar(200), Department varchar(200), DOB DateTime );
SQLMulkCopy Example in SQL Server
C# Code to generate sample data and insertion using SQL Bulk Copy
private void loadDataBySQLBulkCopy()
{
DataTable dtTblEmployee = new DataTable();
dtTblEmployee.Columns.Add("ID", typeof(Int32));
dtTblEmployee.Columns.Add("EmpName", typeof(String));
dtTblEmployee.Columns.Add("Department", typeof(String));
dtTblEmployee.Columns.Add("DOB", typeof(DateTime));
DataRow dtrow = dtTblEmployee.NewRow(); // Create New Row
dtrow["ID"] = 1; //Bind Data to Columns
dtrow["EmpName"] = "Wazeem";
dtrow["Department"] = "Admin";
dtrow["DOB"] = "1990-10-16 12:00:00.000";
dtTblEmployee.Rows.Add(dtrow);
dtrow = dtTblEmployee.NewRow(); // Create New Row
dtrow["ID"] = 2; //Bind Data to Columns
dtrow["EmpName"] = "Aslam";
dtrow["Department"] = "HR";
dtrow["DOB"] = "1987-05-16 12:00:00.000";
dtTblEmployee.Rows.Add(dtrow);
dtrow = dtTblEmployee.NewRow(); // Create New Row
dtrow["ID"] = 3; //Bind Data to Columns
dtrow["EmpName"] = "John";
dtrow["Department"] = "Finance";
dtrow["DOB"] = "1992-12-11 12:00:00.000";
dtTblEmployee.Rows.Add(dtrow);
dtrow = dtTblEmployee.NewRow(); // Create New Row
dtrow["ID"] = 4; //Bind Data to Columns
dtrow["EmpName"] = "Mishal";
dtrow["Department"] = "Infra structure";
dtrow["DOB"] = "1989-04-01 12:00:00.000";
dtTblEmployee.Rows.Add(dtrow);
SqlBulkCopy bulkCopy = new SqlBulkCopy(
"server=TEST;database=TEST;uid=test;password=test",
SqlBulkCopyOptions.TableLock);
bulkCopy.DestinationTableName = "dbo.Employee";
bulkCopy.WriteToServer(dtTblEmployee);
}
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
How to create breadcrumbs in ASP.Net/C# OR Show Navigations for each pages in ASP.Net/C# OR How to implement Sitemap in ASP.Net
DOWNLOAD SOURCE CODE FOR BREADCRUMB EXAMPLE IN ASP.NET
What is breadcrumbs and what is the use of it?
Breadcrumbs typically appear horizontally across the top of a web page, often below title bars or headers. They provide links back to each previous page the user navigated through to get to the current page or-in hierarchical site structures-the parent pages of the current one. Breadcrumbs provide a trail for the user to follow back to the starting or entry point. A greater-than sign (>) often serves as hierarchy separator, although designers may use other glyphs <http://en.wikipedia.org/wiki/Glyph> (such as » or >), as well as various graphical treatments.
Typical breadcrumbs look like this:
Home page > Section page > Subsection page
How to implement breadcrumbs in ASP.Net/C# pages
In order to implement breadcrumbs in ASPX pages, we can use new pages called sitemaps. In ASP.NET the menu can be stored in a file to make it easier to maintain. This file is normally calledweb.sitemap, and is stored in the root directory of the web.
BREADCRUMB EXAMPLE IN ASP.NET
Example for implementing sitemaps in ASP.Net/C# pages
We are going to demonstrate sample ASP.Net application for implementing Breadcrumbs in ASPX pages. First of all create a new ASP.Net project and create three pages home.aspx, aboutus.aspx and contactus.aspx. Then create a sitemap file by “Add New item > SiteMap” and mention the hierarchy of the pages in the sitemaps as follows
<?xml version="1.0" encoding="utf-8" ?> <siteMap xmlns="http://schemas.microsoft.com/AspNet/SiteMap-File-1.0" > <siteMapNode url="Default.aspx" title="Home" description="Home Page"> <siteMapNode url="ContactUs.aspx" title="Contact US" description="Contact US Page" /> <siteMapNode url="About.aspx" title="About" description="About " > <siteMapNode url="AboutCompany.aspx" title="About Company" description="About Our Company" /> <siteMapNode url="AboutService.aspx" title="About Service" description="About Our Services" /> </siteMapNode> </siteMapNode> </siteMap>
Once we created sitemap and mentioned the hierarchy of the pages we need to map this sitemaps into all pages that we need to show navigation as follows.
<asp:SiteMapDataSource ID="SiteMapDataSource1" runat="server" /> <asp:SiteMapPath ID="SiteMap1" runat="server"> </asp:SiteMapPath>
Sample Application of Navigation Menu/Bread Crumbs
web.sitemap
<?xml version="1.0" encoding="utf-8" ?> <siteMap xmlns="http://schemas.microsoft.com/AspNet/SiteMap-File-1.0" > <siteMapNode url="Default.aspx" title="Home" description="Home Page"> <siteMapNode url="ContactUs.aspx" title="Contact US" description="Contact US Page" /> <siteMapNode url="About.aspx" title="About" description="About " > <siteMapNode url="AboutCompany.aspx" title="About Company" description="About Our Company" /> <siteMapNode url="AboutService.aspx" title="About Service" description="About Our Services" /> </siteMapNode> </siteMapNode> </siteMap>
About.aspx
<%@ Page Title="About Us" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeBehind="About.aspx.cs" Inherits="BreadCrumb.About" %> <asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent"> </asp:Content> <asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent"> <asp:SiteMapDataSource ID="SiteMapDataSource1" runat="server" /> <asp:SiteMapPath ID="SiteMap1" runat="server"> </asp:SiteMapPath> <h2> Welcome TO About US Page </h2> <br /> <a href="AboutCompany.aspx" runat="server">About Our Company</a> <br /> <a id="A1" href="AboutService.aspx" runat="server">About Our Services</a> </asp:Content>
Default.aspx
<%@ Page Title="Home Page" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="BreadCrumb._Default" %> <asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent"> <asp:SiteMapDataSource ID="SiteMapDataSource1" runat="server" /> </asp:Content> <asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent"> <asp:SiteMapPath ID="SiteMap1" runat="server"> </asp:SiteMapPath> <h2> Welcome to HOME PAGE </h2> </asp:Content>
AboutCompany.aspx
<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="AboutCompany.aspx.cs" Inherits="BreadCrumb.AboutCompany" %> <asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server"> </asp:Content> <asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server"> <asp:SiteMapDataSource ID="SiteMapDataSource1" runat="server" /> <asp:SiteMapPath ID="SiteMap1" runat="server"> </asp:SiteMapPath> <h2> This is the Page showing about our Company </h2> </asp:Content>
AboutService.aspx
<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true"
CodeBehind="AboutService.aspx.cs" Inherits="BreadCrumb.AboutService" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
<asp:SiteMapDataSource ID="SiteMapDataSource1" runat="server" />
<asp:SiteMapPath ID="SiteMap1" runat="server">
</asp:SiteMapPath>
<h2>
This is the Page showing about our Service
</h2>
</asp:Content>
-
DOWNLOAD SOURCE CODE FOR BREADCRUMB EXAMPLE IN ASP.NET
Site Viewers
Recent Comments