Asp.net,C#, Xml,Ajax, Jquery, Javascript, Telerik, Silverligh, Wcf, Wpf, Mvc, Mvp, iphone, Android

Understanding MVC architecture

2012-01-26T00:02:00.000-08:00

http://www.youtube.com/watch?v=eTdVkgF_Slo&feature=related

http://www.youtube.com/watch?v=KAKxm4eQP24&feature=relmfu

Best Practices for Speeding Up Your Web Site

2011-12-11T21:27:00.001-08:00

http://developer.yahoo.com/performance/rules.html#expires

Jquery with file upload

2011-10-19T19:56:00.000-07:00

http://osman.it/aspnet/jquery-ajax-file-upload/

jQuery Proven Performance Tips And Tricks (Slides)

2011-10-17T12:31:00.001-07:00

http://addyosmani.com/jqprovenperformance/

Tip/Trick: Enabling SSL on IIS 7.0 Using Self-Signed Certificates

2011-10-10T19:52:00.001-07:00

http://weblogs.asp.net/scottgu/archive/2007/04/06/tip-trick-enabling-ssl-on-iis7-using-self-signed-certificates.aspx

Calling WCF services using jQuery

2011-09-28T11:33:00.001-07:00

http://www.jppete.com/calling-wcf-services-using-jquery/

Consuming WCF / ASMX / REST service using JQueryConsuming WCF / ASMX / REST service using JQuery

2011-09-24T22:59:00.000-07:00

http://www.codeproject.com/KB/aspnet/WCF_JQUERY_ASMX.aspx

http://www.c-sharpcorner.com/UploadFile/sridhar_subra/116/

Forms Authentication in ASP.NET with C#: Advance

2011-09-23T11:27:00.000-07:00

http://www.dotnetfunda.com/articles/article141.aspx

10 Ways to Instantly Increase Your jQuery Performance

2011-09-17T05:36:00.001-07:00

http://www.tvidesign.co.uk/blog/improve-your-jquery-25-excellent-tips.aspx

http://jonraasch.com/blog/10-advanced-jquery-performance-tuning-tips-from-paul-irish

How to use append correctly

2011-04-30T21:30:00.001-07:00

http://www.learningjquery.com/2009/03/43439-reasons-to-use-append-correctly

2011-04-28T11:09:00.001-07:00

JQUERY Create,insert,update,delete
http://dotnetfriendly.blogspot.com/2011/01/jquery-datatables-in-aspnet-with-crud.html

15 Great jQuery Plugins For Better Table Manipulation
http://www.webdesignbooth.com/15-great-jquery-plugins-for-better-table-manipulation/

jquery slideshow automatic

2011-04-23T13:47:00.001-07:00

http://www.devirtuoso.com/2009/08/jquery-slideshow-explained/

Sql Queries Information

2011-04-23T00:30:00.000-07:00

1.)if you want to check, last 7 days sp created in database use this..

SELECT * FROM sys.objects WHERE type = 'P' AND DATEDIFF(D,create_date, GETDATE()) < 7

2.)Find Text In Store Procedure:

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%Users%'
AND ROUTINE_TYPE='PROCEDURE'

3.) Check tables created in database last 7 days:

SELECT * FROM sys.tables WHERE type = 'U' AND DATEDIFF(D,create_date, GETDATE()) < 14

4.) List of All tables in Database:

SELECT * from sys.tables where type_desc = 'USER_TABLE'

5.) List of All users Sps in Database.
SELECT * FROM sys.objects WHERE type = 'P'

Load Content On scrolling

2011-04-20T10:39:00.001-07:00

http://www.go4coding.com/post/2011/04/11/Auto-loading-content-on-page-scroll-in-aspnet-using-jquery.aspx

Check TextBox Value in Database With jQuery

2011-04-14T22:04:00.001-07:00

http://forums.asp.net/p/1584699/4001877.aspx

Datalist with custom paging

2011-04-14T22:03:00.001-07:00

http://www.dotnetfunda.com/articles/article456-custom-seo-friendly-paging-with-aspnet-repeater-or-datalist-control-.aspx

Url Rewriting

2011-03-22T21:23:00.000-07:00

http://www.myprotein.com/uk/pages/home

http://www.deevelop.com/en/web-design-company/blog/12/Multilingual-website.html

Apply Indexes on sql server

2011-03-20T12:56:00.001-07:00

http://www.youtube.com/watch?v=P97_oFfD218&feature=fvwrel

Writing Faster SQL Server Queries
http://www.youtube.com/watch?v=H7tPyVA7tRY&feature=related

setting session on iis

2011-03-15T11:32:00.001-07:00

http://www.youtube.com/watch?v=O4ef6GWBzys

session or cookie

http://www.youtube.com/watch?v=LdFVybHluqE

Google Like Search textbox

2011-03-15T00:37:00.001-07:00

Ajax

http://www.codeproject.com/KB/aspnet/Search_SuggestTextBox.aspx

Jquery:
http://www.eggheadcafe.com/tutorials/aspnet/18b6a1fa-a7cf-4507-84f2-15056fe65bb7/autocompletion-with-jque.aspx

webservice:
http://www.dotnetspider.com/forum/266496-Create-application-ASP-net-like-Google-search.aspx

Call server side function using JQuery in Asp.Net

2011-03-13T12:48:00.001-07:00

Call server side function using JQuery in Asp.Net
http://www.dotnetspark.com/kb/1453-call-server-side-function-using-jquery-asp-net.aspx

Using jQuery with ASP .NET
http://dotnetslackers.com/articles/ajax/Using-jQuery-with-ASP-NET.aspx

WCF Videos

2011-03-13T10:41:00.000-07:00

http://www.youtube.com/watch?v=D3GbTYuwSy4&feature=related
http://www.youtube.com/watch?v=0mORV2Tovb8

demo:
http://carvingcode.blogspot.com/2010/04/creating-wcf-web-service-with-vs2010.html

web service

2011-03-01T11:18:00.000-08:00

Create and Use ASP.NET Web Service in Visual Studio 2008
http://www.youtube.com/watch?v=qOqEKpYbTzw&feature=related

Window Service

2011-03-01T10:53:00.000-08:00

part1: http://www.youtube.com/watch?v=RSHWX2jPMyA&feature=related
part2:http://www.youtube.com/watch?v=31WtOj0lpVU
=================================================================
http://www.youtube.com/watch?v=a2J_XZW2S4I
---------------------------------------------------------------
example:
Birthday Wish Scheduler in C#:
http://www.c-sharpcorner.com/UploadFile/prvn_131971/BirthdayWishScheduler02022006012557AM/BirthdayWishScheduler.aspx

new things

2011-02-26T11:31:00.000-08:00

1.)logout user when login from another place.

2.)2 different website attach.one website is as a a pluggable.

How to use Global.asax file to redirect the user ?

2011-02-25T09:23:00.001-08:00

http://ipaddressextensions.codeplex.com/

http://stackoverflow.com/questions/5083794/how-to-use-global-asax-file-to-redirect-the-user

Geolocation error with IP address 127.0.0.1
http://stackoverflow.com/questions/3690278/geolocation-error-with-ip-address-127-0-0-1

global.asax

2011-02-24T20:03:00.000-08:00

<%@ Application Language="C#" %>
<%@ Import Namespace="System.IO" %>
<%@ Import Namespace="System.Net" %>
<%@ Import Namespace="System.Net.Mail" %>
<%@ Import Namespace="SRMS.Bll" %>
<%@ Import Namespace="SRMS.BO" %>

script runat="server">

void Application_Start(object sender, EventArgs e)
{
// Code that runs on application startup

}

void Application_End(object sender, EventArgs e)
{
// Code that runs on application shutdown

}

void Application_Error(object sender, EventArgs e)
{
// Exception err = (Exception)Server.GetLastError().InnerException;
//Log the error details

//string errorText = "

Error Message:" +
// err.Message.ToString() +
// "

Stack Trace: " +
// err.StackTrace.ToString() +
// "

" +
// "

Error in: " +
// Request.Url.ToString() +
// "

" + "

Location ID(Location Name) is: " + Session["Session:LocationID"] + "(" + Session["Session:LocationName"] + ")" + "

";

//MailMessage message = new MailMessage();
//message.From = new MailAddress("post@gmailcom");
//message.To.Add(new MailAddress("x@gmail.com"));
//message.CC.Add(new MailAddress("p@gmail.com"));
//message.Subject = "U Error Detail";
//message.Body = errorText;
//message.IsBodyHtml = true;

//SmtpClient client = new SmtpClient("smtp.u.com");
//client.Credentials = new System.Net.NetworkCredential("post@.com", "Tony1234");
//try
//{
//client.Send(message);
//}
//catch (Exception ex)
//{
// ex.Message.ToString();
//}
}

void Session_Start(object sender, EventArgs e)
{
// Code that runs when a new session is started

}

void Session_End(object sender, EventArgs e)
{
// Code that runs when a session ends.
// Note: The Session_End event is raised only when the sessionstate mode
// is set to InProc in the Web.config file. If session mode is set to StateServer
// or SQLServer, the event is not raised.

}

SAAS install

2011-02-10T11:31:00.000-08:00

http://www.youtube.com/watch?v=u61wNjjQhv4

Android

2011-02-10T10:40:00.000-08:00

How To:Install Android SDK on Win7
http://www.youtube.com/watch?v=YeWH6Bj1DYw&feature=related

Google I/O 2008 - An Introduction to Android
http://www.youtube.com/watch?v=yqCj83leYRE&feature=relmfu

http://www.youtube.com/watch?v=x1ZZ-R3p_w8

http://www.youtube.com/watch?v=j8XseabG5j0&feature=relmfu

demo
http://www.youtube.com/watch?v=1FJHYqE0RDg

Installing sharepoint Easy

2011-02-06T10:50:00.000-08:00

sharepoint on window server 2008:
1.)Sharepoint 2010 Beta Installation: Step 1 - Download and Installing Windows 2008 Updates
2.)SharePoint 2010 Beta Installation: Step 2 - Disabling Internet Explorer Security on Windows 2008
3.)SharePoint 2010 Beta Installation: Step 3 - Add Server Roles & .NET Framework 3.5.1
4.)SharePoint 2010 Beta Installation: Step 4 - Installing SQL Server 2008 64-bit
5.)SharePoint 2010 Beta Installation: Step 5 - Downloading and Installing SQL 2008 64-bit Service Pack
6.)SharePoint 2010 Beta Installation: Step 6 - Download Cumulative Update Package 2
7._SharePoint 2010 Beta Installation: Steps 7, 8, 9 - Installing additional prerequisites
8.)SharePoint 2010 Beta Installation: Step 10 - Installing SharePoint 2010 Beta on a single server
9.)Step 11 - Create a SharePoint 2010 Web Application and a Site Collection

-------------------------------------------------
step:1

How to download and install Vmware Workstation 7 for free (32bit and 64bit
-
https://www.vmware.com/tryvmware/?p=vmware-workstation&lp=1
http://www.youtube.com/watch?v=fnCf7sDpVXo&feature=related

-----------------------------------------------------
step:2
How to Install Windows Server 2008 on a Virtual Machine
http://www.microsoft.com/windowsserver2008/en/us/trial-software.aspx
https://profile.microsoft.com/RegSysProfileCenter/wizard.aspx?wizid=209d831f-96fe-4434-ae0b-29a0f5df0f67&lcid=1033
http://www.youtube.com/watch?v=fdyMyw1W2xc

----------------------------
step:3
Create a SharePoint 2010 Web Application
Create a SharePoint 2010 Web Application and a Site Collection
http://www.microsoft.com/downloads/en/confirmation.aspx?FamilyID=43325e40-8934-4c78-ac44-5f0eeb1d42a5&DisplayLang=EN&hash=XZxQ35QPW%2beTzCWZNoegCJncTSV%2bKqSpaB30FAXP39zAcrdm9oLfTrgpclkql/9hD3Zy%2bJ56wwemilVTqEB8XQ%3d%3d
http://www.youtube.com/watch?v=Itcq_VOEAn4&feature=related

---------------------------
step:4
Lesson 1 Creating a new sharepoint site
http://www.youtube.com/watch?v=oBpprYu8tz8&feature=related

window service and mail

2011-02-01T11:51:00.000-08:00

1.)Sending Many emails through Window Service.
2.)use of POP3 to read Mails from gmail.

Sharepoint

2011-02-01T10:19:00.001-08:00

intall:
http://www.youtube.com/watch?v=vuR0SVMjTwg&feature=related
http://www.youtube.com/watch?v=tJWT1EMMx2s&feature=related
-------------------------------------------------------------
http://www.youtube.com/watch?v=tF23-OceUc0

http://www.youtube.com/watch?v=19NLKQBXxoM&feature=related

Calling web service using jQuery in ASP.NET

2011-01-26T00:30:00.000-08:00

Calling web service using jQuery in ASP.NET

http://codeasp.net/articles/asp-net/217/calling-web-service-using-jquery-in-asp-net

Introduction to WCF Service, remoting,webservice

http://beyondrelational.com/blogs/dinesh/archive/2010/07/11/introduction-to-wcf-service.aspx

ASP.NET and Ajax - using XmlHttpRequest
http://aspdotnetcodebook.blogspot.com/2009/04/aspnet-and-ajax-using-xmlhttprequest.html

Implement: Paging in Repeater or Datalist Control
http://codeasp.net/articles/asp-net/140/implement-paging-in-repeater-or-datalist-control

Add Cart

2011-01-09T10:28:00.000-08:00

namespace Ecommerce.BLL
{
public class AddCart
{

public void BLL_AddItem( Products objBol)
{
ShoppingCart cart = new ShoppingCart();
String cartID = cart.GetShoppingCartId();
Int16 lintCartItemID = 0;

//Declare a datatable to be used as shopping cart
DataTable objDT;
DataRow objDR;

if (System.Web.HttpContext.Current.Session["SessionCart"] == null)
{
//Data table to be used as cart
objDT = new DataTable("Cart");

//Declaring Primary Key For Table
objDT.Columns.Add("ID", System.Type.GetType("System.Int32"));
DataColumn[] ldataColPK = new DataColumn[2];
ldataColPK[0] = objDT.Columns["ID"];
ldataColPK[0].AutoIncrement = true;
ldataColPK[0].AutoIncrementSeed = 1;
objDT.PrimaryKey = ldataColPK;

//Adding columns to datatable
objDT.Columns.Add("CartID", System.Type.GetType("System.String"));
objDT.Columns.Add("ProductID", System.Type.GetType("System.Int32"));
objDT.Columns.Add("Products_Name", System.Type.GetType("System.String"));
objDT.Columns.Add("Model", System.Type.GetType("System.String"));
objDT.Columns.Add("Size", System.Type.GetType("System.String"));
objDT.Columns.Add("Colour", System.Type.GetType("System.String"));
objDT.Columns.Add("ImageUrl", System.Type.GetType("System.String"));
objDT.Columns.Add("Price", System.Type.GetType("System.Double"));
objDT.Columns.Add("Description", System.Type.GetType("System.String"));
objDT.Columns.Add("Quantity", System.Type.GetType("System.Int32"));
objDT.Columns.Add("Stock", System.Type.GetType("System.Int32"));
objDT.Columns.Add("Amount", System.Type.GetType("System.Double"));
objDT.Columns["Amount"].Expression = "Price * Quantity";
}
else
{
objDT = (DataTable)System.Web.HttpContext.Current.Session["SessionCart"];
}

objDR = objDT.NewRow();
objDR["CartID"] = cartID;
objDR["ProductID"] = objBol.ProductsID;
objDR["Products_Name"] = objBol.Products_Name;
objDR["Model"] = objBol.Model;
objDR["Size"] = objBol.attributes_values_name;
objDR["Colour"] = objBol.Colour_name;
objDR["ImageUrl"] = objBol.Icon_image;
objDR["Price"] = objBol.Price;
objDR["Description"] = objBol.Products_Description;
objDR["Quantity"] = objBol.Quantity;
objDR["Stock"] = objBol.Stock;
System.Web.HttpContext.Current.Session["CartItemID"] = objDR["ID"].ToString();
lintCartItemID = Convert.ToInt16(objDR["ID"]);
objDT.Rows.Add(objDR);

//Add the datatable in a session variable
System.Web.HttpContext.Current.Session["SessionCart"] = objDT;

}
=======================================
shopping cart:

public String GetShoppingCartId()
{

// Obtain current HttpContext of ASP+ Request
System.Web.HttpContext context = System.Web.HttpContext.Current;

// If the user is authenticated, use their customerId as a permanent shopping cart id
if (context.User.Identity.Name != "")
{
return context.User.Identity.Name.ToString();
}

// If user is not authenticated, either fetch (or issue) a new temporary cartID
if (context.Request.Cookies["ASPNETCommerce_CartID"] != null)
{
return context.Request.Cookies["ASPNETCommerce_CartID"].Value;
}
else
{
// Generate a new random GUID using System.Guid Class
Guid tempCartId = Guid.NewGuid();

// Send tempCartId back to client as a cookie
context.Response.Cookies["ASPNETCommerce_CartID"].Value = tempCartId.ToString();

// Return tempCartId
return tempCartId.ToString();
}
}

Save Image as small, medium and large

2011-01-09T10:17:00.000-08:00

using System;
using System.Collections.Generic;
using System.Text;
using System.Web;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Drawing;
using System.Web.UI;
using System.Drawing.Imaging;

namespace Ecommerce.BLL
{
public class ImagesManager
{
///

/// This method is used to upload images according to height width
///

///
///
///
///
public void Bll_UploadImages(string FileName,int width, int height, string SaveName)
{

Bitmap oCounter;
Graphics oGraphics;
oCounter = new Bitmap(width ,height);
oGraphics = Graphics.FromImage(oCounter);
FileStream fs = new FileStream(FileName, FileMode.OpenOrCreate);
fs.ReadByte();
Bitmap objImage = new Bitmap(fs);
oGraphics.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.HighQualityBicubic;
oGraphics.SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.HighQuality;
oGraphics.PixelOffsetMode = System.Drawing.Drawing2D.PixelOffsetMode.HighQuality;
oGraphics.CompositingQuality = System.Drawing.Drawing2D.CompositingQuality.HighQuality;
oGraphics.DrawImage(objImage, 0, 0, width, height);
oCounter.Save(SaveName);
objImage.Dispose();
oCounter.Dispose();
fs.Dispose();
File.Delete(FileName);

}
}
}
================================================================
protected void imgSubmit_Click(object sender, ImageClickEventArgs e)
{

if (ViewState["ImageID"].ToString() == "")
{
objBol.Products_imageID = -1;
}
else
{
objBol.Products_imageID = Convert.ToInt32(ViewState["ImageID"]);
}
objBol.ProductsID = Convert.ToInt32(ViewState["ProductsID"]);
objBol.ColourID = Convert.ToInt32(DropColour.SelectedValue);
objBol.Colour_name = DropColour.SelectedItem.Text;
objBol.Icon_image = "";
objBol.Medium_image = "";
objBol.Large_image = "";
objBol.default_style = false;
int retval= objBll.BLL_InsUpdProductsImages (objBol);
if (retval > 0)
{
string strImagePath, strSavepath;

strImagePath = retval.ToString() + "1.jpg";
strSavepath = retval.ToString() + ".jpg";
if (ProductImageUpload .FileName != "")
{
// small icon
string strsmalliconPath = Server.MapPath("~/ProductsImages/Small/" + strImagePath);
string strsmalliconsavePath = Server.MapPath("~/ProductsImages/Small/" + strSavepath);
ProductImageUpload.SaveAs(strsmalliconPath);
objImg.Bll_UploadImages(strsmalliconPath, 50, 50, strsmalliconsavePath);
//icon image
string striconPath = Server.MapPath("~/ProductsImages/Icon/" + strImagePath);
string striconsavePath = Server.MapPath("~/ProductsImages/Icon/" + strSavepath);
ProductImageUpload.SaveAs(striconPath);
objImg.Bll_UploadImages(striconPath, 120, 120, striconsavePath);
//medium image
string strMediumPath = Server.MapPath("~/ProductsImages/Medium/" + strImagePath);
string strMediumsavePath = Server.MapPath("~/ProductsImages/Medium/" + strSavepath);
ProductImageUpload.SaveAs(strMediumPath);
objImg.Bll_UploadImages(strMediumPath,288, 360, strMediumsavePath);
//large image
string strLargePath = Server.MapPath("~/ProductsImages/Large/" + strImagePath);
string strLargesavePath = Server.MapPath("~/ProductsImages/Large/" + strSavepath);
ProductImageUpload.SaveAs(strLargePath);
objImg.Bll_UploadImages(strLargePath, 576, 720, strLargesavePath);
}
}
DisplayProductsImages();
ViewState["ImageID"] = "";
}

Adding a Javascript onclick event to a Radio Button List Item on DataBound

2010-12-28T11:11:00.000-08:00

http://www.siphilp.co.uk/archive/2007/11/08/adding-a-javascript-onclick-event-to-a-radio-button-list.aspx

Rad-Combobox databind at Clientside using javascript

http://www.telerik.com/community/forums/aspnet-ajax/combobox/rad-combobox-databind-at-clientside-using-javascript.aspx

JavaScript Split String Function
http://programming.top54u.com/Samples/Javascript/String-Object/Split-String-Function/Default.aspx

rotate images

2010-12-25T06:21:00.000-08:00

http://fancybox.net/

http://www.huddletogether.com/projects/lightbox2/

http://www.efectorelativo.net/laboratory/noobSlide/

carousse:
http://www.paulvanroekel.nl/picasa/caroussel/
http://demo.tutorialzine.com/2010/11/rotating-slideshow-jquery-css3/

http://www.1stwebdesigner.com/design/fresh-jquery-image-gallery-display-solutions/

jquery zoom and Thumbnail rotate

2010-12-22T08:37:00.000-08:00

http://leandrovieira.com/projects/jquery/lightbox/#

http://www.javascriptphotogallery.com/jquery-image-gallery-zoom-asp-net.html

http://www.professorcloud.com/mainsite/cloud-zoom.htm

http://www.dfc-e.com/metiers/multimedia/opensource/jquery-fancyzoom/

http://www.ajax-zoom.com/index.php?cid=home

http://jquerylightbox.com/asp-net-mvc-jquery-popup.html

http://www.dynamicdrive.com/dynamicindex4/imagemagnify.htm
http://www.dynamicdrive.com/dynamicindex4/imagemagnify.htm
http://www.ajax-zoom.com/demo/magento/index.php/ottoman.html

http://www.catosplace.net/jquery_sandbox/galleryview/index.html

http://web.enavu.com/tutorials/10-best-jquery-gallery-and-slider-plugins/

http://demos.telerik.com/aspnet-ajax/rotator/examples/gallery/defaultcs.aspx

iframe youtube

2010-12-13T13:36:00.001-08:00

http://www.dynamicdrive.com/forums/archive/index.php/t-47803.html

Dynamically Output A List of YouTube Videos In ASP.NET

2010-12-12T13:58:00.001-08:00

http://surinder.computing-studio.com/post/2009/05/Dynamically-Output-A-List-of-YouTube-Videos-In-ASPNET.aspx

AI39si50OOMnhiZKAqaYo9EaxOH900UCbvwkGbUVDhfxuOjFEg7wR2gC8nXsoZuc_MfHvBznmrzL5Qn-L30AA6jKkXL6IKoANA

http://code.google.com/apis/youtube/2.0/developers_guide_dotnet.html

Download file In RadajaxPanel

2010-11-01T12:41:00.000-07:00

http://www.telerik.com/help/aspnet-ajax/ajxdownload.html

Download PDF,DOC file from Radgrid .

2010-10-31T05:11:00.001-07:00

http://demos.telerik.com/aspnet-ajax/grid/examples/generalfeatures/gridattachmentcolumn/defaultcs.aspx

http://www.telerik.com/help/aspnet-ajax/grdconditionalimagedisplayingridcolumn.html

http://www.longhorncorner.com/UploadFile/prathore/3091/Default.aspx

http://aspalliance.com/259

OnKeyUp Of Textbox inside Ajaxpanel

2010-08-29T06:09:00.000-07:00

OnKeyUp Of Textbox inside Ajaxpanelhttp://tastyrazors.com/?p=10

http://forums.asp.net/t/1304375.aspx

http://forums.asp.net/t/1100070.aspx

Disable update Panel of Master Page:
http://forums.asp.net/t/1304375.aspx

Call Server Side function from Client Side Code using PageMethods in ASP.NET AJAX

2010-08-21T13:30:00.000-07:00

http://fei29.blogspot.com/2010/02/call-server-side-function-from-client.html

Check gridview header checkbox if all item checkbox are checked

2010-08-21T03:11:00.000-07:00


<script language="javascript" type="text/javascript">
<!--
        
        function ChangeCheckBoxState(id, checkState) {
            var cb = document.getElementById(id);
            if (cb != null)
                cb.checked = checkState;
        }

        function ChangeAllCheckBoxStates(checkState) {
            // Toggles through all of the checkboxes defined in the CheckBoxIDs array
            // and updates their value to the checkState input parameter
            if (CheckBoxIDs != null) {
                for (var i = 0; i < CheckBoxIDs.length; i++)
                    ChangeCheckBoxState(CheckBoxIDs[i], checkState);
            }
        }

        function ChangeHeaderAsNeeded() {
            // Whenever a checkbox in the GridView is toggled, we need to
            // check the Header checkbox if ALL of the GridView checkboxes are
            // checked, and uncheck it otherwise
            if (CheckBoxIDs != null) {
                // check to see if all other checkboxes are checked
                for (var i = 1; i < CheckBoxIDs.length; i++) {
                    var cb = document.getElementById(CheckBoxIDs[i]);
                    if (!cb.checked) {
                        // Whoops, there is an unchecked checkbox, make sure
                        // that the header checkbox is unchecked
                        ChangeCheckBoxState(CheckBoxIDs[0], false);
                        return;
                    }
                }

                // If we reach here, ALL GridView checkboxes are checked
                ChangeCheckBoxState(CheckBoxIDs[0], true);
            }
        }

-->
    </script> 


protected void grdStudents_DataBound(object sender, EventArgs e)
        {
            if (grdStudents.Rows.Count > 0)
            {
                CheckBox cbHeader = (CheckBox)grdStudents.HeaderRow.FindControl("HeaderLevelCheckBox");

                cbHeader.Attributes["onclick"] = "ChangeAllCheckBoxStates(this.checked);";

                List<String> ArrayValues = new List<string>();
                ArrayValues.Add(String.Concat("'", cbHeader.ClientID, "'"));

                foreach (GridViewRow gvr in grdStudents.Rows)
                {
                    CheckBox cb = (CheckBox)gvr.FindControl("chkSelect");
                    cb.Attributes["onclick"] = "ChangeHeaderAsNeeded();";
                    ArrayValues.Add(String.Concat("'", cb.ClientID, "'"));
                }

                CheckBoxIDsArray.Text = @"<script type=""text/javascript"">" + "\r\n" +
                            "<!--" + "\r\n" +
                            String.Concat("var CheckBoxIDs =  new Array(", String.Join(",", ArrayValues.ToArray()), ");") + "\r\n" +
                            "// -->" + "\r\n" +
                            "</script>";
            }
        }

HTML fieldset

2010-08-21T02:21:00.000-07:00


<tr>
            <td class="field" style="width: 582px">
                <fieldset style="background-color: #F8F3E3;">
                    <legend>
                        <asp:Label ID="lblStudentManagement" runat="server" CssClass="labelTextBold">Management</asp:Label>
                    </legend>
                    <table border="0" align="center" cellpadding="0" cellspacing="5" style="width: 582px;
                        height: 186px">
                        <tr>
                            <td style="width: 8%">
                                &nbsp;
                            </td>
                            <td class="txt_color" style="width: 59%" valign="top">
                                <ul class="listmenu">
                                    <li><a href="Enroll.aspx" target="_self">Enrol</a></li>
                                    <li><a href="List.aspx">List</a></li>
                                   
                                </ul>
                            </td>
                            <td valign="top">
                                <br />
                            </td>
                        </tr>
                    </table>
                </fieldset>
            </td>
        </tr>

find text in all sp of a particular sql database.

2010-08-08T10:58:00.001-07:00

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%Reassign%'
AND ROUTINE_TYPE='PROCEDURE'

User not to enter Numberor Decimal in textbox..

2010-08-04T12:11:00.000-07:00

By AJAX:
http://forums.asp.net/p/1288474/3802854.aspx
-------------
1.How to check if a textbox contains a number

http://bytes.com/topic/asp-net/insights/654366-how-check-if-textbox-contains-number

2. check user not enter decimal value in textbox


txtCourseFee.Attributes["OnKeyPress"] = "javascript:CheckDecimal(event);";

 function CheckDecimal(event) {

            var isNS4 = (navigator.appName == "Netscape") ? 1 : 0;

            if (!isNS4) {
                if (event.keyCode < 46 || event.keyCode > 57)
                    event.returnValue = false;
            }
            else {

                if (event.which < 46 || event.which > 57) return false;
            }
        }

3.) If textbox contain No number then Blank it.


txtCourseFee.Attributes["onblur"] = "javascript:isNotNumberThenBlank(" + txtCourseFee.ClientID + ");";

 function isNotNumberThenBlank1(obj) {
            if (obj.value.search(/[^0-9^.^ ]/) != -1) {
                obj.value = "";
                obj.focus();
                alert('Please enter only numeric value');
                return false;

            }

            return true;
        }

4.) Confirmation on button click
btnSave.Attributes["OnClick"] = "javascript:return confirmation();";


function ConfirmSave() {
            var retVal = confirm("This will save Student information. Do you want to continue ?");
            return retVal;
        }

DropDown list Inside GridView

2010-08-04T11:48:00.000-07:00

1.DropDown list Inside GridView
http://www.dotnetspider.com/resources/26560-DropDown-List-inside-Gridview.aspx

2.Dropdownlist in gridview footer
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Studio_.NET_2005/Q_23238330.html

RadAjaxManager alert telerik

2010-07-30T20:42:00.000-07:00

RadAjaxManager1.ResponseScripts.Add("alert('Please select atleast one Recipient')");

Execute Reader and List:

int ret = 0;
SqlCommand objCmd = new SqlCommand("UspInsertUpdate_DashBoard", objCon);
objCmd.CommandType = CommandType.StoredProcedure;
#region Parameters Ordte Products
objCmd.Parameters.Add("@intDashBoardId", SqlDbType.BigInt).Value = objUI.DashBoardId;
objCmd.Parameters.Add("@intUserId", SqlDbType.BigInt).Value = objUI.UserId;
objCmd.Parameters.Add("@chvnModule", SqlDbType.NVarChar).Value = objUI.Module;
objCmd.Parameters.Add("@chvnExp", SqlDbType.NVarChar).Value = objUI.Exp;
objCmd.Parameters.Add("@chvnTitle", SqlDbType.NVarChar).Value = objUI.Title;

#endregion
try
{
objCon.Open();
ret = Convert.ToInt32(objCmd.ExecuteScalar());

}
catch
{
}
finally
{
objCmd.Dispose();
objCon.Close();
}
return ret;
=====================================

list:

SqlCommand objcmd = new SqlCommand("UspDisplayAccounts", objCon);
objcmd.CommandType = CommandType.StoredProcedure;
objcmd.Parameters.Add("@intUserId", SqlDbType.Int).Value = UserId;
List objList = new List();
SqlDataReader objDr;
objCon.Open();
objDr = objcmd.ExecuteReader();
try
{

while (objDr.Read())
{
Accounts objBol = new Accounts();
objBol.AccountId = Convert.ToInt32(objDr["crm_cust_info_pk"]);
objBol.Title = objDr["crm_cust_acc_title"].ToString();
objBol.CompanyName = objDr["Name"].ToString();
objBol.CreateDate = Convert.ToDateTime(objDr["crm_cust_create_date"]);
objBol.AddressId = Convert.ToInt32(objDr["crm_add_fk"]);
objBol.CreatedByName = objDr["created_by_name"].ToString();
objBol.AssignTo = objDr["assigned_to_name"].ToString();
objList.Add(objBol);
}
}
catch
{
}
finally
{
objDr.Close();
objCon.Close();
objcmd.Dispose();
}
return objList;

Radgrid View Products aspx

2010-07-30T11:41:00.000-07:00

Tool for write in box:http://www.accessify.com/tools-and-wizards/developer-tools/quick-escape/default.php

<%@ Page Language="C#" AutoEventWireup="true" Theme="Admin" CodeFile="ViewProducts.aspx.cs"
    Inherits="Admin_Products_ViewProducts" %>

<%@ Register Assembly="RadGrid.Net2" Namespace="Telerik.WebControls" TagPrefix="radG" %>
<%@ Register Src="../UserControls/HeaderBar.ascx" TagName="HeaderBar" TagPrefix="uc1" %>
<%@ Register Src="../UserControls/Footer.ascx" TagName="Footer" TagPrefix="uc2" %>
<!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>View Products</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <div id="maincontainer">
            <!--Maincontainer starts here-->
            <div id="main_header">
                <!--Main Header starts here-->
                <uc1:HeaderBar ID="HeaderBar1" runat="server" />
            </div>
            <!--Main Header ends here-->
            <div id="body">
                <!--Body starts here-->
                <div id="bodyinnerpart">
                    <!--Body Inner starts here-->
                    <div id="body_left">
                        <!--Body left panel starts here-->
                        <div id="body_leftinner">
                            <table width="100%" border="0" cellspacing="0" cellpadding="0">
                                <tr>
                                    <td colspan="2" align="left" valign="middle" class="body_left_h1">
                                        Products
                                    </td>
                                </tr>
                                <tr>
                                    <td class="body_left_h2" style="background-color: #FFFFFF;">
                                        <a href="AddProducts.aspx">Add Products</a>
                                    </td>
                                    <td style="background-color: #FFFFFF;" class="body_left_bdr">
                                        <img src="../images/moreicon.gif" width="7" height="13" />
                                    </td>
                                </tr>
                                <tr>
                                    <td width="93%" class="body_left_h2" style="background-color: #FFFFFF;">
                                        <a href="Attributes.aspx">Add Attributes</a>
                                    </td>
                                    <td width="7%" style="background-color: #FFFFFF;" class="body_left_bdr">
                                        <img src="../images/moreicon.gif" width="7" height="13" />
                                    </td>
                                </tr>
                                <tr>
                                    <td class="body_left_h2" style="background-color: #FFFFFF;">
                                        <a href="AddColour.aspx">Add Colours</a>
                                    </td>
                                    <td style="background-color: #FFFFFF;" class="body_left_bdr">
                                        <img src="../images/moreicon.gif" width="7" height="13" />
                                    </td>
                                </tr>
                            </table>
                        </div>
                        <div id="body_leftinner1">
                        </div>
                    </div>
                    <!--Body left panel ends here-->
                    <div id="body_right">
                        <!--Body right panel starts here-->
                        <div id="body_right_top" class="body_right_h1">
                            <asp:LinkButton ID="lkparent" runat="server" Text="Â» Products"></asp:LinkButton>
                            &nbsp;
                        </div>
                        <div id="body_right_inner1">
                            <table width="638" border="0" align="left" cellpadding="0" cellspacing="0">
                                <tr>
                                    <td width="576" align="right" style ="padding-bottom :3px;">
                                    <asp:TextBox ID="textsearch" runat ="server" Width="130px" ></asp:TextBox>
                                        
                                    </td>
                                    <td width="62" align="right" style ="padding-bottom :3px;">
                                        <asp:ImageButton ID ="Imgsearch" runat ="server"
                                            ImageUrl ="../images/searchbutton.gif" width="57" height="19" 
                                            onclick="Imgsearch_Click" />
                                    </td>
                                </tr>
                            </table>
                        </div>
                        <div id="body_right_inner">
                         
                        </div>
                    </div>
                    <!--Body right panel ends here-->
                </div>
                <!--Body Inner ends here-->
            </div>
            <!--Body ends here-->
            <div id="footer">
                <!--Footer starts here-->
                <uc2:Footer ID="Footer1" runat="server" />
            </div>
            <!--Footer ends here-->
        </div>
    </div>
    </form>
</body>
</html>
   <radG:RadGrid ID="RadgridDisplayProducts" runat="server" Skin="WebBlue" Width="638px"
                                AutoGenerateColumns="False" GridLines="None" OnDeleteCommand="RadgridDisplayProducts_DeleteCommand"
                                OnNeedDataSource="RadgridDisplayProducts_NeedDataSource" 
                                OnItemCommand="RadgridDisplayProducts_ItemCommand" AllowPaging="True" 
                                EnableAJAX="True" EnableAJAXLoadingTemplate="True" PageSize="20">
                                <ExportSettings>
                                    <Pdf PageWidth="8.5in" PageRightMargin="" PageFooterMargin="" PageLeftMargin="" PageTopMargin=""
                                        PageHeight="11in" PageBottomMargin="" PageHeaderMargin=""></Pdf>
                                </ExportSettings>
                                <MasterTableView DataKeyNames="ProductsID">
                                    <ExpandCollapseColumn Visible="False" Resizable="False">
                                        <HeaderStyle Width="20px"></HeaderStyle>
                                    </ExpandCollapseColumn>
                                    <RowIndicatorColumn Visible="False">
                                        <HeaderStyle Width="20px"></HeaderStyle>
                                    </RowIndicatorColumn>
                                    <Columns>
                                        <radG:GridBoundColumn DataField="Products_Name" HeaderText="Product Name" UniqueName="column">
                                            <HeaderStyle Width="250px" />
                                            <ItemStyle CssClass="gridtext" />
                                        </radG:GridBoundColumn>
                                        <radG:GridBoundColumn DataField="Model" HeaderText="Product Code" UniqueName="column">
                                            <HeaderStyle Width="150px" />
                                            <ItemStyle CssClass="gridtext" />
                                        </radG:GridBoundColumn>
                                        <radG:GridTemplateColumn>
                                            <ItemTemplate>
                                                <asp:ImageButton ID="Imgbtnedit" runat="server" CausesValidation="false" CommandName="View"
                                                    ImageUrl="../images/view.gif" />
                                            </ItemTemplate>
                                            <ItemStyle Width="120px" CssClass="gridpadding2" />
                                        </radG:GridTemplateColumn>
                                        <radG:GridButtonColumn ConfirmText="Delete this Record?" ButtonType="ImageButton"
                                            ImageUrl="../images/delete.gif" CommandName="Delete" Text="Delete" UniqueName="DeleteColumn"
                                            FilterImageUrl="~/RadControls/GridSkin/Telerik/Filter.gif" SortAscImageUrl="~/RadControls/GridSkin/Telerik/SortAsc.gif"
                                            SortDescImageUrl="~/RadControls/GridSkin/Telerik/SortDesc.gif">
                                            <ItemStyle Width="98px" HorizontalAlign="center" />
                                        </radG:GridButtonColumn>
                                    </Columns>
                                </MasterTableView>
                            </radG:RadGrid>


using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using Ecommerce.BLL;
using Ecommerce.BOL;

public partial class Admin_Products_ViewProducts : System.Web.UI.Page
{
    ProductsManager objBll = new ProductsManager();
    CategoriesManager objcat = new CategoriesManager();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Request.QueryString["cid"] != null)
            {
                ViewState["CategoryID"] = Request.QueryString["cid"].ToString();
            }
            else
            {
                ViewState["CategoryID"] = "-1";
            }
            
            DisplayProducts();
            GenrateXML();
        }
    }
    private void GenrateXML()
    {
        DataSet objds = objcat.BLL_GetProductsXML();

        objds.WriteXml(Server.MapPath("../../Main.xml"));
    }
  
    private void DisplayProducts()
    {
        
            RadgridDisplayProducts.DataSource = objBll.BLL_DspProducts(Convert.ToInt32(ViewState["CategoryID"]));
            RadgridDisplayProducts.DataBind();
       
        
    }
    protected void RadgridDisplayProducts_ItemCommand(object source, Telerik.WebControls.GridCommandEventArgs e)
    {
        if (e.CommandName == "View")
        {
            int PID = Convert.ToInt32(RadgridDisplayProducts.MasterTableView.DataKeyValues[e.Item.ItemIndex]["ProductsID"]);
            Response.Redirect("ProductDetail.aspx?PID=" + PID.ToString());
        }
    }
    protected void RadgridDisplayProducts_DeleteCommand(object source, Telerik.WebControls.GridCommandEventArgs e)
    {
         int ProductsID = Convert.ToInt32(RadgridDisplayProducts.MasterTableView.DataKeyValues[e.Item.ItemIndex]["ProductsID"]);
         
        
         objBll.BLL_DeleteProducts(ProductsID);
         DisplayProducts();
    }
    protected void RadgridDisplayProducts_NeedDataSource(object source, Telerik.WebControls.GridNeedDataSourceEventArgs e)
    {

        //RadgridDisplayProducts.DataSource = objBll.BLL_DspProducts();
        RadgridDisplayProducts.DataSource = objBll.BLL_DspProducts(Convert.ToInt32(ViewState["CategoryID"]));
    }
    protected void Imgsearch_Click(object sender, ImageClickEventArgs e)
    {
        {
            RadgridDisplayProducts.DataSource = objBll.BLL_ADM_ProductSearch(textsearch.Text.Trim());
            RadgridDisplayProducts.DataBind();
        }
    }
}


using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using Ecommerce.BOL;

namespace Ecommerce.DAL
{
    class ProductsDB : AppConfig
    {
        //Insert Update  Products
        public int DAL_InsUpdProducts(Products objBol)
        {
            SqlCommand objCmd = new SqlCommand("ADM_InsUpdProductsInfo", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.Add("@ProductsID", SqlDbType.Int).Value = objBol.ProductsID;
            objCmd.Parameters.Add("@Products_Name", SqlDbType.NVarChar).Value = objBol.Products_Name;
            objCmd.Parameters.Add("@Products_Description", SqlDbType.NVarChar).Value = objBol.Products_Description;
            objCmd.Parameters.Add("@Meta_keywords", SqlDbType.NVarChar).Value = objBol.Meta_keywords;
            objCmd.Parameters.Add("@Products_Type", SqlDbType.Int).Value = objBol.Products_Type;
            objCmd.Parameters.Add("@Show_quantity", SqlDbType.Bit).Value = objBol.Show_quantity;
            objCmd.Parameters.Add("@Model", SqlDbType.NVarChar).Value = objBol.Model;
            objCmd.Parameters.Add("@Price", SqlDbType.Decimal).Value = objBol.Price;
            objCmd.Parameters.Add("@Active", SqlDbType.Bit).Value = objBol.Active;
            objCmd.Parameters.Add("@Meta_Description", SqlDbType.NVarChar).Value = objBol.Meta_Description;
            objCmd.Parameters.Add("@Meta_Title", SqlDbType.NVarChar).Value = objBol.Meta_Title;
            objCon.Open();
            int intRetval = Convert.ToInt32(objCmd.ExecuteScalar());
            objCmd.Dispose();
            objCon.Close();
            return intRetval;


        }
        // Insert Update Products Images
        public int DAL_InsUpdProductsImages(Products objBol)
        {
            SqlCommand objCmd = new SqlCommand("ADM_InsUpdProductImages", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.Add("@Products_imageID", SqlDbType.Int).Value = objBol.Products_imageID;
            objCmd.Parameters.Add("@ProductsID", SqlDbType.Int).Value = objBol.ProductsID;
            objCmd.Parameters.Add("@ColourID", SqlDbType.Int).Value = objBol.ColourID;
            objCmd.Parameters.Add("@Icon_image", SqlDbType.VarChar).Value = objBol.Icon_image;
            objCmd.Parameters.Add("@Medium_image", SqlDbType.VarChar).Value = objBol.Medium_image;
            objCmd.Parameters.Add("@Large_image", SqlDbType.VarChar).Value = objBol.Large_image;
            objCmd.Parameters.Add("@Colour_name", SqlDbType.VarChar).Value = objBol.Colour_name;
            objCmd.Parameters.Add("@default_style", SqlDbType.Bit).Value = objBol.default_style;
            objCon.Open();
            int intRetval = Convert.ToInt32(objCmd.ExecuteScalar());
            objCmd.Dispose();
            objCon.Close();
            return intRetval;


        }
        // Update Images status [ADM_UpdImagesStatus]
        public int DAL_UpdImagesStatus(int ProductsID, int Products_imageID)
        {
            SqlCommand objCmd = new SqlCommand("ADM_UpdImagesStatus", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.Add("@Products_imageID", SqlDbType.Int).Value =Products_imageID;
            objCmd.Parameters.Add("@ProductsID", SqlDbType.Int).Value = ProductsID;
            objCon.Open();
            int intRetval = Convert.ToInt32(objCmd.ExecuteScalar());
            objCmd.Dispose();
            objCon.Close();
            return intRetval;


        }
        // Insert Update Products Size Quantity
        public int DAL_InsUpdProductsSize(Products objBol)
        {
            SqlCommand objCmd = new SqlCommand("ADM_InsUpdProductsSize", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.Add("@Products_sizeID", SqlDbType.Int).Value = objBol.Products_sizeID;
            objCmd.Parameters.Add("@ProductsID", SqlDbType.Int).Value = objBol.ProductsID;
            objCmd.Parameters.Add("@attributes_values_id", SqlDbType.Int).Value = objBol.attributes_values_id;
            objCmd.Parameters.Add("@attributes_values_name", SqlDbType.VarChar).Value = objBol.attributes_values_name;
            objCmd.Parameters.Add("@ColourID", SqlDbType.Int).Value = objBol.ColourID;
            objCmd.Parameters.Add("@Quantity", SqlDbType.Int).Value = objBol.Quantity;
            objCmd.Parameters.Add("@Reorder_level", SqlDbType.Int).Value = objBol.Reorder_level;
            objCon.Open();
            int intRetval = Convert.ToInt32(objCmd.ExecuteScalar());
            objCmd.Dispose();
            objCon.Close();
            return intRetval;


        }
        // Insert Update Products TO Categories
        public int DAL_InsUpdProductsToCategories(Products objBol)
        {
            SqlCommand objCmd = new SqlCommand("ADM_InsUpdProductsToCategories", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.Add("@Products_categoryID", SqlDbType.Int).Value = objBol.Products_categoryID;
            objCmd.Parameters.Add("@ProductsID", SqlDbType.Int).Value = objBol.ProductsID;
            objCmd.Parameters.Add("@CategoryID", SqlDbType.Int).Value = objBol.CategoryID;
            objCon.Open();
            int intRetval = Convert.ToInt32(objCmd.ExecuteScalar());
            objCmd.Dispose();
            objCon.Close();
            return intRetval;


        }

        //---------------------------------------------------------------------------------Display Products 
        public List Dal_DspProducts(Int32 CategoryID)
        {
            SqlCommand objCmd = new SqlCommand("ADM_DspProducts", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.Add("@CategoryID", SqlDbType.BigInt).Value = CategoryID;
            SqlDataReader objDr;
            objCon.Open();
            objDr = objCmd.ExecuteReader();
            List objList = new List();
            if (objDr.HasRows)
            {
                while (objDr.Read())
                {

                    Products objBol = new Products();
                    objBol.ProductsID = Convert.ToInt32(objDr["ProductsID"]);
                    objBol.Products_Name = objDr["Products_Name"].ToString();
                    objBol.Model = objDr["Model"].ToString();
                    objList.Add(objBol);
                }
            }
            objDr.Close();
            objCmd.Dispose();
            objCon.Close();
            return objList;
        }
        //Display Products By ID


        public List Dal_DspProductsBYID(Int32 ProductsID)
        {
            SqlCommand objCmd = new SqlCommand("ADM_DspProductsBYID", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.Add("@ProductsID", SqlDbType.Int).Value = ProductsID;
            SqlDataReader objDr;
            objCon.Open();
            objDr = objCmd.ExecuteReader();
            List objList = new List();
            if (objDr.HasRows)
            {

                objDr.Read();
                Products objBol = new Products();
                objBol.ProductsID = Convert.ToInt32(objDr["ProductsID"]);
                objBol.Products_Name = objDr["Products_Name"].ToString();
                objBol.Model = objDr["Model"].ToString();
                objBol.Products_Description = objDr["Products_Description"].ToString();
                objBol.Meta_keywords = objDr["Meta_keywords"].ToString();
                objBol.Products_Type = Convert.ToInt32(objDr["Products_Type"]);
                objBol.Show_quantity = Convert.ToBoolean(objDr["Show_quantity"]);
                objBol.Price = Convert.ToDecimal(objDr["Price"]);
                objBol.Active = Convert.ToBoolean(objDr["Active"]);
                objBol.Meta_Description = objDr["Meta_Description"].ToString();
                objBol.Meta_Title = objDr["Meta_Title"].ToString();
                objList.Add(objBol);

            }
            objDr.Close();
            objCmd.Dispose();
            objCon.Close();
            return objList;
        }
        //Dipslay product Details [ADM_DspProductsDetail]
        public DataSet Dal_DspProductsDetails(int productID)
        {
            SqlDataAdapter objadp = new SqlDataAdapter("ADM_DspProductsDetail", objCon);
            objadp.SelectCommand.CommandType = CommandType.StoredProcedure;
            objadp.SelectCommand.Parameters.Add("@ProductsID", SqlDbType.Int).Value = productID;
            DataSet objds = new DataSet();
            objadp.Fill(objds);
            return objds;
        }
    //[ADM_ProductSearch]
 //@searchItem varchar(50)
        public DataSet Dal_ADM_ProductSearch(string searchItem)
        {
            SqlDataAdapter objadp = new SqlDataAdapter("ADM_ProductSearch", objCon);
            objadp.SelectCommand.CommandType = CommandType.StoredProcedure;
            objadp.SelectCommand.Parameters.Add("@searchItem", SqlDbType.VarChar).Value = searchItem;
            DataSet objds = new DataSet();
            objadp.Fill(objds);
            return objds;
        }
        // Display Products Size [ADM_DspProductsSize]
        public DataSet Dal_DspProductsSize(int productID)
        {
            SqlDataAdapter objadp = new SqlDataAdapter("ADM_DspProductsSizeBYID", objCon);
            objadp.SelectCommand.CommandType = CommandType.StoredProcedure;
            objadp.SelectCommand.Parameters.Add("@ProductsID", SqlDbType.Int).Value = productID;
            DataSet objds = new DataSet();
            objadp.Fill(objds);
            return objds;
        }
       
        public List Dal_FillProductsolour(int productID)
        {
            SqlCommand objCmd = new SqlCommand("ADM_FillProductsColour", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.Add("@ProductsID", SqlDbType.Int).Value = productID;
            SqlDataReader objDr;
            objCon.Open();
            objDr = objCmd.ExecuteReader();
            List objList = new List();
            if (objDr.HasRows)
            {
                while (objDr.Read())
                {

                    Colour objBol = new Colour();
                    objBol.ColourID = Convert.ToInt32(objDr["ColourID"]);
                    objBol.Colour_name = objDr["Colour_name"].ToString();
                    objList.Add(objBol);
                }
            }
            objDr.Close();
            objCmd.Dispose();
            objCon.Close();
            return objList;
        }
        //Display products Category [ADM_DspProducts_Category]
        public DataSet DAL_DiplayProductsCategories(int ProductsID)
        {
            SqlDataAdapter objadp = new SqlDataAdapter("ADM_DspProducts_Category", objCon);
            objadp.SelectCommand.CommandType = CommandType.StoredProcedure;
            objadp.SelectCommand.Parameters.Add("@ProductsID", SqlDbType.Int).Value = ProductsID;
            DataSet objds = new DataSet();
            objadp.Fill(objds);
            return objds;
        }
        public List Dal_DspProductsImages(int productID)
        {
            SqlCommand objCmd = new SqlCommand("ADM_DspProducts_images", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.Add("@ProductsID", SqlDbType.Int).Value = productID;
            SqlDataReader objDr;
            objCon.Open();
            objDr = objCmd.ExecuteReader();
            List objList = new List();
            if (objDr.HasRows)
            {
                while (objDr.Read())
                {

                    Products objBol = new Products();
                    objBol.Products_imageID = Convert.ToInt32(objDr["Products_imageID"]);
                    objBol.ProductsID = Convert.ToInt32(objDr["ProductsID"]);
                    objBol.ColourID = Convert.ToInt32(objDr["ColourID"]);
                    objBol.Icon_image = objDr["Icon_image"].ToString();
                    objBol.Medium_image = objDr["Medium_image"].ToString();
                    objBol.Large_image =objDr["Large_image"].ToString ();
                    objBol.Colour_name = objDr["Colour_name"].ToString();
                    objBol.default_style = Convert.ToBoolean (objDr["default_style"]);
                    objList.Add(objBol);
                }
            }
            objDr.Close();
            objCmd.Dispose();
            objCon.Close();
            return objList;
        }
        //[ADM_DspProducts_imagesBYID]
        public List Dal_DspProductsImagesBYID(int productID)
        {
            SqlCommand objCmd = new SqlCommand("ADM_DspProducts_imagesBYID", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.Add("@Products_imageID", SqlDbType.Int).Value = productID;
            SqlDataReader objDr;
            objCon.Open();
            objDr = objCmd.ExecuteReader();
            List objList = new List();
            if (objDr.HasRows)
            {

                objDr.Read();
                    Products objBol = new Products();
                    objBol.Products_imageID = Convert.ToInt32(objDr["Products_imageID"]);
                    objBol.ProductsID = Convert.ToInt32(objDr["ProductsID"]);
                    objBol.ColourID = Convert.ToInt32(objDr["ColourID"]);
                    objBol.Icon_image = objDr["Icon_image"].ToString();
                    objBol.Medium_image = objDr["Medium_image"].ToString();
                    objBol.Large_image = objDr["Large_image"].ToString();
                    objBol.Colour_name = objDr["Colour_name"].ToString();
                    objBol.default_style = Convert.ToBoolean(objDr["default_style"]);
                    objList.Add(objBol);
               
            }
            objDr.Close();
            objCmd.Dispose();
            objCon.Close();
            return objList;
        }
        //Delete Products Images [ADM_DelProductsImages]
        public int DAL_DeleteProductsImages(int ProductImageID)
        {

            SqlCommand objCmd = new SqlCommand("ADM_DelProductsImages", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.Add("@Products_imageID", SqlDbType.Int).Value = ProductImageID;
            objCon.Open();
            int intRetval = Convert.ToInt32(objCmd.ExecuteScalar());
            objCmd.Dispose();
            objCon.Close();
            return intRetval;


        }
        //Delete Products To Categories [ADM_DelProductsToCategories]
        public void DAL_DeleteProductsToCategories(int Products_categoryID)
        {

            SqlCommand objCmd = new SqlCommand("ADM_DelProductsToCategories", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.Add("@Products_categoryID", SqlDbType.Int).Value = Products_categoryID;
            objCon.Open();
            objCmd.ExecuteNonQuery();
            objCmd.Dispose();
            objCon.Close();

        }
        //Delete Products Size [ADM_DelProductsSize]
        public void DAL_DeleteProductsSize(int Products_sizeID)
        {

            SqlCommand objCmd = new SqlCommand("ADM_DelProductsSize", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.Add("@Products_sizeID", SqlDbType.Int).Value = Products_sizeID;
            objCon.Open();
            objCmd.ExecuteNonQuery();
            objCmd.Dispose();
            objCon.Close();

        }
        //Delte Products From all related tables [ADM_DelProducts]
        public void DAL_DeleteProducts(int ProductsID)
        {

            SqlCommand objCmd = new SqlCommand("ADM_DelProducts", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.Add("@ProductsID", SqlDbType.Int).Value = ProductsID;
            objCon.Open();
            objCmd.ExecuteNonQuery();
            objCmd.Dispose();
            objCon.Close();

        }
        //////////////////////////////Colour///////////////////////////////

        public int DAL_InsUpdColour(Colour objBol)
        {
            SqlCommand objCmd = new SqlCommand("ADM_InsUpdColour", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.Add("@ColourID", SqlDbType.Int).Value = objBol.ColourID;
            objCmd.Parameters.Add("@Colour_name", SqlDbType.NVarChar).Value = objBol.Colour_name;
            objCon.Open();
            int intRetval = Convert.ToInt32(objCmd.ExecuteScalar());
            objCmd.Dispose();
            objCon.Close();
            return intRetval;


        }
        public List Dal_DspColour()
        {
            SqlCommand objCmd = new SqlCommand("ADM_DspColour", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;

            SqlDataReader objDr;
            objCon.Open();
            objDr = objCmd.ExecuteReader();
            List objList = new List();
            if (objDr.HasRows)
            {
                while (objDr.Read())
                {

                    Colour objBol = new Colour();
                    objBol.ColourID = Convert.ToInt32(objDr["ColourID"]);
                    objBol.Colour_name = objDr["Colour_name"].ToString();
                    objList.Add(objBol);
                }
            }
            objDr.Close();
            objCmd.Dispose();
            objCon.Close();
            return objList;
        }
        public void DAL_DeleteColour(int ColourID)
        {

            SqlCommand objCmd = new SqlCommand("ADM_DelColour", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.Add("@ColourID", SqlDbType.Int).Value = ColourID;
            objCon.Open();
            objCmd.ExecuteNonQuery();
            objCmd.Dispose();
            objCon.Close();

        }

        ///////////////////////////////CLIENT SITE FUNCTIONS/////////////////////////////
        //To Display Rotate Products [Get_Products]
        public DataSet Dal_GetRotateProducts(int CategoryID)
        {
            SqlDataAdapter objadp = new SqlDataAdapter("Get_Products", objCon);
            objadp.SelectCommand.CommandType = CommandType.StoredProcedure;
            objadp.SelectCommand.Parameters.Add("@CategoryID", SqlDbType.Int).Value = CategoryID;
            DataSet objds = new DataSet();
            objadp.Fill(objds);
            return objds;
        }
        // To Display Products Detail [Get_ProductsDetail]
        public DataSet Dal_Get_ProductsDetail(int ProductsID)
        {
            SqlDataAdapter objadp = new SqlDataAdapter("Get_ProductsDetail", objCon);
            objadp.SelectCommand.CommandType = CommandType.StoredProcedure;
            objadp.SelectCommand.Parameters.Add("@ProductsID", SqlDbType.Int).Value = ProductsID;
            DataSet objds = new DataSet();
            objadp.Fill(objds);
            return objds;
        }
        //Display Products Size [Get_ProductsSize]
        public DataSet Dal_Get_ProductsSize(int ColourID,int ProductsID)
        {
            SqlDataAdapter objadp = new SqlDataAdapter("Get_ProductsSize", objCon);
            objadp.SelectCommand.CommandType = CommandType.StoredProcedure;
            objadp.SelectCommand.Parameters.Add("@ColourID", SqlDbType.Int).Value = ColourID;
            objadp.SelectCommand.Parameters.Add("@ProductsID", SqlDbType.Int).Value = ProductsID;
            DataSet objds = new DataSet();
            objadp.Fill(objds);
            return objds;
        }
        //Displya Products Colour [Get_ProductsColour]
        public DataSet Dal_Get_ProductsColour(int ProductsID)
        {
            SqlDataAdapter objadp = new SqlDataAdapter("Get_ProductsColour", objCon);
            objadp.SelectCommand.CommandType = CommandType.StoredProcedure;
            objadp.SelectCommand.Parameters.Add("@ProductsID", SqlDbType.Int).Value = ProductsID;
            
            DataSet objds = new DataSet();
            objadp.Fill(objds);
            return objds;
        }
    }
}

Visual Studio shortcuts

2010-07-24T22:38:00.001-07:00

http://msdn.microsoft.com/en-us/library/da5kh0wa%28VS.80%29.aspx

How to implement Custom paging Using ASP.NET Data Grid

2010-07-22T12:22:00.000-07:00

How to implement Custom paging Using ASP.NET Data Grid

You have Inbuilt paging facility for some of the data binding control like data grid. But it can be very inefficient. Control like repeater you don’t have inbuilt data binding facility. When you are using inbuilt paging facility it loads all the rows so very resource consuming and inefficient. But when you are using custom paging facility you return only requested rows.

Here we will examine how can we implement custom paging for data Grid using stored procedure. Here is the implementation of stored procedure. Here you have 3 parameter for stored procedure.

@page is basically page number in data grid

@pageSize is Number of records you are going to show one page

@TotalNofRecords is output parameter. It return total Number of records in the Query

Here when you go through the stored procedure you have create a tempory table and you retrieve only required data rows from that tempory table. Using @StartRecordNo and @EndRecordNo

Create PROCEDURE [dbo].[GetEmployee]

(

@Page int,

@PageSize int,

@TotalNofRecords int output

)

AS

BEGIN

SET NOCOUNT ON

DECLARE @StartRecordNo int, @EndRecordNo int

IF (@Page=0)

BEGIN

SET @StartRecordNo = 1

SET @EndRecordNo = @PageSize

END

ELSE

BEGIN

SET @StartRecordNo = @PageSize * @Page + 1

SET @EndRecordNo = (@PageSize * (@Page+1) )

END

CREATE TABLE [#TmpEmployee]

(

[RowNo] int identity(1,1),

[EmployName] int not null,

[Address] varchar(255)

)

INSERT INTO [#TmpEmployee]([EmployName], [Address])

SELECT

FirstName, Address1

FROM Employee

ORDER BY FirstName

SELECT @TotalNofRecords = COUNT( FirstName) FROM [#TmpEmployee]

SET NOCOUNT OFF

SELECT [RowNo], [FirstName], [Address]

FROM [#TmpEmployee]

WHERE [RowNo]>= @StartRecordNo

AND [RowNo]<= @EndRecordNo

RETURN 0

END

When you bind the grid you can have method call BindGrid method

private void BindGrid(int pageNo)

{

try

{

int locationId ;

int recordsPerPage = 10 ;

int totalRecords = 0;

DataTable empList = EmpService.GetEmployee( pageNo, recordsPerPage ,ref totalRecords);

if (empList.Rows.Count > 0)

{

uxEmployeGrid.DataSource = jobsList;

uxEmployeGrid.VirtualItemCount = totalRecords;

uxEmployeGrid.DataBind();

}

}

catch(Exception ex)

{

throw ex;

}

}

When call the first time call the BindGrid Method with pageNo = 0

BindGrid(0);

When click the paging call the BindGrid method

protected void uxEmployeGrid_PageIndexChanged(object source, DataGridPageChangedEventArgs e)

{

uxEmployeGrid.CurrentPageIndex = e.NewPageIndex;

BindGrid(uxEmployeGrid.CurrentPageIndex);

}

asynchronous

2010-07-22T11:35:00.001-07:00

http://www.webopedia.com/TERM/A/asynchronous.html
http://forums.asp.net/p/753551/805432.aspx

Radcombo

2010-07-21T20:05:00.001-07:00

New mobile Technology--Android

2010-07-11T06:58:00.000-07:00

http://www.android.com/

Best Walk in Jobs

2010-07-09T11:15:00.001-07:00

http://bestwalkinjobs.com/

Free Sql server Training

2010-07-02T10:03:00.000-07:00

http://www.sqlservervideos.com/

http://weblogs.asp.net/scottgu/archive/2007/03/01/free-sql-server-training-videos-and-other-good-data-tutorial-pointers.aspx

http://www.learnitfirst.com/Course/152/SQL-Server-2005-DBA/TheBigList.aspx

Forms Authentication and Roles in ASP.NET with C#: Advance

2010-07-02T03:01:00.000-07:00

http://www.dotnetfunda.com/articles/article114.aspx

http://www.dotnetfunda.com/articles/article141.aspx

http://www.codeproject.com/KB/aspnet/custom_authentication.aspx

Authentication and Authorization in ASP.NET

2010-07-01T23:29:00.001-07:00

http://aspalliance.com/907_Authentication_and_Authorization_in_ASPNET.1

WHY Jquery used over javascript

2010-07-01T12:58:00.000-07:00

http://15daysofjquery.com/quicker/4/

MVC Central

2010-06-29T04:25:00.001-07:00

http://www.mvccentral.net/

Interfaces in C#

2010-06-26T00:35:00.001-07:00

http://www.codeguru.com/csharp/csharp/cs_syntax/interfaces/article.php/c7563/Interfaces-in-C.htm

Diamond problem

2010-06-26T00:19:00.001-07:00

http://en.wikipedia.org/wiki/Diamond_problem

Why multiple Inheritance is not possible in C#?

2010-06-26T00:04:00.000-07:00

http://www.geekinterview.com/question_details/27160

Explaining C# Abstraction, Inheritence and Polymorphism

2010-06-25T23:27:00.001-07:00

http://www.csharphelp.com/2007/08/explaining-c-abstraction-inheritence-and-polymorphism/

OOPS Concepts and .NET Part 2:

2010-06-25T22:53:00.001-07:00

http://www.c-sharpcorner.com/uploadfile/eecabral/oopsand.net211102005075520am/oopsand.net2.aspx

http://www.c-sharpcorner.com/UploadFile/ecabral/OOPSandDotNET106252005024236AM/OOPSandDotNET1.aspx

Forums of Different Languages

2010-06-20T09:57:00.001-07:00

http://forums.asp.net/p/1337412/2699239.aspx#2699239 and my blog at http://geekswithblogs.net/TATWORTH/Default.aspx

select only date/time part of a datetime

2010-06-18T23:24:00.001-07:00

How can I select only date/time part of a datetime value?
--------------------------------------------------------------------------------

Answer:

--to select date part only
SELECT CONVERT(char(10),GetDate(),101)

--to select time part only
SELECT right(GetDate(),7)

Business Logic Layer importance

2010-06-17T00:38:00.001-07:00

http://www.dotnetfunda.com/forums/thread482-business-logic-layer-importance.aspx

Understanding three tier architecture

2010-06-17T00:27:00.001-07:00

http://www.c-sharpcorner.com/UploadFile/rishiraveendran/806/Default.aspx

Master Page change at runtime

2010-06-16T08:46:00.001-07:00

http://www.codeproject.com/KB/aspnet/Changing_Master_Page.aspx

ASP.NET Validation in Depth

2010-06-15T00:16:00.000-07:00

http://msdn.microsoft.com/en-us/library/aa479045.aspx

Advantages and disadvantages of state management

2010-06-15T00:09:00.000-07:00

http://msdn.microsoft.com/en-us/library/z1hkazw7.aspx

ASP.NET Page Life Cycle Overview

2010-06-14T23:44:00.002-07:00

http://msdn.microsoft.com/en-us/library/ms178472.aspx

METHOD = GET post

2010-06-14T23:44:00.001-07:00

http://www.htmlcodetutorial.com/forms/_FORM_METHOD_GET.html

Introducing Serialization in .NET

2010-06-14T21:40:00.000-07:00

http://aspalliance.com/983_Introducing_Serialization_in_NET.all

const, static and readonly

2010-06-12T03:48:00.001-07:00

http://en.csharp-online.net/const,_static_and_readonly

What's the advantage of disadvantage of using static method for data access

2010-06-12T03:38:00.000-07:00

http://forums.asp.net/t/1343290.aspx?PageIndex=2

http://odetocode.com/articles/313.aspx
http://odetocode.com/Articles/314.aspx

Static Methods in C# .NET

2010-06-12T03:08:00.000-07:00

http://www.homeandlearn.co.uk/csharp/csharp_s10p10.html

Delegates and Events in C# / .NET

2010-06-12T03:03:00.001-07:00

http://www.akadia.com/services/dotnet_delegates_and_events.html

Generic Types in C# 2.0 with Sample

2010-06-10T10:33:00.000-07:00

http://www.c-sharpcorner.com/UploadFile/abhishekbhatore/GenericTypeWithSample07292005092634AM/GenericTypeWithSample.aspx

Another Way to Access an Element

2010-06-10T05:15:00.000-07:00

http://www.pageresource.com/dhtml/ryan/part4-2.html

Different Types of Serialization

2010-06-10T04:55:00.001-07:00

http://www.informit.com/articles/article.aspx?p=29457&seqNum=3

Cryptography in .NET

2010-06-10T04:42:00.000-07:00

http://www.c-sharpcorner.com/UploadFile/Suprotim/CryptographyInDotNET11282005053700AM/CryptographyInDotNET.aspx

Explain about Protected and protected internal, ?internal? access-specifier?

2010-06-10T04:27:00.000-07:00

http://www.allinterview.com/showanswers/4903.html

Table Variables In T-SQL

2010-06-10T02:29:00.001-07:00

http://odetocode.com/code/365.aspx

Use ADODB.RecordSet in C#

2010-06-10T02:10:00.001-07:00

http://homeofcox-cs.blogspot.com/2009/07/use-adodbrecordset-in-c.html

Letter Writing

2010-06-06T11:39:00.001-07:00

http://www.letterwritingguide.com/

How updatepanel work?

2010-06-04T08:18:00.001-07:00

http://author.aspalliance.com/1315_AJAXenable_an_Existing_ASPNET_Web_Page.all

2010-06-04T08:17:00.000-07:00

How Ajax Works??

2010-06-04T07:54:00.001-07:00

http://www.interaktonline.com/Support/Articles/Details/AJAX:+Asynchronously+Moving+Forward-How+does+AJAX+work%3F.html?id_art=36&id_asc=308

Group options in DropDownList

2010-05-30T23:13:00.000-07:00

http://weblogs.asp.net/alaaalnajjar/archive/2009/11/16/group-options-in-dropdownlist.aspx

Programming video

2010-05-29T04:37:00.000-07:00

http://www.programmingvideotutorials.com/csharp/csharp-interface

Determine Browser type from Server side using ASP.NET & C#?

2010-05-19T07:22:00.001-07:00

http://stackoverflow.com/questions/2311077/how-to-determine-browser-type-from-server-side-using-asp-net-c

HTTP ERRORS CODES

2010-05-19T07:02:00.000-07:00

http://www.modemhelp.net/httperrors/httperrors.shtml

Grid View Paging and Sorting

2010-05-09T13:15:00.000-07:00

Grid View Paging and Sorting

http://www.dotnetspider.com/resources/1249-Grid-View-Paging-Sorting.aspx

Implement sorting in GridView without using DataSources
http://aspdotnetcode.source-of-humor.com/Articles/GridView/ImplementDataSortingInGridViewUsingDataTable.aspx

Refresh Web Pages After Download Completed

2010-05-09T13:13:00.000-07:00

Refresh Web Pages After Download Completed

http://www.eggheadcafe.com/tutorials/aspnet/3889fc21-1562-4d1b-89e4-cea5576690b2/refresh-web-pages-after-d.aspx

JavaScript Refresh Page

http://www.quackit.com/javascript/javascript_refresh_page.cfm

Google Translator

2010-04-29T05:35:00.001-07:00

http://translate.google.com/#

Google forum for Custom Search, Checkout Merchant, Google Chat, Google Sites

2010-04-29T05:30:00.000-07:00

http://www.google.com/support/forum/