AJAY HELP

What is the use of n-tier architecture and 3-tier architecture?

2016-09-22T16:52:00.006+05:30

how to implement 3-tier architecture in asp.net using c#. 3-Tier architecture is also called layered architecture. Some people called it n-tier architecture. Layer architectures are essentially objects and work in object oriented environment just like asp.net. 3-tier architecture is a very well known architecture in the world of software development, it doesn't matter whether you are developing web based application or desktop based, it is the best architecture to use.

3-Tier Architecture in asp.net using c#

3-Tier architecture consists of
1) UI or Presentation Layer
2) Business Access Layer or Business Logic Layer
3) Data Access Layer

Presentation Layer
Presentation layer consists of pages like .aspx or desktop based form where data is presented to users or getting input from users.

Business Logic layer or Business Access Layer
Business logic layer contains all of the business logic. Its responsibility is to validate the business rules of the component and communicating with the Data Access Layer. Business Logic Layer is the class in which we write functions that get data from Presentation Layer and send that data to database through Data Access Layer.

Data Access Layer
Data Access Layer is also the class that contains methods to enable business logic layer to connect the data and perform desired actions. These desired actions can be selecting, inserting, updating and deleting the data. DAL accepts the data from BAL and sends it to the database or DAL gets the data from the database and sends it to the business layer. In short, its responsibility is to communicate with the backend structure.

Check this article for 3-tier architecture 3 tier architecture example in asp.net

use and example of 3-tier architecture

Usable Things for Bootstrap

2016-06-16T11:35:00.000+05:30

Bootstrap css front-end framework.
jQuery fast, small, and feature-rich JavaScript library.
DataTables advanced interaction controls in any HTML table
DropzoneJS library that provides drag'n'drop file uploads with image previews
EasyPieChart plugin to render and animate nice pie charts with the HTML5 canvas element
Flot simple but powerful chart plugin
FullCalendar is a jQuery plugin that provides a full-sized, drag & drop calendar
Gritter Notification plugin
iCheck Custom radio and checkbox buttons
IonRangeSlider Easy and light range slider plugin
Jasny additional components for bootstrap framework.
Jeditable Edit In Place Plugin For jQuery
jQueryUI set of user interface interactions, effects, widgets, and themes built on top of the jQuery
bootstrapdatepicker datepicker
Chosen plugin that makes long, unwieldy select boxes much more user-friendly
jsKnob Nice, downward compatible, touchable, jQuery dial.
metisMenu Easy menu jQuery plugin for Twitter bootstrap
Morris.js good-looking charts library
nouislider Lightweight javascript range slider
Pace Automatic page load progress bar
Peity simple jQuery plugin that converts an element's content into a simple <svg> mini, pie, line or bar chart
Rickshaw toolkit for creating interactive time series graphs
Sparkline jQuery inline chart library
Steps smart UI component which allows you to easily create wizard-like interfaces
Summernote Super Simple WYSIWYG Editor on Bootstrap
Switchery simple component that turn default HTML checkbox inputs into iOS 7 style switches.
Validation jQuery Validation Plugin
jvectormap Java Script pluggin for vector maps
Unsplash all images from Unsplash - Free hi-resolution photos
UiFaces all avatar faces from UiFaces
UIrouter Angular solution to flexible routing with nested views
UICalendar Directive for FullCalendar
UIBootstrap Bootstrap directives for Angular
Knob jsKnob directive for angular
NgSwitchery Switchery input style for angular
AngularPeity Peity chart directive
NgEasyPieChart Easy Pie chart directive
AngularFlot Flot chart directive
AngularRickshaw Rickshaw chart directive
AngularSummernote Summernote directive for Angular
AngularNouiSlider NouiSlider directive for Angular
AngularDatapicker Data picker directive
AngularDatatables DataTables directive for Angular
AngularSelect Chosen plugin directive
AngularChartJS ChartJs directive for Angular
Nestable Nestable list jQuery plugin
codeMirror Code editor jQuery plugin
GoogleMapsApi Google maps API
EmailTemplate Transactional Email template
ngGrid NgGrid directive
uiTree Nestable list for AngularJS
uiCodeMirror Code Mirror directive
uiMap Google mpas directive
jqGrid jqGrid plugin for jQuery
ClassHelper Class helper
AnimatedHeader Animated header plugin
MockupMacBookPro MackBookPro mockup for Landing Page
BrowserWindow Chrome browser mockup for Landing Page
Timeline: Vertical timeline inspiration
iPhoneMockup iPhone mockup for Landing Page
iPhonePicture iPhone picture mockup for Landing Page
PerspectiveMockup Perspective iPad mockup for Landing Page
OpenSans Google Open Sans Web Font
ImageCrop: Plugin for image crop function
Toastr: Notification plugin
Notify: Angular native notification plugin
AngularColorPicker: Angular native color picker plugin
BootstrapColorPicker: jQuery color picker plugin
WOW: Animations for scroll down page
Meanjs: MEANJS full-stack JavaScript
LightboxGallery: touch-enabled, responsive and customizable image & video gallery
GulpGen: Angular Gulp generator
GruntGen: Angular Grunt generator
jsTree: jsTree is jquery plugin, that provides interactive trees
RTLbootstrap: Bootstrap RTL provides simple yet robust right-to-left capability for Bootstrap 3
AngularTranslate: Angular translate directive
ocLazyLoad: ocLazyLoad module for Angular
ngImgCrop: Image crop plugin for Angular
angularDiff: Angular wrapper around Google's diff_match_patch library
ngIdle: Angular idle timer
googleDiff: The Diff Match and Patch libraries offer robust algorithms to perform the operations required for synchronizing plain text.
tinycon: A small library for manipulating the favicon
idletimer: jQuery idle timer
spinners: A collection of loading indicators animated with CSS
uiSortable: AngularJS bindings for jQuery UI Sortable
meteor: Open-source platform for building top-quality web apps
ironRouter: A router that works on the server and the browser, designed specifically for Meteor
meteorDropZone: A Meteor package for the popular file picker
prettyTextDiff: A wrapper around Google's diff_match_patch library
clockPicker: Special clock picker
chartist: Javascript chart library
ngChartist: Directive for chartist in angularJS
dateRangePicker: Date range picker for Bootstra
ngDateRange: Angular directive for date range picker
awesomeBootstrapCheckbox: Custom checkbox and radio controls
fooTable: Table jQuery plugin
angularFootable: Angular directive for FooTable
sweetAlert: Custom javascript alerts
ngSweetAlert: Angular directive for SweetAlert
masonry: Cascading grid layout library
wuMasonry: Angular directive for Masonry
slick: Custom carousel feature
ngSlick: Angular directive for Slick
toaster: Angular directive for Toastr notification
select2: The jQuery replacement for select boxes
uiSelect: AngularJS-native version of Select2
i18next: i18next is a internationalization framework
ladda: Buttons with built-in loading indicators.
angularladda: Angular directive for Ladda
dotdotdot: jQuery.dotdotdot, advanced cross-browser ellipsis for multiple line content
touchspin: A mobile and touch friendly input spinner component for Bootstrap 3
ngTouchSpin: Angular directive for TuchSpin
tour: Quick and easy way to build your product tours with Bootstrap Popovers.
angularTour: Angular directive for Tour
flags: Sets of image flags
clipboard: Copy text to the clipboard library
ngClipboard: Angular directive for Clipboard
c3: D3-based charts
d3: JavaScript library for visualizing data with HTML, SVG, and CSS.
c3angular: Angular directive for c3
markdown: Bootstrap plugin for markdown editing.
ngTree: Angular directive for jsTree

how to use multiple versions of jquery on the same page

2016-04-28T13:30:00.000+05:30

Use `jQuery.noConflict()`:

<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js" type="text/javascript"></script>
<script>
    var $i = jQuery.noConflict();
    alert($i.fn.jquery);
</script> 

<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<script>
    var $j = jQuery.noConflict();
    alert($j.fn.jquery);
</script> 

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>
<script>
    var $k = jQuery.noConflict();
    alert($k.fn.jquery);
</script>

Avoid duplicate rows by keep same order in SQL Server

2016-02-26T12:05:00.002+05:30

I am looking for another solution for my sql query result.

My query below returns

SELECT 
    M.Mroutes_srno, M.Mroutes_loginid 
FROM
    Mroutes M
LEFT JOIN 
    MAccSanctioningLimit Limit ON M.mroutes_role = Limit.sac_type
                               AND M.Mroutes_moduleno = Limit.sac_moduleno
                               AND M.Mroutes_companycd = Limit.company_cd
WHERE
    M.mroutes_deptcd = 'BKAF'
    AND M.Mroutes_moduleno = 145
    AND M.mroutes_role NOT IN ('MIS', 'CFO', 'MD')

Output:

Mroutes_srno    Mroutes_loginid
--------------------------------
1   --------    AIJ1546
2   --------    BCS8021
3   --------    AIJ1546
4   --------    BCS8021
5   --------    venkatesh
6   --------    151N1636

But, after removing duplicate rows it result like below.

SELECT  
    M.Mroutes_loginid  
FROM
    Mroutes M
LEFT JOIN 
    MAccSanctioningLimit Limit ON M.mroutes_role = Limit.sac_type
                               AND M.Mroutes_moduleno = Limit.sac_moduleno
                               AND M.Mroutes_companycd = Limit.company_cd
WHERE 
    M.mroutes_deptcd = 'BKAF'
    AND M.Mroutes_moduleno = 145
    AND M.mroutes_role NOT IN ('MIS', 'CFO', 'MD')
GROUP BY
    M.Mroutes_loginid

Output:

Mroutes_loginid
---------------
151N1636
AIJ1546
BCS8021
venkatesh

I need to keep the query in same order.

Answer

You need to use row_number window function:

;WITH cte AS(
SELECT M.Mroutes_srno,
       M.Mroutes_loginid,
       ROW_NUMBER() OVER(PARTITION BY M.Mroutes_loginid ORDER BY M.Mroutes_srno) rn 
from Mroutes M
left JOIN MAccSanctioningLimit  Limit on M.mroutes_role =Limit.sac_type
    and  M.Mroutes_moduleno = Limit.sac_moduleno
    and M.Mroutes_companycd = Limit.company_cd
where M.mroutes_deptcd ='BKAF'
and M.Mroutes_moduleno =145
and M.mroutes_role NOT in ('MIS', 'CFO', 'MD'))

SELECT Mroutes_srno, Mroutes_loginid
FROM cte 
WHERE rn = 1
ORDER BY Mroutes_srno

Or you can order by aggregation like:

SELECT  M.Mroutes_loginid  
from Mroutes M
left JOIN MAccSanctioningLimit  Limit on M.mroutes_role =Limit.sac_type
    and  M.Mroutes_moduleno = Limit.sac_moduleno
    and M.Mroutes_companycd = Limit.company_cd
where M.mroutes_deptcd ='BKAF'
and M.Mroutes_moduleno = 145
and M.mroutes_role NOT in ('MIS', 'CFO', 'MD')
group by M.Mroutes_loginid
order by min(M.Mroutes_srno)

Do various things by JSON in ASP.net -3

2014-06-23T17:45:00.001+05:30

Do various things by JSON in ASP.net -3

Bind dropdown list by JSON

Form Source

<div>

<table>

<tr>

<asp:Label ID="Label4139" runat="server" ForeColor="Red" Text="*"></asp:Label>

<asp:Label ID="Label31" runat="server" Text="Region :"></asp:Label>

</td>

<asp:DropDownList ID="ddl_Region" runat="server" Style="min-width: 100px; max-width: 250px"

ValidationGroup="OISave">

<asp:ListItem Value="0">-Select-</asp:ListItem>

<asp:ListItem Value="1">AME</asp:ListItem>

<asp:ListItem Value="2">EMEA</asp:ListItem>

<asp:ListItem Value="3">INDIA</asp:ListItem>

<asp:ListItem Value="4">SEAP</asp:ListItem>

</asp:DropDownList>

<asp:RequiredFieldValidator ID="rfv_Region" runat="server" ControlToValidate="ddl_Region"

Display="Dynamic" ErrorMessage="Please Select Region" InitialValue="0" SetFocusOnError="True"

ValidationGroup="OISave">*</asp:RequiredFieldValidator>

</td>

</tr>

<tr>

<asp:Label ID="Label55" runat="server" Text="Country :"></asp:Label>

</td>

<asp:DropDownList ID="ddl_Country" runat="server" Style="min-width: 100px; max-width: 250px"

ValidationGroup="OISave">

</asp:DropDownList>

</td>

</tr>

</table>

</div>

SCRIPT

json2.js – Search on google for Jsfile

$(document).ready(function() {

$("#<%=ddl_Region.ClientID %>").change(function() {

BindCountry();

});

function BindCountry() {

var items = {};

items.vRegionCode = $("#<%=ddl_Region.ClientID %>").val();

$.ajax({

type: "POST",

url: "frmBidInformation.aspx/LoadCountryDetails",

data: '{items: ' + JSON.stringify(items) + '}',

contentType: "application/json; charset=utf-8",

dataType: "json",

async: false,

success: function(data) {

//alert(data.d);

$("#<%=ddl_Country.ClientID %> option").remove();

$.each(data.d, function(key, value) {

$("#<%=ddl_Country.ClientID %>").append($("<option></option>").val

(value.CountryCode).html(value.CountryName));

});

}

});

}

</script>

Code Behind

public class Country

{

public string CountryCode { get; set; }

public string CountryName { get; set; }

public string vRegionCode { get; set; }

}

[WebMethod]

public static List<Country> LoadCountryDetails(Country items)

{

DataTable dt_Country = new DataTable();

clsMaster objMaster = new clsMaster();

objMaster.vRegionCode = items.vRegionCode;

dt_Country = objMaster.FUN_FILL_COUNTRY_REGIONWISE();

List<Country> lstCountry = new List<Country>();

try

{

lstCountry.Add(new Country { CountryCode = "0", CountryName = "-Select-" });

if (dt_Country.Rows.Count > 0)

{

foreach (DataRow dr in dt_Country.Rows)

{

lstCountry.Add(new Country()

{

CountryCode = dr["con_code"].ToString(),

CountryName = dr["con_name"].ToString()

});

}

catch (Exception exp)

{

throw exp;

}

return lstCountry;

}

Do various things by JSON in ASP.net -2

2014-06-23T17:16:00.000+05:30

Do various things by JSON in ASP.net -2

Display records in GridView by JSON

Form Source

<asp:GridView ID="gv_Bid_Summary" runat="server" AutoGenerateColumns="False" Width="70%"

DataKeyNames="STTS" OnRowDataBound="gv_Bid_Summary_RowDataBound">

<asp:BoundField DataField="srNo" HeaderText="SR NO." ItemStyle-HorizontalAlign="Center">

</asp:BoundField>

<asp:TemplateField HeaderText="DETAILS">

<asp:HyperLink ID="hl_Category" runat="server" NavigateUrl="#" OnInit="hl_Category_Init">HyperLink</asp:HyperLink>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="STATUS">

<asp:Image ID="ImgFlag" runat="server" ImageUrl="" Height="10px" />

<asp:HiddenField ID="hf_isFinalized" Value='<%# Bind("nCount") %>' runat="server" />

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

<%--Add new Button to Bind grid --%>

<asp:Button ID="BtnViewSummary" runat="server" Style="height: 26px" Text="Save" ValidationGroup="pdSave" Width="80px" OnClientClick="Bid_Summary(); return false;" />

SCRIPT

json2.js – Search on google for Jsfile

function Bid_Summary() {

//alert('hi');

var items = {};

items.BidNo = $("#<%=hf_BNo.ClientID %>").val();

// debugger;

$.ajax({

type: "POST",

url: "frmBidInformation.aspx/BIND_FINALIZED_GRID",

data: '{items: ' + JSON.stringify(items) + '}',

contentType: "application/json; charset=utf-8",

dataType: "json",

success: function(data) {

//alert(data.d);

OnSuccess(data);

failure: function(response) {

alert("Failure : " + response.d);

error: function(response) {

alert("Error : " + response.d);

}

});

}

function OnSuccess(response) {

var xmlDoc = $.parseXML(response.d);

var xml = $(xmlDoc);

var users = xml.find("Table");

//create a new row from the last row of gridview

var row = $("[id*=gv_Bid_Summary] tr:last-child").clone(true);

//remove the lst row created by binding the dummy row from code behind on page load

$("[id*=gv_Bid_Summary] tr").not($("[id*=gv_Bid_Summary] tr:first-child")).remove();

var count = 1;

$.each(users, function() {

//var users = $(this);

$("td", row).eq(0).html($(this).find("srNo").text());

$("td", row).eq(1).html($(this).find("vLink").text());

if ($(this).find("STTS").text() == "T")

$("td", row).eq(2).html("<img src='../App_Themes/Images/yesstatus.gif' style='height:10px;border-width:0px;'/> <input id='hf_isFinalized" + count + "' name='hf_isFinalized' type='hidden' value='" + $(this).find("nCount").text() + "'/>");

else

$("td", row).eq(2).html("<img src='../App_Themes/Images/nostatus.GIF' style='height:10px;border-width:0px;'/> <input id='hf_isFinalized" + count + "' name='hf_isFinalized' type='hidden' value='" + $(this).find("nCount").text() + "' />");

$("[id*=gv_Bid_Summary]").append(row);

count = count + 1;

row = $("[id*=gv_Bid_Summary] tr:last-child").clone(true);

});

}

</script>

Code Behind

public class gvBind

{

public string BidNo { get; set; }

}

[WebMethod]

public static string BIND_FINALIZED_GRID(gvBind items)

{

clsFuncctionLib objFunLib = new clsFuncctionLib();

DataSet ds = new DataSet();

string strMessage = "";

objFunLib.objCon.Open();

objFunLib.objSqlCmd = new SqlCommand();

objFunLib.objSqlCmd.CommandType = CommandType.StoredProcedure;

objFunLib.objSqlCmd.Parameters.AddWithValue("@vBidNo", Convert.ToInt32(items.BidNo));

try

{

ds = clsDatabase.GetDataSet("PROC_GET_MENU_STATUS", objFunLib.objSqlCmd);

strMessage = ds.GetXml();

}

catch (Exception ex)

{

strMessage = ex.Message.ToString();

}

return strMessage;// iCount.ToString();

}

Do various things by JSON in ASP.net -1

2014-06-23T16:47:00.000+05:30

Do various things by JSON in ASP.net -1

Simply Add/Edit records by JSON

Form Design

Form Source

<div>

<table>

<tr>

<asp:Label ID="Label4143" runat="server" ForeColor="Red" Text="*"></asp:Label>

<asp:Label ID="Label1" runat="server" Text="RFQ Issue"></asp:Label>

</td>

<table>

<tr>

<td>

<asp:TextBox ID="txt_RFQIssue" runat="server" Width="81px" onkeydown="return false;"

onpaste="return false;"></asp:TextBox>

</td>

<td>

<asp:ImageButton ID="IB_RFQIssue" runat="server" ImageUrl="~/App_Themes/images/date.png" />

</td>

</tr>

</table>

</td>

</tr>

<tr>

<asp:Label ID="Label4144" runat="server" ForeColor="Red" Text="*"></asp:Label>

<asp:Label ID="Label4" runat="server" Text="Clarification Meeting"></asp:Label>

</td>

<table>

<tr>

<td>

<asp:TextBox ID="txt_ClarificationMeeting" runat="server" Width="81px" onkeydown="return false;"

onpaste="return false;"></asp:TextBox>

</td>

<td>

<asp:ImageButton ID="IB_ClarificationMeeting" runat="server" ImageUrl="~/App_Themes/images/date.png" />

</td>

</tr>

</table>

</td>

</tr>

<tr>

<asp:Label ID="Label4145" runat="server" ForeColor="Red" Text="*"></asp:Label>

<asp:Label ID="Label5" runat="server" Text="Tender Submission"></asp:Label>

</td>

<table>

<tr>

<td>

<asp:TextBox ID="txt_TenderSubmission" runat="server" Width="80px" onkeydown="return false;"

onpaste="return false;"></asp:TextBox>

</td>

<td>

<asp:ImageButton ID="IB_TenderSubmission" runat="server" ImageUrl="~/App_Themes/images/date.png" />

</td>

</tr>

</table>

</td>

</tr>

<tr>

<asp:Label ID="Label4146" runat="server" ForeColor="Red" Text="*"></asp:Label>

<asp:Label ID="Label36" runat="server" Text="Preferred Supplier chosen"></asp:Label>

</td>

<table>

<tr>

<td>

<asp:TextBox ID="txt_PreferredSupplierchosen" runat="server" Width="81px" onkeydown="return false;"

onpaste="return false;"></asp:TextBox>

</td>

<td>

<asp:ImageButton ID="IB_PreferredSupplierchosen" runat="server" ImageUrl="~/App_Themes/images/date.png" />

</td>

</tr>

</table>

</td>

</tr>

<tr>

 <asp:Button ID="BtnSaveIMPdate" runat="server" Style="height: 26px" Text="Save"

ValidationGroup="vgSave" Width="80px" OnClientClick="sendImpDates(); return false;" />

</td>

</tr>

</table>

</div>

SCRIPT

json2.js – Search on google for JSfile

function sendImpDates() {

vActiveIndex = 2;

var iCount = 0;

var iBidNo = 0;

//debugger;

var items = {};

items.BidNo = $("#<%=hf_BidNo.ClientID %>").val();

items.RFQIssue = $("#<%=txt_RFQIssue.ClientID %>").val();

items.ClarificationMeeting = $("#<%=txt_ClarificationMeeting.ClientID %>").val();

items.TenderSubmission = $("#<%=txt_TenderSubmission.ClientID %>").val();

items.PreferredSupplierchosen = $("#<%=txt_PreferredSupplierchosen.ClientID %>").val();

$.ajax({

type: "POST",

url: "frmBidInformation.aspx/Set_OpportunityTimelineDetails",

data: '{items: ' + JSON.stringify(items) + '}',

contentType: "application/json; charset=utf-8",

dataType: "json",

success: function(data) {

alert(data.d);

}

});

}

</script>

Code Behind

using System.Web.Script.Serialization;

using System.Web.Script.Services;

using System.Web.Security;

public class TimeDetails

{

public string BidNo { get; set; }

public string RFQIssue { get; set; }

public string ClarificationMeeting { get; set; }

public string TenderSubmission { get; set; }

public string PreferredSupplierchosen { get; set; }

}

[WebMethod]

public static string Set_OpportunityTimelineDetails(TimeDetails items)

{

clsFuncctionLib objFunLib = new clsFuncctionLib();

string strMessage;

objFunLib.objCon.Open();

objFunLib.objSqlCmd = new SqlCommand("PROC_UPDATE_DETAILS", objFunLib.objCon);

objFunLib.objSqlCmd.CommandType = CommandType.StoredProcedure;

objFunLib.objSqlCmd.Parameters.AddWithValue("@vBNo", items.BidNo);

if (items.RFQIssue != null)

objFunLib.objSqlCmd.Parameters.AddWithValue("@dtRFQIssue", items.RFQIssue);

else

objFunLib.objSqlCmd.Parameters.AddWithValue("@dtRFQIssue", null);

objFunLib.objSqlCmd.Parameters.AddWithValue("@dtMeetingClarification", items.ClarificationMeeting);

objFunLib.objSqlCmd.Parameters.AddWithValue("@dtTendorSubmission", items.TenderSubmission);

objFunLib.objSqlCmd.Parameters.AddWithValue("@dtPreferedSupplier", items.PreferredSupplierchosen);

objFunLib.objSqlCmd.Parameters.AddWithValue("@vUserID", HttpContext.Current.Session["vUserID"].ToString());

try

{

strMessage = objFunLib.objSqlCmd.ExecuteScalar().ToString();

}

catch (Exception ex)

{

strMessage = ex.Message;

}

if (strMessage == "1")

return "Record updated successfully";

else

return strMessage;

}

Export DataGridview To Excel

2014-02-28T13:52:00.003+05:30

See the code

References:

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using MySql.Data.MySqlClient;

using System.Configuration;

using System.IO;

Code for button for exporting to Excel

SaveFileDialog sfd = new SaveFileDialog();

sfd.Filter = "Excel Documents (*.xls)|*.xls";

sfd.FileName = "export.xls";

if (sfd.ShowDialog() == DialogResult.OK)

{

//ToCsV(dataGridView1, @"c:\export.xls");

ToCsV(dataGridView1, sfd.FileName); // Here dataGridview1 is your grid view name

}

Function for exporting to Excel:

private void ToCsV(DataGridView dGV, string filename)

{

string stOutput = "";

// Export titles:

string sHeaders = "";

for (int j = 0; j < dGV.Columns.Count; j++)

sHeaders = sHeaders.ToString() + Convert.ToString(dGV.Columns[j].HeaderText) + "\t";

stOutput += sHeaders + "\r\n";

// Export data.

for (int i = 0; i < dGV.RowCount - 1; i++)

{

string stLine = "";

for (int j = 0; j < dGV.Rows[i].Cells.Count; j++)

stLine = stLine.ToString() + Convert.ToString(dGV.Rows[i].Cells[j].Value) + "\t";

stOutput += stLine + "\r\n";

}

Encoding utf16 = Encoding.GetEncoding(1254);

byte[] output = utf16.GetBytes(stOutput);

FileStream fs = new FileStream(filename, FileMode.Create);

BinaryWriter bw = new BinaryWriter(fs);

bw.Write(output, 0, output.Length); //write the encoded file

bw.Flush();

bw.Close();

fs.Close();

}

Sample Database Class

2014-02-06T15:20:00.002+05:30

using System;

using System.Data;

using System.Configuration;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

/// <summary>

/// Class contains all Functions & Procedures, releated to execute Queries,SPs etc

/// </summary>

///

public class clsDatabase

{

#region Member variables

private static string _connString = System.Configuration.ConfigurationManager.ConnectionStrings["ICTConstr"].ConnectionString;

#endregion

#region Constructor

public clsDatabase()

{

}

#endregion

//Return Connection String

private static string ConnString

{

get

{

return _connString;

}

//Return SqlConnection

private static SqlConnection getConnection()

{

SqlConnection conn;

try

{

conn = new SqlConnection(ConnString);

}

catch

{

throw new Exception("SQL Connection String is invalid.");

}

return conn;

}

//Execute Stored Procedure And Returns Dataview

public static DataView GetSPDataView(string procedureName, SqlCommand command)

{

SqlConnection connection = getConnection();

DataSet ds = new DataSet();

SqlDataAdapter da = new SqlDataAdapter();

try

{

command.CommandTimeout = 2000;

command.CommandText = procedureName;

command.Connection = connection;

//Mark As Stored Procedure

command.CommandType = CommandType.StoredProcedure;

da.SelectCommand = command;

da.Fill(ds);

}

catch (Exception ex)

{

throw ex;

}

finally

{

command.Connection.Close();

command.Connection.Dispose();

command.Dispose();

if (connection.State == ConnectionState.Open) connection.Close();

}

return ds.Tables[0].DefaultView;

}

//Execute Query And Returns Dataview

public static DataView GetDataView(string sqlQuery)

{

SqlConnection connection = getConnection();

DataSet ds = new DataSet();

SqlDataAdapter da = new SqlDataAdapter();

DataView dv = new DataView();

try

{

da = new SqlDataAdapter(sqlQuery, connection);

da.Fill(ds);

dv.Table = ds.Tables[0];

}

catch (Exception ex)

{

throw ex;

}

finally

{

if (connection.State == ConnectionState.Open) connection.Close();

}

return dv;

}

//Execute Stored Procedure And Returns Datatable

public static DataTable GetDataTable(string procedureName, SqlCommand command, string tableName)

{

SqlConnection connection = getConnection();

SqlDataAdapter da = new SqlDataAdapter();

DataTable dt = new DataTable();

try

{

command.CommandText = procedureName;

command.Connection = connection;

command.CommandType = CommandType.StoredProcedure;

da.SelectCommand = command;

da.Fill(dt);

dt.TableName = tableName;

}

catch (Exception ex)

{

throw ex;

}

finally

{

command.Connection.Close();

command.Connection.Dispose();

command.Dispose();

if (connection.State == ConnectionState.Open) connection.Close();

}

return dt;

}

//Execute Query And Returns Datatable

public static DataTable GetDataTable(string strSQL)

{

SqlConnection connection = getConnection();

SqlDataAdapter da = new SqlDataAdapter(strSQL, connection);

DataTable dt = new DataTable();

try

{

da.Fill(dt);

}

catch (Exception ex)

{

throw ex;

}

finally

{

if (connection.State == ConnectionState.Open) connection.Close();

}

return dt;

}

public static DataTable GetDataTable(SqlCommand objParaCmd)

{

SqlConnection connection = getConnection();

SqlDataAdapter objDA = new SqlDataAdapter();

DataTable objDtb = new DataTable();

SqlCommand Cmd = new SqlCommand();

try

{

Cmd = objParaCmd;

connection.Open();

objParaCmd.Connection = connection;

objDA.SelectCommand = Cmd;

objDA.Fill(objDtb);

return objDtb;

}

catch (Exception Ex)

{

throw Ex;

}

finally

{

objParaCmd.Connection.Close();

objParaCmd.Connection.Dispose();

objParaCmd.Dispose();

if (connection.State == ConnectionState.Open) connection.Close();

}

//Execute Stored Procedure And Returns Datareader

public static SqlDataReader GetDataReader(string procedureName, SqlCommand command)

{

SqlConnection connection = getConnection();

SqlDataReader dr = null;

try

{

command.CommandText = procedureName;

command.Connection = connection;

//Mark As Stored Procedure

command.CommandType = CommandType.StoredProcedure;

connection.Open();

dr = command.ExecuteReader(CommandBehavior.CloseConnection);

}

catch (Exception ex)

{

throw ex;

}

return dr;

}

//Execute Query AND Returns Datareader

public static SqlDataReader GetDataReader(string Query)

{

SqlConnection connection = getConnection();

SqlCommand command=new SqlCommand ();

SqlDataReader dr = null;

try

{

command.CommandText = Query;

command.Connection = connection;

command.CommandType = CommandType.Text ;

connection.Open();

dr = command.ExecuteReader(CommandBehavior.CloseConnection);

}

catch (Exception ex)

{

throw ex;

}

return dr;

}

//Execute SQL Query & Doesn't Return Anything

public static void ExecuteNonQuery(string strSQL)

{

SqlConnection connection = getConnection();

connection.Open();

SqlCommand command = new SqlCommand();

try

{

command.CommandType = CommandType.Text;

command.Connection = connection;

command.CommandText = strSQL;

command.ExecuteNonQuery();

}

catch (Exception ex)

{

throw ex;

}

finally

{

command.Connection.Close();

command.Connection.Dispose();

command.Dispose();

if (connection.State == ConnectionState.Open) connection.Close();

}

public static int ExecuteNonQuery(string procedureName, SqlCommand command)

{

SqlConnection connection = getConnection();

connection.Open();

try

{

command.CommandType = CommandType.StoredProcedure;

command.CommandText = procedureName;

command.Connection = connection;

command.ExecuteNonQuery();

return 1;

}

catch (Exception ex)

{

throw ex;

}

finally

{

command.Connection.Close();

command.Connection.Dispose();

command.Dispose();

if (connection.State == ConnectionState.Open) connection.Close();

}

//Execute SP & Return Nothing

public static int ExecuteNonQuerySP(string procedureName, SqlCommand command)

{

SqlConnection connection = getConnection();

connection.Open();

try

{

command.CommandType = CommandType.StoredProcedure;

command.CommandText = procedureName;

command.Connection = connection;

command.ExecuteNonQuery();

//return Convert.ToInt32(command.Parameters["@nErrorCode"].Value);

return Convert.ToInt16(command.Parameters["@vMessage"].Value);

}

catch (Exception ex)

{

throw ex;

}

finally

{

command.Connection.Close();

command.Connection.Dispose();

command.Dispose();

if (connection.State == ConnectionState.Open) connection.Close();

}

public static string[] ExecuteNonQuerySP_CG(string procedureName, SqlCommand command,int iDiv)

{

string[] strReturn = new string[2];

SqlConnection connection = getConnection();

connection.Open();

try

{

command.CommandType = CommandType.StoredProcedure;

command.CommandText = procedureName;

command.Parameters.Add("@iDivision", SqlDbType.SmallInt);

command.Parameters["@iDivision"].Value = iDiv;//Convert.ToInt16(clsAppSession.SessionDivisionId);

command.Parameters.Add("@dtFinYearStart", SqlDbType.SmallDateTime);

command.Parameters["@dtFinYearStart"].Value = Convert.ToDateTime(clsAppSession.SessionFYrFromDate);

command.Parameters.Add("@dtFinYearEnd", SqlDbType.SmallDateTime);

command.Parameters["@dtFinYearEnd"].Value = Convert.ToDateTime(clsAppSession.SessionFYrToDate);

command.Parameters.Add("@vFlag", SqlDbType.VarChar, 10);

command.Parameters["@vFlag"].Direction = ParameterDirection.Output;

command.Parameters.Add("@vMessage", SqlDbType.VarChar, 100);

command.Parameters["@vMessage"].Direction = ParameterDirection.Output;

command.Connection = connection;

command.ExecuteNonQuery();

//return Convert.ToInt32(command.Parameters["@nErrorCode"].Value);

strReturn[0] = command.Parameters["@vFlag"].Value.ToString();

strReturn[1] = command.Parameters["@vMessage"].Value.ToString();

return strReturn;

}

catch (Exception ex)

{

throw ex;

}

finally

{

command.Connection.Close();

command.Connection.Dispose();

command.Dispose();

if (connection.State == ConnectionState.Open) connection.Close();

}

//Procedure to Execute Scalar

public static object ExecuteScalar(string strSQL)

{

SqlConnection connection = getConnection();

connection.Open();

SqlCommand command = new SqlCommand();

try

{

command.Connection = connection;

command.CommandType = CommandType.Text;

command.CommandText = strSQL;

return command.ExecuteScalar();

}

catch (Exception ex)

{

throw ex;

}

finally

{

command.Connection.Close();

command.Connection.Dispose();

command.Dispose();

if (connection.State == ConnectionState.Open) connection.Close();

}

//Execute SQL Query & Return Single Value

public static object ReturnSingleValue(string strSQL, Boolean blnNumericFlag)

{

object objRetVal;

string strRetVal = "";

SqlConnection connection = getConnection();

connection.Open();

SqlCommand command = new SqlCommand();

try

{

command.Connection = connection;

command.CommandType = CommandType.Text;

command.CommandText = strSQL;

objRetVal = command.ExecuteScalar();

if (blnNumericFlag == true)

{

strRetVal = Convert.ToString(objRetVal);

}

else

{

strRetVal = (string)(objRetVal);

}

return strRetVal;

}

catch (Exception ex)

{

throw ex;

}

finally

{

command.Connection.Close();

command.Connection.Dispose();

command.Dispose();

if (connection.State == ConnectionState.Open) connection.Close();

}

//Execute Query And Returns DataSet

public static DataSet GetDataSet(string procedureName, SqlCommand command)

{

SqlConnection connection = getConnection();

DataSet ds = new DataSet();

SqlDataAdapter da = new SqlDataAdapter();

try

{

command.CommandTimeout = 2000;

command.CommandText = procedureName;

command.Connection = connection;

//Mark As Stored Procedure

command.CommandType = CommandType.StoredProcedure;

da.SelectCommand = command;

da.Fill(ds);

}

catch (Exception ex)

{

throw ex;

}

finally

{

command.Connection.Close();

command.Connection.Dispose();

command.Dispose();

if (connection.State == ConnectionState.Open) connection.Close();

}

return ds;

}

Avoid submit event Refresh in Asp.net

2013-11-02T13:30:00.001+05:30

'Declare variables for use

Private _refreshState As Boolean

Private _isRefresh As Boolean

'Functions to Use

#Region " ISREFRESH "

Protected Overrides Sub LoadViewState(ByVal savedState As Object)

Dim AllStates As Object() = savedState

MyBase.LoadViewState(AllStates(0))

_refreshState = Boolean.Parse(AllStates(1))

_isRefresh = _refreshState = Session("__ISREFRESH")

End Sub

Protected Overrides Function SaveViewState() As Object

Session("__ISREFRESH") = _refreshState

Dim AllStates() As Object = New Object(2) {}

AllStates(0) = MyBase.SaveViewState

AllStates(1) = Not (_refreshState)

Return AllStates

End Function

#End Region

'Call function in Button Click Event

Protected Sub btnLogin_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles btnLogin.Click

If _isRefresh = True Then

Exit Sub

End If

End Sub

How to Save and Retrieve File in SQL Server Table

2013-08-19T14:06:00.003+05:30

1.) Design

Save and Retrieve File in SQL Table :
Select File To Upload :
File ID to Download :

2.) Table

ID	FileName	Extension	Content
1	ShowMIS_BODRptS	.PDF	<Binary data>
2	a.xls	.xls	<Binary data>
3	test.txt	.txt	<Binary data>
4	test.sql	.sql	<Binary data>
5	ShowMIS_BODRptS	.pdf	<Binary data>

3.) Code

using System;

using System.Data;

using System.Configuration;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

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

{

string ConnString = "Data Source=MySource;Initial Catalog=db_Test; user id=MyId;pwd=MyPWD; Connect Timeout=200000;";

protected void Page_Load(object sender, EventArgs e)

{

/* -- *IMP* ----

* Before Save and Retrieve files, Create Following table and Sp's in ur DATABASE

CREATE TABLE [TestTable]

(

[ID] [int] IDENTITY(1,1) NOT NULL,

[FileName] [nvarchar](15) NOT NULL,

[Extension] [nvarchar](5) NOT NULL,

[Content] [image] NULL

)

-------------------------------------

Create Proc InsertFile

@FileName nvarchar(15) ,

@Extension nvarchar(5) ,

@Content image

Insert INTO TestTable

( [FileName],Extension ,Content )

VALUES

(@FileName ,@Extension ,@Content)

--------------------------------------

---- GetFile 1

CREATE Proc GetFile

@FileID int

Select FileName ,Extension ,Content from TestTable where ID=@FileID

}

protected void BtnSave_Click(object sender, EventArgs e)

{

try

{

if (FileUpload1.HasFile == true)

{

byte[] FileByte = new byte[FileUpload1.FileContent.Length];

FileByte = FileUpload1.FileBytes;

string Ext="." + FileUpload1.FileName.Substring(FileUpload1.FileName.LastIndexOf('.') + 1);

using (SqlConnection cnn = new SqlConnection(ConnString))

{

cnn.Open();

SqlCommand cmd = new SqlCommand("InsertFile", cnn);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.Add(new SqlParameter("@FileName", FileUpload1.FileName));

cmd.Parameters.Add(new SqlParameter("@Extension", Ext));

cmd.Parameters.Add(new SqlParameter("@Content", FileByte));

cmd.ExecuteNonQuery();

cnn.Close();

}

catch (Exception ex)

{

Response.Write(ex.Message);

}

protected void BtnGet_Click(object sender, EventArgs e)

{

try

{

if (txtFileID.Text.Length > 0)

{

DataSet ds = new DataSet();

using (SqlConnection cnn = new SqlConnection(ConnString))

{

SqlDataAdapter da = new SqlDataAdapter("GetFile " + txtFileID.Text + "", cnn);

cnn.Open();

da.Fill(ds);

cnn.Close();

}

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

{

string strFilename = ds.Tables[0].Rows[0]["FileName"].ToString();

string strExtenstion = ds.Tables[0].Rows[0]["Extension"].ToString();

Byte[] bytFile = (Byte[])ds.Tables[0].Rows[0]["Content"];

strFilename = strFilename + "" + strExtenstion;

Response.Clear();

Response.Buffer = true;

if (strExtenstion.ToLower() == ".doc" || strExtenstion == ".docx")

{

Response.ContentType = "application/vnd.ms-word";

Response.AddHeader("content-disposition", "attachment;filename=" + strFilename);

}

else if (strExtenstion.ToLower() == ".xls" || strExtenstion == ".xlsx")

{

Response.ContentType = "application/vnd.ms-excel";

Response.AddHeader("content-disposition", "attachment;filename=" + strFilename);

}

else if (strExtenstion.ToLower() == ".pdf")

{

Response.ContentType = "application/pdf";

Response.AddHeader("content-disposition", "attachment;filename=" + strFilename);

}

else

{

Response.ContentType = "application/" + ds.Tables[0].Rows[0]["Extension"].ToString();

Response.AddHeader("content-disposition", "attachment;filename=" + strFilename);

}

Response.Charset = "";

Response.Cache.SetCacheability(HttpCacheability.NoCache);

// If you write,

// Response.Write(bytFile1);

// then you will get only 13 byte in bytFile.

Response.ContentType = "application/octet-stream";

Response.BinaryWrite(bytFile);

Response.Flush();

Response.End();

}

catch (Exception ex)

{

Response.Write(ex.Message);

}

LINQ to SQL: Basic Concepts and Features

2013-06-19T11:58:00.002+05:30

By : Mike_Liu,

Ref : http://www.codeproject.com/Articles/215712/LINQ-to-SQL-Basic-Concepts-and-Features

In this article we will see how to use LINQ to interact with a SQL Server database, or in other words, how to use LINQ to SQL in C#.

In this article, we will cover the basic concepts and features of LINQ to SQL, which include:

What is ORM
What is LINQ to SQL
What is LINQ to Entities
Comparing LINQ to SQL with LINQ to Objects and LINQ to Entities
Modeling the Northwind database in LINQ to SQL
Querying and updating a database with a table
Deferred execution
Lazy loading and eager loading
Joining two tables
Querying with a view

Use above (Ref) link to to read article.

All Browser Supporting Tag for Asp.net Website

2013-06-11T10:08:00.004+05:30

Below code paste in Head section of the Page

</head>

Add Below code in File (VB) of Page

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

If Request.UserAgent.IndexOf("AppleWebKit") > 0 Then

Request.Browser.Adapters.Clear()

End If

End Sub

Protected Overrides Sub AddedControl(ByVal control As Control, ByVal index As Integer)

' This is necessary because Safari and Chrome browsers don't display the Menu control correctly.

' Add this to the code in your master page.

If Request.ServerVariables("http_user_agent").IndexOf("Safari", StringComparison.CurrentCultureIgnoreCase) <> -1 Then

Me.Page.ClientTarget = "uplevel"

End If

MyBase.AddedControl(control, index)

End Sub

JSON Tutorial

2013-05-30T16:34:00.001+05:30

JSON Tutorial

JSON or JavaScript Object Notation, is a text-based open standard designed for human-readable data interchange. It is derived from the JavaScript scripting language for representing simple data structures and associative arrays, called objects. Despite its relationship to JavaScript, it is language-independent, with parsers available for many languages. The JSON format is often used for serializing and transmitting structured data over a network connection. It is used primarily to transmit data between a server and web application, serving as an alternative to XML.

Example: How to send JSON data to Web method i.e. ‘GetData’

1) create New website in visual studio

2) Write Below code In java script as function

function SendData() {

var jsonObjects = {

"items": [

{

"compId": "1","formId": "531"

{

"compId": "5","formId": "77"

{

"compId": "8","formId": "89"

}

]

};

$.ajax({

url: "Default.aspx/GetData",

data: JSON.stringify(jsonObjects),

dataType: "json",

type: "POST",

contentType: "application/json; charset=utf-8",

dataFilter: function(data) { return data; },

success: function(data) {

alert(data.d);

error: function(XMLHttpRequest, textStatus, errorThrown) {

alert(XMLHttpRequest.responseText);

}

});

}

3) Now add new Button to call Method and send data to serverside

<asp:Button ID="Button4" runat="server" Text="Send JSON Data in Object(s)" OnClientClick="SendData();return false;" />

4) Import this libraries

using System.Collections.Generic;

using System.Web.Script.Serialization;

using System.Web.Services;

using System.Web.Script.Services;

using System.Web.Security;

5) Use this method to accept Json data and save it to RDBMS

[WebMethod]

public static string GetData(object items)

{

//SINGLE OBJECT SAVE DATA

List<object> lstItems = new JavaScriptSerializer().ConvertToType<List<object>>(items);

//now we can Acces lstItems values

return "Send Data successfully." ;

}

Calculate GridView total using JavaScript / JQuery

2013-05-29T10:10:00.001+05:30

Here is the code, both ASPX and the JQuery code.

The ASPX

    <asp:TemplateField>   

        <ItemTemplate>    

            <asp:TextBox ID="TextBox1" class="calculate" onchange="calculate()" runat="server" Text="0"></asp:TextBox>   

        </ItemTemplate>

    </asp:TemplateField>

The code is similar as previously. Only now we have addedd class=”calculate” to the TextBox in order to perform JQuery manipulation to all the textboxes with class=”calculate” (all textboxes will have class calculate, no matter of the number of textboxes inside the gridview, which will make easier to find and manipulate with them using JQuery).

The JQuery code:

    <script src="http://ajax.microsoft.com/ajax/jquery/jquery-1.4.2.min.js" type="text/javascript"></script>

    <script language="javascript" type="text/javascript">

        function calculate() {

            var txtTotal = 0.00;

            //var passed = false;

            //var id = 0;

            $(".calculate").each(function (index, value) {

                var val = value.value;

                val = val.replace(",", ".");

                txtTotal = MathRound(parseFloat(txtTotal) + parseFloat(val));

            });

            document.getElementById("<%=total.ClientID %>").value = txtTotal.toFixed(2);          

        }

        function MathRound(number) {

            return Math.round(number * 100) / 100;

        }

    </script>

Using this JQuery each function, we can easily iterate trough all html objects containing the class name calculate, which in our case are the text boxes.

That’s it.

Ref: http://weblogs.asp.net/hajan/archive/2010/08/27/calculating-gridview-total-using-javascript-jquery.aspx

Get Next Number with REPLICATE In SQL Server

2013-03-30T17:52:00.000+05:30

Get Next max value for custom identification of table value

SELECT 'PR' + Substring( '2012-2013', 3, 2 )
       + Replicate('0', 4-Len(Count(*)+1))
       + Cast(Count(*)+1 AS VARCHAR(4)) AS NewCode
FROM   tablename
WHERE  pro_finyear = '2012-2013'

OUTPUT
=================

NewCode
PR120012

Jquery animation cutting Ribbon with scissors

2013-03-09T17:11:00.000+05:30

<body>
<form id="form1" runat="server">
<img class="RibbonL" src="Images/LeftRibbon.png" />
<img class="RibbonR" src="Images/RightRibbon.png" />
<img id="imgFollow" style="position: relative;" class="imgFollow" width="145px" height="145px" src="Images/scissors.png" />
<script src="jquery-1.6.2.min.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function () {

$(document).mousemove(function (e) {
$('#imgFollow').offset({
left: e.pageX + 30,
top: e.pageY - 20
});
$('#imgFollow').css('z-index', '1000');

});

$(".RibbonR, .RibbonL ").click(function () {
$(".RibbonL").hide(1000);
$(".RibbonR").hide(1000);

setTimeout(function () { //redirect after a certain time
$(window.location).attr('href', 'http://itapps.cgglobal.com/cgict/');
}, 1200);
});

});
</script>
</form>
</body>

How to fix Column of Gridview or scrollable grid in Asp.net

2012-12-07T14:58:00.000+05:30

Jquery plugin js file for scrollable grid

=========================================================

1. ScrollableGridPlugin.js

(function ($) {

$.fn.Scrollable = function (options) {

var defaults = {

ScrollHeight: 300,

Width: 0

};

var options = $.extend(defaults, options);

return this.each(function () {

var grid = $(this).get(0);

var gridWidth = grid.offsetWidth;

var gridHeight = grid.offsetHeight;

var headerCellWidths = new Array();

for (var i = 0; i < grid.getElementsByTagName("TH").length; i++) {

headerCellWidths[i] = grid.getElementsByTagName("TH")[i].offsetWidth;

}

grid.parentNode.appendChild(document.createElement("div"));

var parentDiv = grid.parentNode;

var table = document.createElement("table");

for (i = 0; i < grid.attributes.length; i++) {

if (grid.attributes[i].specified && grid.attributes[i].name != "id") {

table.setAttribute(grid.attributes[i].name, grid.attributes[i].value);

}

table.style.cssText = grid.style.cssText;

table.style.width = gridWidth + "px";

table.appendChild(document.createElement("tbody"));

table.getElementsByTagName("tbody")[0].appendChild(grid.getElementsByTagName("TR")[0]);

var cells = table.getElementsByTagName("TH");

var gridRow = grid.getElementsByTagName("TR")[0];

for (var i = 0; i < cells.length; i++) {

var width;

if (headerCellWidths[i] > gridRow.getElementsByTagName("TD")[i].offsetWidth) {

width = headerCellWidths[i];

}

else {

width = gridRow.getElementsByTagName("TD")[i].offsetWidth;

}

cells[i].style.width = parseInt(width - 3) + "px";

gridRow.getElementsByTagName("TD")[i].style.width = parseInt(width - 3) + "px";

}

parentDiv.removeChild(grid);

var dummyHeader = document.createElement("div");

dummyHeader.appendChild(table);

parentDiv.appendChild(dummyHeader);

if (options.Width > 0) {

gridWidth = options.Width;

}

var scrollableDiv = document.createElement("div");

if (parseInt(gridHeight) > options.ScrollHeight) {

gridWidth = parseInt(gridWidth) + 17;

}

scrollableDiv.style.cssText = "overflow:auto;height:" + options.ScrollHeight + "px;width:" + gridWidth + "px";

scrollableDiv.appendChild(grid);

parentDiv.appendChild(scrollableDiv);

});

};

})(jQuery);

=========================================================

2. Default page with GridView

$(document).ready(function () {

$('#<%=gridview1.ClientID %>').Scrollable({

ScrollHeight: 300

});

</script>

=========================================================

Some Jquery Plugins

2012-11-30T15:06:00.002+05:30

Move things around
redhq.com/projects/roundabout/

http://www.tripwiremagazine.com/2012/11/jquery-slider.html

http://www.jqueryrain.com/

http://www.uize.com/examples/3d-rotation-viewer.html

http://www.moretechtips.net/2012/11/18-most-popular-jquery-plugins-of.html

http://www.instantshift.com/2012/03/26/80-useful-jquery-plugins-to-enrich-your-sites-user-experience/

Session Expired Alert in Jquery

2012-11-28T11:22:00.000+05:30

Click below link
http://www.erichynds.com/jquery/creating-a-mint-com-style-idle-logout-timer-using-jquery/

My Login Page

2012-11-26T16:12:00.000+05:30

I have create login page by altering in PSD file

-------------------------------------

=================================================================
1) In aspx page ................................................

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>:: Login::</title>
<meta content='text/html; charset=iso-8859-1' http-equiv='Content-type' />
<meta content='width=330, height=370, initial-scale=1' name='viewport' />
<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" />
<link href="App_Themes/ThemeMBR/Login.css" rel="stylesheet" type="text/css" media="screen" />
</head>
<body style='min-height:410px'>
<div class='layout' id='page'>
<div class='centered'>
<div class='column' style='margin-top: -174px'>
<div class='logo'>
</div>
<div class='login_page preserve_links'>
<%--<div class='title_graphic'>
</div>--%><form id ="form1" runat ="server" method="post">
<div class='login_frame flexible'>
<div class='top'>
</div>
<div class='middle'>
<div class='flash_message'>
<div class='flash_boxes'>
</div>
</div>

<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<div >
<asp:UpdatePanel ID="UpdatePanel1" runat ="server" UpdateMode="Conditional"> <ContentTemplate>
<div style="margin: 0; padding: 0">
<input name="authenticity_token" type="hidden" value="0FFQCNT1hU4oSXJoS1ZQbrd2kvl1iuYk5y6rsm5H9e0=" /></div>
<div class='field text_field'>
<label for="email">
Login Id</label>
</div>
<div class='another_row'>
<%--<input class="autotab behavior" id="email" name="email" tabindex="1" type="text" />--%>
<asp:TextBox CssClass="autotab behavior" ID="txtUN" runat="server" MaxLength="100" ></asp:TextBox>
</div>
<div class='field text_field'>
<label for="password">
Password</label>
<span>   </span>
<%--<a href="../users/forgot_password-from_openid=false.htm">Forgot password?</a>--%>

</div>
<div class='one_more_row'>
<%--<input id="password" name="password" tabindex="2" type="password" value="" />--%>
<asp:TextBox ID="txtPwd" TextMode="Password" runat="server" Columns="50" MaxLength="20"></asp:TextBox>
</div>
<%-- <div class='remember_me_field'>
<div class='field check_box_field'>
<input id="remember_me" name="remember_me" type="checkbox" value="1" />
<label for="remember_me" style="display: inline">
Stay signed in</label>
</div>
</div>--%> <br />
<div class='actions'>
<div class="right gistsubmit" onclick="document.getElementById("loading_spinner").style.display = "inline";" style="left: 195px; top: 0px;">
<asp:Button CssClass="commit" ID="btnLogin" runat="server" Text="Log In"/>
<span></span>
</div><img alt="Sm_loader" class="right" id="loading_spinner" src="images/loaders/sm_loader.gif"
style="margin-top: 13px; display: none; position: absolute; margin-left: 80px;" />

<div class="clear">

</div><asp:Label ID="lblmsg" runat="server" ForeColor="Red" Text="Label" Visible="False"></asp:Label>

</div>

<%--<asp:HyperLink ID="hplRegMe" runat="server" NavigateUrl="~/FAAP/GeneralMasters/frmRegMe.aspx?ID=0" Text="New User Registration"></asp:HyperLink><br />
<asp:HyperLink ID="HPLHelp" runat="server" NavigateUrl="~/FAAP/GeneralMasters/frmHelp.aspx" Text="Help"></asp:HyperLink>--%>
</ContentTemplate></asp:UpdatePanel></div>

</div>
<div class='bottom'>
<asp:LinkButton ID="lnkforgotpassword" class='forgotpass' runat="server">Forgot Password</asp:LinkButton>
</div>
</div> </form>
</div>

<script src="../javascripts/pages/login_page.js-13955a3339.htm" type="text/javascript"></script>

</div>
</div>
</div>

</body>
</html>

====================================================================

2) Login.css ...........................................................

p {
margin-bottom: 10px;
line-height: 1.5em; }

ul {
margin: 0;
padding: 0 0 8px 0;
list-style: none;
padding: 0 0 16px 40px; }
ul.bulleted {
list-style: disc;
padding: 0 0 10px 32px; }

blockquote {
margin: 24px 40px;
padding: 0; }

strong {
font-weight: bold; }

small {
font-size: 0.85em; }

a {
color: #006699;
text-decoration: none; }
a:hover {
text-decoration: underline; }
html {
height: 100%; }

body
{
height: 100%;
min-height: 610px;
margin: 0px;
font-family: Geneva, Helvetica, sans-serif;
font-size: 16px;
color: #fff;
position: static;
overflow: hidden;
line-height: 1.2em;
background-color: #D5EAF4;
table-layout: fixed;
}

a {
font-size: 14px; color:#fff; }

.centered {
position: absolute;
top: 32%;
left: 50%; }

.header {
width: 100%;
background-color: #ddefff;
background-image: url(../images/client/header_repeatable.png);
background-repeat: repeat-x; }

.column {
width: 370px;
margin-left: -163px; }

.logo
{
height: 82px;
margin-left: 46px;
margin-top:35px;
background-image: url(img/Login_logo.png);
background-repeat: no-repeat;
vertical-align: bottom;
}

.remember_me_field {
float: left;
margin-top: 8px; }

.video {
margin: 4px;
width: 300px;
height: 180px;
border: 1px solid #6e6e6e;
padding: 10px; }

.login_frame.flexible .top {
background: transparent url(img/loginHeader.png) no-repeat top left;
height: 40px;width: 544px; }
.login_frame.flexible .middle {
background: transparent url(img/loginMiddle.png) repeat-y top left;
padding: 35px 20px; width: 350px; height:204px}
.login_frame.flexible .bottom {
background: transparent url(img/LoginFooter.png) no-repeat top left;
height: 75px; width: 544px;}

.bottom .forgotpass
{
position: absolute;
padding-left:180px;
padding-top: 15px;
}

.frame_panel.choose_password
{
width: 280px;
padding-top: 15px;
}
.frame_panel.choose_password .flash_message
{
margin-left: -20px; }

.frame_panel.choose_password .flash_message .flash_boxes {
font-family: Verdana, Arial;
font-size: 11px; }
.frame_panel.choose_password .flash_message .flash_boxes p {
width: 210px; }
.frame_panel.choose_password .gistsubmit {
margin-right: 23px;
margin-top: 7px; }
.frame_panel.choose_password .onboard_actions {
margin-right: 20px; }

#footer {
margin-left: auto;
margin-right: auto;
text-align: center;
clear: both; }

.before_you_begin_graphic {
width: 163px;
height: 20px;
background-image: url("../images/client/before_you_begin_lt.png");
background-repeat: no-repeat;
margin-top: 10px;
margin-left: 25px; }

.gmail_upload_graphic {
width: 55px;
/* height of actual image is 132px, but we increase this to ensure text remains to right of graphic */
height: 168px;
background-image: url("../images/client/Gmail_address_upload_lt.png");
background-repeat: no-repeat;
float: left;
margin-top: 15px;
margin-right: 18px; }

.privacy_page .privacy_text {
margin-top: 15px;
font-size: 11px;
line-height: 1.5em;
margin-bottom: 10px; }

.field {
margin-bottom: 10px;
}
.field .error
{
font-size: 10px;
display: none;
position: absolute;
margin-left: 5px;
width: 260px;
text-align: left;
color: red;
}
.field.error .error {
display: block;
color: red;
}

input[type=text], textarea, input[type=password]
{
background: #f1f1f1 url(img/login-sprite.png) no-repeat ;

border: 2px solid #a8a8a8;
font-family: inherit;
padding:7px 28px 7px 5px;
width: 230px;
margin-right: 4px;

-webkit-border-radius: 4px;
-moz-border-radius: 4px;
border-radius: 4px;
}
input[type=text].hint, textarea.hint, input[type=password].hint {
color: #999999; }
input[type=text].error, textarea.error, input[type=password].error {
border-color: red; }
#txtUN
{
background-position: 239px -11px !important;

}

#txtPwd
{
background-position: 239px -61px !important;
}

label {
font-size: 85%; }

.field {
margin-top: 10px; }

.title_graphic {
width: 218px;
height: 51px;
margin-top: 10px;
margin-left: 14px;
background-image: url("../images/client/frame/welcome.png"); }

.create_account_graphic {
width: 303px;
height: 49px;
margin-top: 10px;
margin-left: 13px;
background-image: url("../images/client/frame/create_account.png"); }

.welcome_graphic {
width: 277px;
height: 15px;
margin-top: 10px;
margin-left: 25px;
background-image: url("../images/client/frame/headline_welcome.png");
background-repeat: no-repeat; }

.survey_graphic {
width: 277px;
height: 46px;
margin-top: 10px;
margin-left: 25px;
background-image: url("../images/client/not_activated.png");
background-repeat: no-repeat; }

.survey_answer_graphic {
width: 277px;
height: 22px;
margin-top: 10px;
margin-left: 25px;
background-image: url("../images/client/thank_you_for_responding.png");
background-repeat: no-repeat; }

.promise_graphic {
width: 277px;
height: 15px;
margin-top: 10px;
margin-left: 25px;
background-image: url("../images/client/frame/headline_promise.png");
background-repeat: no-repeat; }

.clock_email {
width: 65px;
height: 150px;
background: url("../images/client/frame/clock_email.png") no-repeat;
float: left;
margin-left: 20px;
margin-right: 10px; }

.validate_header_graphic {
width: 295px;
height: 40px;
margin-top: 15px;
margin-left: 25px;
background-image: url("../images/client/frame/validate.png"); }

.bullet_graphic {
width: 7px;
height: 7px;
background: url("../images/client/bullet.png");
margin-top: 7px; }

.icon_styling {
padding-right: 20px;
float: left;
background-repeat: no-repeat; }

.info_private_graphic {
width: 38px;
height: 41px;
background-image: url("../images/client/info_private.png"); }

.padlock_graphic {
width: 38px;
height: 41px;
background-image: url("../images/client/padlock.png"); }

.account_deletion_graphic {
width: 38px;
height: 41px;
background-image: url("../images/client/account_deletion.png"); }

.not_shared_graphic {
width: 38px;
height: 41px;
background-image: url("../images/client/not_shared.png"); }

.frame_panel {
width: 264px;
height: 258px;
margin-right: auto;
margin-left: auto;
padding-top: 30px;
padding-left: 30px;
padding-right: 30px;
background-image: url("../images/client/frame/frame.png");
background-repeat: no-repeat; }

.frame_panel .gistsubmit {
margin-right: 70px; }

.frame_panel_tall {
width: 263px;
height: 420px;
background-image: url("../images/client/frame/frame_tall.png");
margin-right: auto;
margin-left: auto;
padding-top: 10px;
padding-left: 30px;
padding-right: 34px; }

.frame_panel_short {
width: 263px;
height: 225px;
margin-right: auto;
margin-left: auto;
padding-top: 10px;
padding-left: 30px;
padding-right: 34px;
background-image: url("../images/login/frame_short.png");
background-repeat: no-repeat; }

.frame_panel_shortest {
width: 327px;
height: 108px;
margin-right: auto;
padding-top: 10px;
padding-left: 20px;
padding-right: 30px;
background-image: url("../images/client/frame/button_frame.png");
background-repeat: no-repeat; }

.create_account {
padding-top: 10px;
padding-bottom: 10px; }

.para {
padding-bottom: 20px; }

.icon_para {
margin-left: 60px;
padding-bottom: 10px; }

.survey {
line-height: 1.5em;
font-size: 12px; }
.survey .para_title {
margin-bottom: 5px; }
.survey .para {
padding-bottom: 20px; }
.survey .question {
padding-top: 10px; }
.survey .question .icon_para {
margin-left: 30px;
padding-bottom: 10px; }
.survey a {
font-size: 12px; }

.intro {
padding: 10px;
padding-right: 0px;
padding-bottom: 0px;
margin-left: 20px;
margin-right: 20px; }

.frame {
min-width: 333px; }
.frame .frame_top {
height: 119px;
padding-top: 12px;
position: relative; }
.frame .frame_top .corners_left, .frame .frame_top .corners_right {
position: absolute;
width: 156px;
height: 119px; }
.frame .frame_top .corners_left {
background: url(../images/v2/frame/top_left.png) no-repeat;
top: 0;
left: 0; }
.frame .frame_top .corners_right {
background: url(../images/v2/frame/top_right.png) no-repeat;
top: 0;
right: 0; }
.frame .frame_top .inner {
background: #00b5dd url(../images/v2/frame/top_watermark.png) no-repeat;
height: 82px;
margin: 0 30px;
position: relative;
z-index: 101; }
.frame .frame_top .inner h2 {
padding-top: 45px;
padding-left: 12px;
padding-bottom: 5px;
font-size: 18px;
color: white;
font-family: Verdana;
font-weight: bold; }
.frame .frame_content {
background-color: white;
margin: -37px 22px 0px 22px;
padding: 20px;
padding-bottom: 0;
position: relative;
z-index: 100001;
min-height: 79px; }
.frame .frame_bottom {
height: 119px;
position: relative;
margin-top: -99px; }
.frame .frame_bottom .corners_left, .frame .frame_bottom .corners_right {
position: absolute;
width: 191px;
height: 119px; }
.frame .frame_bottom .corners_left {
background: url(../images/v2/frame/bottom_left.png) no-repeat;
bottom: 0;
left: 3px; }
.frame .frame_bottom .corners_right {
background: url(../images/v2/frame/bottom_right.png) no-repeat;
bottom: 0;
right: 3px; }
.frame .frame_bottom .inner {
background-color: white;
height: 106px;
margin: 0 30px; }

.popup .frame .frame_top .corners_left {
background-image: url(../images/v2/frame/in_popup/top_left.png); }
.popup .frame .frame_top .corners_right {
background-image: url(../images/v2/frame/in_popup/top_right.png); }
.popup .frame .frame_bottom .corners_left {
background-image: url(../images/v2/frame/in_popup/bottom_left.png); }
.popup .frame .frame_bottom .corners_right {
background-image: url(../images/v2/frame/in_popup/bottom_right.png); }

.flash_boxes > p {
margin-left: 20px;
width: 226px; }
.gistbtn {
display: block;
background: transparent url(../images/v2/gistbtn/gistbtn_normal_left.png) no-repeat 0 0;
float: left;
font-size: 12px;
font-weight: bold;
text-align: center;
border: 0;
height: 39px;
line-height: 42px !important;
cursor: pointer;
color: #134f7f;
position: relative;
margin-right: 5px; }
.gistbtn:hover {
text-decoration: none; }
.gistbtn.spaceleft {
margin-left: 5px; }
.gistbtn > em {
display: block;
max-width: 184px;
overflow: hidden;
font-style: normal;
white-space: nowrap;
background: none;
border: 0;
margin: 0;
padding: 0;
padding-right: 3px;
padding-left: 18px; }
.gistbtn > span {
display: block;
position: absolute;
top: 0;
right: -12px;
width: 12px;
height: 100%;
background: transparent url(../images/v2/gistbtn/gistbtn_normal_right.png) no-repeat 0 0; }
.gistbtn.light {
font-weight: normal;
background-image: url(../images/v2/gistbtn/gistbtn_light_left.png); }
.gistbtn.light > span {
background-image: url(../images/v2/gistbtn/gistbtn_light_right.png); }
.gistbtn.disabled {
font-weight: normal;
background-image: url(../images/v2/gistbtn/gistbtn_disabled_left.png);
color: #919191;
cursor: default; }
.gistbtn.disabled > span {
background-image: url(../images/v2/gistbtn/gistbtn_disabled_right.png); }
.gistbtn.bigpointy {
background-image: url(../images/v2/gistbtn/gistbtn_setup_left.png);
color: #134f7f;
font-size: 18px;
font-weight: bold;
padding-bottom: 5px; }
.gistbtn.bigpointy > em {
max-width: none;
padding-right: 10px;
margin-top: -2px; }
.gistbtn.bigpointy > span {
background-image: url(../images/v2/gistbtn/gistbtn_setup_right.png);
right: -25px;
width: 25px; }
.gistbtn.pointing-left {
font-weight: normal;
background-image: url(../images/v2/gistbtn/gistbtn_pointing_left-left.png);
color: #134f7f; }
.gistbtn.pointing-left > em {
max-width: none;
padding-right: 6px;
margin-top: -6px;
font-weight: inherit; }
.gistbtn.pointing-left > span {
background-image: url(../images/v2/gistbtn/gistbtn_pointing_left-right.png);
right: -10px;
width: 10px; }
.gistbtn.pointing-left.bold > em {
font-weight: bold; }
.gistbtn.mini {
background-image: url(../images/v2/gistbtn/gistbtn_sm_normal_left.png);
font-size: 10px;
height: 32px;
line-height: 33px !important; }
.gistbtn.mini > em {
max-width: 159px;
padding-right: 8px;
padding-left: 18px; }
.gistbtn.mini > span {
right: -9px;
width: 9px;
background: transparent url(../images/v2/gistbtn/gistbtn_sm_normal_right.png) no-repeat 0 0; }
.gistbtn.mini.light {
background-image: url(../images/v2/gistbtn/gistbtn_sm_light_left.png); }
.gistbtn.mini.light > span {
background-image: url(../images/v2/gistbtn/gistbtn_sm_light_right.png); }
.gistbtn.mini.disabled {
background-image: url(../images/v2/gistbtn/gistbtn_sm_disabled_left.png); }
.gistbtn.mini.disabled > span {
background-image: url(../images/v2/gistbtn/gistbtn_sm_disabled_right.png); }
.gistbtn.mini.action {
background-image: url(../images/v2/gistbtn/gistbtn_sm_action_left.png); }
.gistbtn.mini.action > em {
padding-right: 2px; }
.gistbtn.mini.action > span {
background-image: url(../images/v2/gistbtn/gistbtn_sm_action_right.png);
right: -28px;
width: 28px; }
.gistbtn.autowidth > em {
max-width: none; }

.gistsubmit {
display: block;
background: transparent url(img/gistbtn_normal_left.png) no-repeat 0 0;
float: left;
font-size: 12px;
font-weight: bold;
text-align: center;
border: 0;
height: 39px;
color: #134f7f;
position: relative;
margin:0px 0px 0px 0px; }
.gistsubmit:hover {
text-decoration: none; }
.gistsubmit > input {
display: block;
max-width: 175px;
min-width:80px;
overflow: hidden;
font-style: normal;
white-space: nowrap;
background: none;
border: 0;
margin: 0 !important;
padding: 0;
color: #134f7f;
font-weight: bold;
font-family: Verdana, Arial, Geneva, Helvetica, sans-serif;
font-size: 12px;
padding-right: 21px;
padding-left: 18px;
padding-top: 10px;
padding-bottom: 11px;
cursor: pointer;
margin-right: -18px !important;
line-height: 19px !important; }
.gistsubmit > span {
display: block;
position: absolute;
top: 0;
right: -12px;
width: 12px;
height: 100%;
background: transparent url(img/gistbtn_normal_right.png) no-repeat 0 0; }
.gistsubmit.light {
background-image: url(../images/v2/gistbtn/gistbtn_light_left.png); }
.gistsubmit.light > input {
font-weight: normal; }
.gistsubmit.light > span {
background-image: url(../images/v2/gistbtn/gistbtn_light_right.png); }
.gistsubmit.disabled {
background-image: url(../images/v2/gistbtn/gistbtn_disabled_left.png); }
.gistsubmit.disabled > input {
color: #919191;
font-weight: normal; }
.gistsubmit.disabled > span {
background-image: url(../images/v2/gistbtn/gistbtn_disabled_right.png); }
.gistsubmit.mini {
background-image: url(../images/v2/gistbtn/gistbtn_sm_normal_left.png);
height: 32px; }
.gistsubmit.mini > input {
max-width: 159px;
font-size: 10px;
padding-right: 26px;
padding-left: 18px;
padding-top: 9px;
padding-bottom: 8px;
line-height: 14px !important;
margin: 0; }
.gistsubmit.mini > span {
right: -9px;
width: 9px;
background: transparent url(../images/v2/gistbtn/gistbtn_sm_normal_right.png) no-repeat 0 0; }
.gistsubmit.mini.light {
background-image: url(../images/v2/gistbtn/gistbtn_sm_light_left.png); }
.gistsubmit.mini.light > span {
background-image: url(../images/v2/gistbtn/gistbtn_sm_light_right.png); }
.gistsubmit.mini.disabled {
background-image: url(../images/v2/gistbtn/gistbtn_sm_disabled_left.png); }
.gistsubmit.mini.disabled > span {
background-image: url(../images/v2/gistbtn/gistbtn_sm_disabled_right.png); }
.flash_boxes, .vcard_flash_boxes {
margin: 0;
line-height: 1.25em;
color: #333333;
font-family: Verdana;
font-size: 12px; }
.flash_boxes a, .vcard_flash_boxes a {
color: #006699;
white-space: nowrap; }
.flash_boxes a:hover, .vcard_flash_boxes a:hover {
text-decoration: underline; }
.flash_boxes em, .vcard_flash_boxes em {
font-style: normal;
font-weight: bold; }
.flash_boxes > p, .flash_boxes > div, .vcard_flash_boxes > p, .vcard_flash_boxes > div {
margin: 0;
padding: 10px 0 10px 36px;
background-color: #ddebed;
border: 1px solid #b6c7d3; }
.flash_boxes > p strong, .flash_boxes > div strong, .vcard_flash_boxes > p strong, .vcard_flash_boxes > div strong {
font-weight: bold;
display: block; }
.flash_boxes dt, .vcard_flash_boxes dt {
margin-top: 10px; }
.flash_boxes .notice, .flash_boxes .error, .flash_boxes .prompt, .vcard_flash_boxes .notice, .vcard_flash_boxes .error, .vcard_flash_boxes .prompt {
background-repeat: no-repeat;
background-position: 10px 13px;
padding-right: 10px; }
.flash_boxes .notice, .vcard_flash_boxes .notice {
background-image: url(../images/v2/flash_boxes/notice.png); }
.flash_boxes .error, .vcard_flash_boxes .error {
background-image: url(../images/v2/flash_boxes/error.png); }
.flash_boxes .prompt, .flash_boxes .info, .vcard_flash_boxes .prompt, .vcard_flash_boxes .info {
background-image: url(../images/v2/flash_boxes/arrow.png);
color: #333333;
font-size: 11px;
line-height: 1.4em; }
.flash_boxes .prompt .text, .flash_boxes .info .text, .vcard_flash_boxes .prompt .text, .vcard_flash_boxes .info .text {
color: #666666; }
.white {
color: white; }

.gray {
color: #555555; }

.green {
color: #5a7500; }

.red {
color: #aa0000; }

.block {
display: block; }

.inline {
display: inline !important; }

.hidden {
visibility: hidden; }

.display_none {
display: none; }

.clear, .clearboth {
clear: both; }

.clear-left, .clearleft {
clear: left; }

.clear-right, .clearright {
clear: right; }

.float-left, .left {
float: left; }

.float-right, .right {
float: left; }

.text-left {
text-align: left; }

.text-right {
text-align: right; }

.text-center {
text-align: center; }

.text-justify {
text-align: justify; }

.unbold {
font-weight: normal; }

.v-middle {
vertical-align: middle; }

.v-sub {
vertical-align: sub; }

.bold {
font-weight: bold; }

.normal {
font-weight: normal; }

.italic {
font-style: italic; }

.underline {
border-bottom: 1px solid; }

.highlight {
background: #ffffcc; }

.wrap {
width: 960px;
margin: 0 auto; }

.img-left {
float: left;
margin: 4px 8px 4px 0; }

.img-right {
float: right;
margin: 4px 0 4px 8px; }

.nopadding {
padding: 0; }

.nomargin {
margin: 0 !important; }

.noindent {
margin-left: 0;
padding-left: 0; }

.nobullet {
list-style: none;
list-style-image: none; }

.nowrap {
white-space: nowrap; }

.nobgimg {
background-image: none !important; }

.push1 {
float: left; }

.positioner {
position: relative;
top: 0;
left: 0; }

.small {
font-size: 9px; }

.centered {
display: block;
margin: 0 auto; }

.pad-bottom {
padding-bottom: 10px; }

.pad-top {
padding-top: 10px; }

.pad-right {
padding-right: 10px; }

.pad-left {
padding-left: 10px; }

.absolute {
position: absolute; }

3) Required images ................................................

How To do Shopping CART In asp.net

2012-11-20T14:25:00.002+05:30

There are some links i found on internet for shopping cart website.

http://www.codeproject.com/Articles/17674/GridView-Order-Page-Shopping-Cart-Page-ASP-NET-SQL

http://net.tutsplus.com/tutorials/other/build-a-shopping-cart-in-aspnet/

(free and open source shopping cart )
http://www.nopcommerce.com/default.aspx

( some helpfull code )
http://howtouseasp.net/how-to-do-shopping-cart-in-asp-net-c/

http://www.codeproject.com/Tips/403267/ShoppingCart-using-Gridview-in-ASP-NET

http://www.ajaxprojects.com/ajax/tutorialdetails.php?itemid=423

http://my.safaribooksonline.com/book/web-development/microsoft-aspdotnet/0957921861/building-an-aspdotnet-shopping-cart/aspnet-chp-12

( download ER-Diagrams of Ecommerce website )
http://www.uml-diagrams.org/examples/online-shopping-example.html

(Download Sample)
http://csharpdotnetfreak.blogspot.com/2009/05/aspnet-creating-shopping-cart-example.html

http://www.aboutmydot.net/web-development/shopping-cart-in-aspnet.html

( LIVE DEMO )
http://www.dotnetcart.com/livedemo.htm

( Demo and Source code)
http://www.znode.com/asp-net-shopping-cart-source-code.aspx

(Sample and Source code)
http://www.codeproject.com/Articles/3765/Easy-ASP-NET-Shopping-Cart

(sample and source code )
http://www.c-sharpcorner.com/UploadFile/ShrutiShrivastava/ASPNetShoppingCart11262005063508AM/ASPNetShoppingCart.aspx

(Sample , source code and link )
http://www.c-sharpcorner.com/forums/thread/160928/developing-a-shopping-cart-in-asp-net.aspx

(download source sample )
http://www.aspfree.com/c/a/c-sharp/creating-an-online-shopping-cart-and-paypal-system/

(Nope commerce free open source)
http://www.nopcommerce.com/default.aspx

Show HTML REPORT in asp.net

2012-11-20T14:14:00.001+05:30

------------------------------------------------------------------------------------------------------------

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Text;

public partial class HTMLReport_rptPaymentVourcher : System.Web.UI.Page
{
clsFnLib objclsFnLib = new clsFnLib();
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
try
{
if (Request.QueryString["ID"] != null)
{
Response.ClearHeaders();
Response.AddHeader("content-disposition", "attachment;filename=" + "PVS_Report_" + DateTime.Now.ToString("dd-MMM-yyyy") + ".htm");

//Response.ContentType = "application/vnd.ms-excel";
Response.ContentType = "text/HTML";
StringBuilder data = new StringBuilder();
clsHTMLVoucherReport objclsHTMLVoucherReport = new clsHTMLVoucherReport();
objclsHTMLVoucherReport.VoucherSrNo = Request.QueryString["ID"].ToString();
DataSet dsVD = objclsHTMLVoucherReport.getVoucherDetails();
DataSet dsID = objclsHTMLVoucherReport.getInvoiceDetails();

if (dsVD.Tables[0].Rows.Count == 0)
{
objclsFnLib.WebMessageBox("No Record found.", this);
return;
}
#region write data
#region data above grid
data.Append(@"<html>
<head>
<title>PVS Report_#Date</title>
<script type='text/javascript' language='javascript'>
function printpage()
{
var continue_button = document.getElementById('btnPrint');
continue_button.style.visibility = 'hidden';
window.print()
}
</script>
</head>
<body style='font-family:Arial'>
<table id='tblPage' cellspacing='0'>
<tr id='topSpace' style='height: 50px'>
</tr>
<tr id='trMidlArea'>
<td id='leftSpace' style='width: 10%'>
</td>
<td id='tdMidlArea' style='width: 80%'>
<div id='DEnb' style='text-align:right'><input id='btnPrint' type='button' value='Print this report' onclick='printpage();' /></div>
<div id='DDis' style='text-align:right'><input id='btnPrint1' type='button' Disabled='disabled' value='Print this report' /></div>
<table id='report' border='1' rules='ROWS' frame='BOX' cellspacing='0' width='900px'
cellpadding='0' bordercolor='BLACK'>
<tr id='1stRow'>
<td>
<table width='100%' border='1' rules='cols' frame='vsides' cellspacing='0' bordercolor='BLACK'
style='border-left: 0; border-right: 0' cellpadding='5'>
<tr>
<td>
Date : #Date</td>
<td align='center'>
<b>CROMPTON GREAVES LIMITED
<br />
PAYMENT VOUCHER</b></td>
<td>
Sr. No.: #SrNo</td>
</tr>
</table>
</td>
</tr>
<tr id='2ndRow'>
<td>
<table cellspacing='0' cellpadding='5'>
<tr>
<td>
Name of the Department
</td>
<td>
: #NameOfTheDepartment
</td>
</tr>
<tr>
<td>
Invoice received Date
</td>
<td>
: #InvoicereceivedDate
</td>
</tr>
</table>
</td>
</tr>
<tr id='3rdRow'>
<td>
<table width='100%' cellspacing='0' cellpadding='5'>
<tr>
<td align='left'>
Vendor Name</td>
<td align='left'>
: <span style='text-decoration: underline; font-weight: bold'>#VendorName</span></td>
<td align='right'>
Vendor Code :</td>
<td align='right'>
<span style='text-decoration: underline; font-weight: bold'>#VendorCode</span></td>
</tr>
<tr>
<td align='left'>
G/L Description</td>
<td align='left'>
: #GLDescription</td>
<td align='right'>
G/L Code :</td>
<td align='right'>
#GLCode</td>
</tr>
<tr>
<td align='left'>
Cost Center Description</td>
<td align='left'>
: #CostCenterDescription</td>
<td align='right'>
Cost Center :</td>
<td align='right'>
#CostCenterr</td>
</tr>
</table>
</td>
</tr>
<tr id='4thRow'>
<td>
<table cellspacing='0' cellpadding='5'>
<tr>
<td>
Debit to Division/Region/Dept.: #DebitToDiv</td>
</tr>
</table>
</td>
</tr>
<tr id='5thRow'>
<td>
<table border='1' rules='cols' frame='vsides' width='100%' cellspacing='0' bordercolor='BLACK'
cellpadding='5'>
<tr>
<td >
From       : #From
</td>
<td>
To         : #To
</td>
</tr>
<tr>
<td style='width: 50%'>
RefFrom  : #RefFrom
</td>
<td>
RefTo    : #RefTo
</td>
</tr>
</table>
</td>
</tr>
<tr id='6thRow'>
<td>
<table cellspacing='0' cellpadding='5'>
<tr>
<td>
Kindly issue cheque in favour of</td>
<td>
: <span style='text-decoration: underline; font-weight: bold'>#ChequeInFaourOf</span></td>
</tr>
<tr>
<td>
Amount In Figures</td>
<td>
: <span style='text-decoration: underline; font-weight: bold'>#AmountInFigures</span></td>
</tr>
<tr>
<td>
Amount In Words
</td>
<td>
: <span style='text-decoration: underline; font-weight: bold'>#AmountInWords</span>
</td>
</tr>
</table >

<table border='1' rules='cols' width='100%' cellspacing='0' bordercolor='BLACK' cellpadding='5'>
<tr>
<td>
Type of services : <span >#vServiceName</span>
</td>
<td style='display:#displayService;'>
Service received from person : <span >#vProviderName</span>
</td>
</tr>
<tr style='display:#displayService;'>
<td>
Applicability of service tax liability :<span >#chIsApplicable</span>
</td>
<td>
% of liability : <span >#nLiability</span>
</td>
</tr>
</table>
</td>
</tr>
<tr id='7thRow'>
<td>
<table border='1' bordercolor='BLACK' cellspacing='0' width='100%' style='border-left: 0;
border-right: 0; border-top: 0; border-bottom: 0' cellpadding='5'>
<tr>
<td colspan='7'>
Invoice Details
</td>
<td colspan='2'>
Details Of Advance Paid
</td>
</tr>
<tr>
<td>
Sr. No.
</td>
<td>
Invoice No.
</td>
<td>
Invoice Date
</td>
<td>
PO No.
</td>
<td>
PO. Date
</td>
<td>
SAP GRIR No.
</td>
<td>
Invoice Amount
</td>
<td>
Date
</td>
<td>
Amount
</td>
</tr>");
data.Replace("#Date", DateTime.Now.ToString("dd-MMM-yyyy"));
data.Replace("#SrNo", Request.QueryString["ID"].ToString());
data.Replace("#NameOfTheDepartment", dsVD.Tables[0].Rows[0]["vDepartmentName"].ToString());
data.Replace("#InvoicereceivedDate", dsVD.Tables[0].Rows[0]["dtInvoiceReceivedDate"].ToString());
data.Replace("#VendorName", dsVD.Tables[0].Rows[0]["vVendorName"].ToString());
data.Replace("#VendorCode", dsVD.Tables[0].Rows[0]["vVendorCode"].ToString());
data.Replace("#GLDescription", dsVD.Tables[0].Rows[0]["vGLDescription"].ToString());
data.Replace("#GLCode", dsVD.Tables[0].Rows[0]["vGLID"].ToString());
data.Replace("#CostCenterr", dsVD.Tables[0].Rows[0]["vCostCentre"].ToString());
data.Replace("#CostCenterDescription", dsVD.Tables[0].Rows[0]["vCostCentreName"].ToString());
data.Replace("#DebitToDiv", dsVD.Tables[0].Rows[0]["vDebitToDivision"].ToString());
data.Replace("#From", dsVD.Tables[0].Rows[0]["vFrom"].ToString());
data.Replace("#To", dsVD.Tables[0].Rows[0]["vTo"].ToString());
data.Replace("#RefFrom", dsVD.Tables[0].Rows[0]["vFromRef"].ToString());
data.Replace("#RefTo", dsVD.Tables[0].Rows[0]["vToRef"].ToString());
data.Replace("#ChequeInFaourOf", dsVD.Tables[0].Rows[0]["vIssueChqInFavour"].ToString());
data.Replace("#AmountInFigures", dsVD.Tables[0].Rows[0]["nAmount"].ToString());
data.Replace("#AmountInWords", dsVD.Tables[0].Rows[0]["vAmountInWords"].ToString());
if (dsVD.Tables[0].Rows[0]["vServiceName"].ToString()!="")
{
data.Replace("#vServiceName", dsVD.Tables[0].Rows[0]["vServiceName"].ToString());
data.Replace("#displayService", " ");
data.Replace("#vProviderName", dsVD.Tables[0].Rows[0]["vProviderName"].ToString());
data.Replace("#chIsApplicable", dsVD.Tables[0].Rows[0]["chIsApplicable"].ToString());
}
else
{
data.Replace("#vServiceName"," Not Applicable.");
data.Replace("#displayService", "none");
}

if (dsVD.Tables[0].Rows[0]["nLiability"].ToString() == "" || dsVD.Tables[0].Rows[0]["nLiability"].ToString() == "0")
{
data.Replace("#nLiability", "NIL");
}
else
{
data.Replace("#nLiability", dsVD.Tables[0].Rows[0]["nLiability"].ToString());
}
#endregion

#region Grid
for (int i = 0; i < dsID.Tables[0].Rows.Count; i++)
{
data.Append(@"<tr>
<td>
#tblSrNo
</td>
<td>
#tblInvoiceNo
</td>
<td>
#tblInvoiceDate
</td>
<td>
#tblPONo
</td>
<td>
#tblPODate
</td>
<td>
#tblSAPGRIRNo
</td>
<td>
#tblInvoiceAmount
</td>
<td>
#tblDate
</td>
<td>
#tblAmount
</td>
</tr>");
data.Replace("#tblSrNo", (i + 1).ToString());
data.Replace("#tblInvoiceNo", dsID.Tables[0].Rows[i]["vInvoiceNo"].ToString());
data.Replace("#tblInvoiceDate", dsID.Tables[0].Rows[i]["dtInvoiceDate"].ToString());
data.Replace("#tblPONo", dsID.Tables[0].Rows[i]["vPONo"].ToString());
data.Replace("#tblPODate", dsID.Tables[0].Rows[i]["dtPODate"].ToString());
data.Replace("#tblSAPGRIRNo", dsID.Tables[0].Rows[i]["vSAPGRIRNo"].ToString());
data.Replace("#tblInvoiceAmount", dsID.Tables[0].Rows[i]["nInvoiceAmount"].ToString());
data.Replace("#tblDate", dsID.Tables[0].Rows[i]["dtAdvanceDate"].ToString());
data.Replace("#tblAmount", dsID.Tables[0].Rows[i]["nAdvanceAmount"].ToString());
}
#endregion

#region after grid
data.Append(@"
</table>
</td>
</tr>
<tr id='8th Row'>
<td>
<table width='100%' cellspacing='0' cellpadding='5'>
<tr>
<td style='width:18%'>
Towards payment for</td>
<td style='width:60%'>
: 1. #TowardsPaymentFor1</td>
<td>
</td>
<td>
</td>
</tr>
<tr id='trTowardsPaymentFor2'>
<td>
</td>
<td>
: 2. #TowardsPaymentFor2</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
Due Date</td>
<td>
: #DueDate</td>
<td>
TDS-Rate</td>
<td>
: #TDS-Rate</td>
</tr>
</table>
</td>
</tr>
<tr id='9thRow'>
<td>
<table border='1' cellspacing='0' width='100%' bordercolor='BLACK' style='border-left: 0;
border-right: 0; border-top: 0; border-bottom: 0' cellpadding='5'>
<tr>
<td style='width: 34%'>
Raised By :</td>
<td style='width: 33%'>
Checked By :</td>
<td style='width: 33%'>
Authorised By :</td>
</tr>
<tr>
<td valign='top' style='width: 34%'>
<table cellspacing='0'>
<tr>
<td style='width: 60%'>
Name</td>
<td style='width: 40%'>
: #NameRaisedBy</td>
</tr>
<tr>
<td style='width: 60%'>
Date</td>
<td style='width: 40%'>
: #DateRaisedBy</td>
</tr>
<tr>
<td style='width: 60%'>
Remark</td>
<td style='width: 40%'>
: #RemarkRaisedBy</td>
</tr>
<tr>
<td style='width: 60%'>
Signature</td>
<td style='width: 40%'>
: #Signature</td>
</tr>
</table>
</td>
<td valign='top' style='width: 33%'>
<table cellspacing='0'>
<tr>
<td colspan='2'>
Electronically approved by : #ElectronicallyApprovedByCheckedBy</td>
</tr>
<tr>
<td style='width: 60%'>
Date</td>
<td style='width: 40%'>
: #DateCheckedBy</td>
</tr>
<tr>
<td style='width: 60%'>
Remark</td>
<td style='width: 40%'>
: #RemarkCheckedBy</td>
</tr>
</table>
</td>
<td valign='top' style='width: 33%'>
<table cellspacing='0'>
<tr>
<td colspan='2'>
Electronically approved by : #ElectronicallyApprovedByAuthorisedBy</td>
</tr>
<tr>
<td style='width: 60%'>
Date</td>
<td style='width: 40%'>
: #DateAuthorisedBy</td>
</tr>
<tr>
<td style='width: 60%'>
Remark</td>
<td style='width: 40%'>
: #RemarkAuthorisedBy</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr id='ElectronicApproveRow'>
<td>
<table cellspacing='0' cellpadding='5'>
<tr>
<td>
Electronically approved By
</td>
<td>
: #ElectronicallyapprovedBySepRowName</td>
</tr>
<tr>
<td>
Date
</td>
<td>
: #ElectronicallyapprovedBySepRowDate
</td>
</tr>
<tr>
<td>
Remark
</td>
<td>
: #ElectronicallyapprovedBySepRowRemark
</td>
</tr>
</table>
</td>
</tr>
<tr id='ComputerRelatedApproveRow'>
<td>
<table cellspacing='0' cellpadding='5'>
<tr>
<td>
Computer Related approved By
</td>
<td>
: #ComputerRelatedapprovedBySepRowName</td>
</tr>
<tr>
<td>
Date
</td>
<td>
: #ComputerRelatedapprovedBySepRowDate
</td>
</tr>
<tr>
<td>
Remark
</td>
<td>
: #ComputerRelatedapprovedBySepRowRemark
</td>
</tr>
</table>
</td>
</tr>
<tr id='10thRow'>
<td>
<table cellspacing='0' cellpadding='5'>
<tr>
<td>
E-Payment details of the vendor has been provided: Yes/No</td>
<td>
  : #EPaymentDetailsYesNo</td>
</tr>
<tr>
<td colspan='2'>
If no, then please provide separately as per the format.</td>
</tr>
</table>
</td>
</tr>
<tr id='11thRow'>
<td>
<table width='100%' cellspacing='0' cellpadding='5'>
<tr>
<td colspan='4'>
<span style='font-weight: bold'>For Accounts Department use only :</span></td>
</tr>
<tr>
<td style='width: 25%'>
</td>
<td style='width: 25%'>
</td>
<td style='width: 25%'>
Approved by(1)</td>
<td style='width: 25%'>
: #Approvedby(1)Name</td>
</tr>
<tr>
<td>
Received Date</td>
<td>
: #ReceivedDate</td>
<td>
Date</td>
<td>
: #AccountsReceivedDate</td>
</tr>
<tr>
<td>
Checked By</td>
<td>
: #AccountsCheckedBy</td>
<td>
Remark</td>
<td>
: #Approvedby(1)Remark</td>
</tr>
<tr>
<td>
Date</td>
<td>
: #AccountsDateCheckedBy</td>
<td>
Approved By(2)</td>
<td>
: #ApprovedBy(2)Name</td>
</tr>
<tr>
<td>
Remark</td>
<td>
: #CheckedByRemark</td>
<td>
Date</td>
<td>
: #Approvedby(2)Date</td>
</tr>
<tr>
<td>
</td>
<td>
</td>
<td>
Remark</td>
<td>
: #Approvedby(2)Remark</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
<td id='tdRightSpace' style='width: 10%'>
</td>
</tr>
<tr id='botomSpace' style='height: 20px'>
</tr>
</table>
</body>
</html>
");
data.Replace("#TowardsPaymentFor1", dsVD.Tables[0].Rows[0]["vTowardsPaymentFor1"].ToString());
if (dsVD.Tables[0].Rows[0]["vTowardsPaymentFor2"].ToString() == "")
data.Replace("id='trTowardsPaymentFor2'", "style='display:none'");
data.Replace("#TowardsPaymentFor2", dsVD.Tables[0].Rows[0]["vTowardsPaymentFor2"].ToString());
data.Replace("#DueDate", dsVD.Tables[0].Rows[0]["dtDueDate"].ToString());
data.Replace("#TDS-Rate", dsVD.Tables[0].Rows[0]["nTDSRate"].ToString());
data.Replace("#NameRaisedBy", dsVD.Tables[0].Rows[0]["UM"].ToString());
data.Replace("#DateRaisedBy", dsVD.Tables[0].Rows[0]["dtVoucherRaisedDate"].ToString());
data.Replace("#RemarkRaisedBy", dsVD.Tables[0].Rows[0]["vRaiseByRemark"].ToString());
data.Replace("#Signature", "");
data.Replace("#ElectronicallyApprovedByCheckedBy", dsVD.Tables[0].Rows[0]["UM1"].ToString());
data.Replace("#DateCheckedBy", dsVD.Tables[0].Rows[0]["dtVoucherCheckedDate"].ToString());
data.Replace("#RemarkCheckedBy", dsVD.Tables[0].Rows[0]["vCheckByRemark"].ToString());

data.Replace("#ElectronicallyApprovedByAuthorisedBy", dsVD.Tables[0].Rows[0]["UM2"].ToString());

data.Replace("#DateAuthorisedBy", dsVD.Tables[0].Rows[0]["dtVoucherAuthorisedDate"].ToString());
data.Replace("#RemarkAuthorisedBy", dsVD.Tables[0].Rows[0]["vAuthorisedRemark"].ToString());
if (dsVD.Tables[0].Rows[0]["btEPaymentDetails"].ToString().ToUpper() == "TRUE")
data.Replace("#EPaymentDetailsYesNo", "Yes");
else
data.Replace("#EPaymentDetailsYesNo", "No");
data.Replace("#Approvedby(1)Name", dsVD.Tables[0].Rows[0]["UM4"].ToString());
data.Replace("#ReceivedDate", dsVD.Tables[0].Rows[0]["dtVoucherReceivedDate_Account"].ToString());
data.Replace("#AccountsReceivedDate", dsVD.Tables[0].Rows[0]["dtVoucherReceivedDate_Account"].ToString());
data.Replace("#AccountsCheckedBy", dsVD.Tables[0].Rows[0]["UM3"].ToString());
data.Replace("#Approvedby(1)Remark", dsVD.Tables[0].Rows[0]["vApproval1"].ToString());
data.Replace("#AccountsDateCheckedBy", dsVD.Tables[0].Rows[0]["dtVoucherCheckedByDate_Account"].ToString());
data.Replace("#ApprovedBy(2)Name", dsVD.Tables[0].Rows[0]["UM5"].ToString());
data.Replace("#CheckedByRemark", dsVD.Tables[0].Rows[0]["vCheckBy"].ToString());
data.Replace("#Approvedby(2)Date", dsVD.Tables[0].Rows[0]["dtVoucherApprovedByDate_Account2"].ToString());
data.Replace("#Approvedby(2)Remark", dsVD.Tables[0].Rows[0]["vApproval2"].ToString());

#region Electronic & Computer Related approval
if (Convert.ToDecimal(dsVD.Tables[0].Rows[0]["nAmount"].ToString()) > 500000)
{
data.Replace("#ElectronicallyapprovedBySepRowName", dsVD.Tables[0].Rows[0]["UM6"].ToString());
data.Replace("#ElectronicallyapprovedBySepRowDate", dsVD.Tables[0].Rows[0]["vCpDate"].ToString());
data.Replace("#ElectronicallyapprovedBySepRowRemark", dsVD.Tables[0].Rows[0]["vCpRemark"].ToString());
}
else
{
data.Replace("id='ElectronicApproveRow'", "style='display:none'");
}
if (Convert.ToBoolean(dsVD.Tables[0].Rows[0]["btCompRelated"].ToString()) == true)
{
data.Replace("#ComputerRelatedapprovedBySepRowName", dsVD.Tables[0].Rows[0]["CompRelated"].ToString());
data.Replace("#ComputerRelatedapprovedBySepRowDate", dsVD.Tables[0].Rows[0]["dtCompRelatedApproveDate"].ToString());
data.Replace("#ComputerRelatedapprovedBySepRowRemark", dsVD.Tables[0].Rows[0]["vCompRelatedRemark"].ToString());
}
else
{
data.Replace("id='ComputerRelatedApproveRow'", "style='display:none'");
}
if (dsVD.Tables[0].Rows[0]["UM2"].ToString()=="")
data.Replace("id='DEnb'", "style='display:none'");
else
data.Replace("id='DDis'", "style='display:none'");

#endregion
//after grid
#endregion
#endregion
Response.Write(data);
}
}
catch (Exception ex)
{
throw ex;
}
}
}
}

pivot tables in sql server tutorial

2012-11-17T10:24:00.004+05:30

Click on below link

http://www.kodyaz.com/articles/t-sql-pivot-tables-in-sql-server-tutorial-with-examples.aspx

How to Search Duplicate Records in SQL

2012-06-27T16:01:00.000+05:30

SELECT catrefcode, COUNT(*) TotalCount
FROM importedcatref
GROUP BY catrefcode
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC

AJAY HELP

What is the use of n-tier architecture and 3-tier architecture?

3-Tier Architecture in asp.net using c#

Usable Things for Bootstrap

how to use multiple versions of jquery on the same page

Use jQuery.noConflict():

Avoid duplicate rows by keep same order in SQL Server

Do various things by JSON in ASP.net -3

Do various things by JSON in ASP.net -3

Bind dropdown list by JSON

Form Source

Do various things by JSON in ASP.net -2

Display records in GridView by JSON

Form Source

Do various things by JSON in ASP.net -1

Simply Add/Edit records by JSON

Export DataGridview To Excel

See the code

Sample Database Class

Avoid submit event Refresh in Asp.net

How to Save and Retrieve File in SQL Server Table

LINQ to SQL: Basic Concepts and Features

All Browser Supporting Tag for Asp.net Website

JSON Tutorial

JSON Tutorial

Calculate GridView total using JavaScript / JQuery

Get Next Number with REPLICATE In SQL Server

Jquery animation cutting Ribbon with scissors

How to fix Column of Gridview or scrollable grid in Asp.net

Some Jquery Plugins

Session Expired Alert in Jquery

My Login Page

How To do Shopping CART In asp.net

Show HTML REPORT in asp.net

pivot tables in sql server tutorial

How to Search Duplicate Records in SQL

Use `jQuery.noConflict()`: