Friday, November 30, 2012

Disable weekends/Public Holidays / Saturday & Sunday / change disabled date color in jquery UI DatePicker

Here i will show how to disable WeekEnds or PublicHolidays / Saturday & Sunday in jquery UI datepicker...
Change color of the Disabled / enabled dates of the datepicker...


Friday, November 16, 2012

Create Temporary Table(#Table) in Stored Procedure SQL Server 2005/2008

Here i will show how to create temporary table in Stored Procedure sql server 2005 / 2008

Syntax :



Create table #TableName
(
      --Colun Names
)

Here # is a must when creating Temporary table


EX : 

create proc SP_SPName
(
     // Parameters
)
as
begin

   create table #TempTable

   (
         ID int identity(1,1),
         Name varchar(250),
         Address varchar(500)
   )

 drop #TempTable

End

#TempTable should be dropped else we will get ERROR while executing SP 2nd time..

Function that Splits string in SQL Server / Table Valued Function

In this post i will show how to split a String at certain character and shows the OutPut in as a table.
This is also known as Table Valued Function.

OutPut :

































Thursday, November 15, 2012

Passing multiple records to a Stored Procedure / Passing DataTable to StoredProcedure / table valued parameters in sql server 2008 / SqlDbType.Structured

As the Title Says we can pass Multiple rows to a Stored Procedure or DataTable to a Stored Procedure by using SqlDbType.Structured... 
This is also known as Table valued Parameter which is introduced in SQL Server 2008


AutoComplete using WebServices in asp.net using C#

Here i am going to show you, how to use AutoComplete using webservices in asp.net, C# and jquery...

OutPutt : 

Jquerry Error / Success Message from ClientSide and ServerSide in ASP.Net

In this post i will show How to show round corner ErrorMessage and SuccessMessage in JQuery and the same Messages from ServerSide when error occurs and when the condition is true.....




Wednesday, November 7, 2012

Tool that generates StoredProcedure and C# methods for CRUD operations

This is the tool that generates SP and C# methods for CRUD operations. It is mainly used when there are lots of parameters are there. If parameters are more then it takes more time to create a SP for Insert, Update and Select. To make it simple with few clicks we can generate the code we need.
This may help some one......
This TOOL was Updated U can Download....

































ajax call using jquery in asp.net OR Calling server side methods using JavaScript and JQuery in ASP.Net

As the title says ajax call using jquery in asp.net
             OR
Calling server side methods using JavaScript and JQuery in ASP.Net
In the Other Post showed how to call server side method using ajax calls with out parameters and it was used to bring the url to display the image after image was uploaded Asynchronously.

Now i will show how to check mailID is there or not in the DataBase.






Tuesday, November 6, 2012

Copy DataTable to Another DataTable with Specific Columns using c#.net

Previously in THIS post, showed how to ADD, UPDATE, DELETE in a DataTable using C#.

Now i will show how to copy data from one table to another table for specific columns only as for the requirement at some situations.


Saturday, October 13, 2012

Calling ServerSide Method using Jquery in asp.Net and C#

As the title says we can call Server side methods from client side using Jquery. But in this methods You cannot use Server Controls in that method.

Click Here  to see the link and how it works.

In the above link i used to display the images after uploading with Asynchronous File UploadControl. .

Tuesday, October 9, 2012

Asynchronous File UploadControl To Display Thumbnail Images After Uploading

Previously in This Post Showed how to use Asynchronous File UploadControl to upload images.
Now i will show how to display the uploaded Image in Thumbnail.

OutPut :



Sunday, October 7, 2012

Important Plugins For .Net Developers

Here i will some of the important Applications(Plugins for VS) needed for .Net Developers .
Some Plugins may be Free and others need to be purchased.

Important Plugins for Visual-studio 2008/2010/2012



Plug-in Name
VS 2008/2010
Trail / FREE
Web URL




TortoiseSVN
Not for VS
Free
http://tortoisesvn.net/downloads.html
PowerTools
2010
Free
http://visualstudiogallery.msdn.microsoft.com/d0d33361-18e2-46c0-8ff2-4adea1e34fef
PowerCommands2008
2008
Free
http://archive.msdn.microsoft.com/PowerCommands
PowerCommands2010
2010
Free
http://visualstudiogallery.msdn.microsoft.com/e5f41ad9-4edc-4912-bca3-91147db95b99
VS Power Commands
2010
Free
http://visualstudiogallery.msdn.microsoft.com/e5f41ad9-4edc-4912-bca3-91147db95b99
DevExpress
2008/2010
Trail
www.devexpress.com/
Telerik
2008/2010
Trail
www.telerik.com/



If you know more plugins please share with Comments.

Wednesday, October 3, 2012

Sunday, September 30, 2012

Three-Tire architecture in asp.net Or Windows

Here i will explain How to create Three-tire Architecture in .Net using C#. Here i am not going to show how to use connection string from web.config because, Previously i showed how to use Connection String in Three-Tire architecture from web.config file in this POST.

In this post i am using ASP.Net for my convenience. In realtime also most of the Developers use ASP.Net only.

Here we have 3 projects
  • UI Validation (ASP.Net)
  • BLL (Business Logic Layer)
  • DAL (Data Access Layer)
  1. Create a ASP.Net Project and name it as u like. in my case (ThreeTire) -- UI
  2. In the SolutionExplorer Rightclick on the project u created (ASP.Net) and add Class Project and Name it as U like, in my case (ThreeTire.BLL) -- BLL
  3. Again In the SolutionExplorer Rightclick on the project u created (ASP.Net) and add another Class Project and Name it as U like, in my case (ThreeTire.DAL) -- DAL
Up-to Now  we created 3 projects. Now add reference to one another.

  • First RightClick on the ThreeTire.BLL and add reference of ThreeTire.DAL
  • In the Same way RightClick on the ThreeTire (ASP.Net) project and add reference of ThreeTire.BLL
 
 

Tuesday, September 25, 2012

Wednesday, September 19, 2012

Check / UnCheck Gridview page / All Pages CheckBoxes using Jquery in ASP.Net and c#.Net

In the previous post Check / UnCheck Gridview page CheckBoxes using Jquery in ASP.Net which checks only current page checkboxes of the gridview using Jquery and looses checkbox state when the gridview page was changed.

Here i will show how to check all the check boxes using c#.Net and it maintains checkbox state when gridpages are changed.


ASPX Page :

Check Uncheck All Checkboxes in Gridview Using JQuery

Here i will show how to Check or UnCheck Gridview CheckBoxes using Jquery. As the title says it checks only current gridview page.




Script to check All CheckBoxes :

Accessing session Value in Http Handlers and from Http Handlers

In this post i will explain how to access session Value in Http Handlers and from session value from Http Handlers.

In the previous post Dynamic Thumbnail Images using Http Handlers in asp.net C# explained how to show images using Http Handlers.

To access session value in Http Handler use following code

Ex :

In the code behind


         Session["imgID"] = "2";

Dynamic Thumbnail Images using Http Handlers in asp.net C#

In this post I will show how to display ThumbNail Images Dynamically Using Httphandlers in asp.net and C#. In this post i will Show How to Access Session Values in HttpHandler

Add new generic handler and name it as you like In my case ThumbNail.ashx and the code for this handler can be seen below.

Out Put :



Http Handler (*.ashx) :


Monday, September 17, 2012

Disable Previous Dates in Jquery DatePicker based on Other DatePicker in ASP.Net

As the Title Says Disable previous Days in Jquery Date Picker based on the other DatePicker and here i will show how to display text in the second textbox when first datepicker was selected.

In the other post i was explained  
  1.   Plain text as watermark for password text box using     
  2.   ASP.NET textbox with jQuery UI DatePicker
OutPut :