Asp.net, Sqlite, Jquery,HTML 5, Sql Server,vb, C#, Javascript,Sugarcrm API, WCF ,WPF, WWF,MVC

Total number of records of all tables in a MSSQL database

noreply@blogger.com (SImplyAsp) — Wed, 22 Apr 2015 13:47:00 +0530

Total number of records of all tables in a MSSQL database

Run the below query agganist the database you want the result

SELECT      QUOTENAME(SCHEMA_NAME(sOBJ.schema_id)),QUOTENAME(sOBJ.name) AS [TableName]      , SUM(sdmvPTNS.row_count) AS [RowCount]FROM      sys.objects AS sOBJ      INNER JOIN sys.dm_db_partition_stats AS sdmvPTNS            ON sOBJ.object_id = sdmvPTNS.object_id
WHERE      sOBJ.type = 'U'
      AND sOBJ.is_ms_shipped = 0x0      AND sdmvPTNS.index_id < 2GROUP BY
      sOBJ.schema_id
      , sOBJ.name      having SUM(sdmvPTNS.row_count)>0ORDER BY [TableName]
GO

If u had any trouble just ask, Happy to help u :)
Stay Tune...
Have a nice day... 'N happy Coding :)

Introducing MathCap for Asp.Net [ Math Captcha Plugin ]

noreply@blogger.com (SImplyAsp) — Fri, 2 May 2014 12:53:00 +0530

MathCap is a plugin for .net application and its a 100% effective and easy to use.the more you understand on a deep look.

Here i shared is the base version of Mathcap 1.0.0. More feature are coming on a newer versions.

How it use?

add mathcapp dll reference

invoke the namespace on the webpage using MathCapcha;

Add the below code
var bitmapImage = new Capcha();
var properties = new MathCapchaProperties();
now customise the properties

now get the response and point to image control, using below code.

               var imgur = bitmapImage.CreateThumbnail(properties);
 
               img.Src = imgur.bmpImageSource;

Response.Write(imgur.answer);

Output

NOTE: In near by future itself 'm planning to make it a control but before that i need to add some cool feature that by i made it like this :)

DOWNLOAD dll From here

If u had any trouble just ask, Happy to help u :)
Stay Tune...
Have a nice day... 'N happy Coding :)

GET SET in C#

noreply@blogger.com (SImplyAsp) — Wed, 2 Apr 2014 15:14:00 +0530

Get:
The get { } implementation must include a return statement. It can access any member on the class.

Set:
The set { } implementation receives the implicit argument 'value', which is the value to which the property is assigned.

keep the sessionID on url

noreply@blogger.com (SImplyAsp) — Thu, 13 Mar 2014 18:32:00 +0530

keep the sessionID on url

Recently i found an intersting stuff around axisbank url.

upcoming feature in c#

noreply@blogger.com (SImplyAsp) — Mon, 3 Mar 2014 10:22:00 +0530

1.Add "?." operator to C#

2.Allow "default" values on automatic properties

These are some of the upcoming feature expecting in c# by there next update.http://visualstudio.uservoice.com/ visual studio admin team announced these stuff.

more info:

http://visualstudio.uservoice.com/forums/121579-visual-studio/suggestions/3990187-add-operator-to-c-

http://visualstudio.uservoice.com/forums/121579-visual-studio/suggestions/2163145-allow-default-values-on-automatic-properties

If u had any trouble just ask, Happy to help u :)

Stay Tune...

Have a nice day... 'N happy Coding :)

Restore data after browser crash

noreply@blogger.com (SImplyAsp) — Tue, 28 Jan 2014 17:47:00 +0530

Restore data after browser crash

Its a client requirement and we implemented by using html 5 localstorage feature. Here i'm providing a sample of that.

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Local storage</title>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.min.js"></script>
</head>
<body>
<div>
<div>
<div>
<label>Name:</label>
</div>
<div>
<input type="text" id="name" />
</div>
<div>
<input type="button" id="btnSave" value="Save" />
</div>
</div>
</div>
<script type="text/javascript">
$(document).ready(function () {
function init() {
if (localStorage["name"]) {
$("#name").val(localStorage["name"]);
}
}
init();
});
$('input').change(function () {
localStorage[$(this).attr("id")] = $(this).val();
});
$("#btnSave").click(function() {
localStorage.clear();
});
</script>
</body>
</html>

DEMO

If u had any trouble just ask, Happy to help u :)
Stay Tune...
Have a nice day... 'N happy Coding :)

Quick walk over most used JavaScript function

noreply@blogger.com (SImplyAsp) — Wed, 15 Jan 2014 13:02:00 +0530

Quick walk over most used JavaScript function

Again a url :). This one helps to make a quick walk over the stuff we done previously.

https://code.google.com/p/jslibs/wiki/JavascriptTips

If u had any trouble just ask, Happy to help u :)
Stay Tune... Have a nice day... 'N happy Coding :)

everything (almost) about ViewState

noreply@blogger.com (SImplyAsp) — Tue, 14 Jan 2014 11:21:00 +0530

Recently i had read an article about the view state management in c# and its go through much deeply also.
http://aspnetresources.com/articles/ViewState

Thanks to the author for sharing such a good articles :)

If u had any trouble just ask, Happy to help u :)
Stay Tune...
Have a nice day... 'N happy Coding :)

Using linq and lambda expression in c#

noreply@blogger.com (SImplyAsp) — Thu, 19 Dec 2013 15:53:00 +0530

using linq and lambda expression in c#

using linq and lambda expression in c# to filter data.

Select all
Select some filed
Select filtering data with condition
Select Anonymous Type / Casting
Merging two columns
Ordering
Joining two list
Skip and Take

button click event not fire from jquery dialog

noreply@blogger.com (SImplyAsp) — Mon, 11 Nov 2013 15:58:00 +0530

button click event not fire from JQUERY dialog

Its a common issues.the defalut value of button property "UseSubmitBehavior" is true.

That expresses the button will use the browser's submit mechanism. However, jQuery Dialog UI is manipulating it.

There exists a conflict. If you want to fired the button click event. Please set its property "UseSubmitBehavior" as false.

<asp:Button ID="Button1" runat="server" Text="Button" UseSubmitBehavior="false" OnClick="Button1_Click" />

If u had any trouble just ask, Happy to help u :)
Stay Tune...
Have a nice day... 'N happy Coding :)

Pagging in sql

noreply@blogger.com (SImplyAsp) — Thu, 7 Nov 2013 15:35:00 +0530

In one of my older post i posted about paging in sql using Row_Number function (http://simplyasp.blogspot.in/2010/11/paging-records-using-sql-server-2005.html).on latest version of sql they had improved the paging functionality by bothe performance base and also in readbility base too. on 2008 they introduce CTE (Common table expression) and Derived table. on sql 2012 they done a mass step on that FETCH NEXT functionality ... i love that.

Below i show all the method of paging i mentioned above.

--SQL 2005/2008 Paging Method Using Derived Table

DECLARE @Start INT

DECLARE @End INT

SELECT @Start = 14000,@End = 14050

SELECT LastName, FirstName, EmailAddress

FROM (SELECT LastName, FirstName, EmailAddress,

ROW_NUMBER() OVER (ORDER BY LastName, FirstName, EmailAddress) AS RowNumber

FROM Employee) EmployeePage

WHERE RowNumber > @Start AND RowNumber <= @End

ORDER BY LastName, FirstName, EmailAddress

--SQL 2005/2008 Paging Method Using CTE

DECLARE @Start INT

DECLARE @End INT

SELECT @Start = 14000,@End = 14050;

WITH EmployeePage AS

(SELECT LastName, FirstName, EmailAddress,

ROW_NUMBER() OVER (ORDER BY LastName, FirstName, EmailAddress) AS RowNumber

FROM Employee)

SELECT LastName, FirstName, EmailAddress

FROM EmployeePage

WHERE RowNumber > @Start AND RowNumber <= @End

ORDER BY LastName, FirstName, EmailAddress

--SQL SERVER 2012

SELECT LastName, FirstName, EmailAddress

FROM Employee

ORDER BY LastName, FirstName, EmailAddress

OFFSET 14000 ROWS

FETCH NEXT 50 ROWS ONLY;

If u had any trouble just ask, Happy to help u :)
Stay Tune...
Have a nice day... 'N happy Coding :)

linq to loop through datatable c#

noreply@blogger.com (SImplyAsp) — Wed, 30 Oct 2013 15:36:00 +0530

Iterating through a data table using linq in c#

i faced a criteria to trim a row value with some criteria,

Before trimming

After trimming

C# Code

If u had any trouble just ask, Happy to help u :)
Stay Tune...
Have a nice day... 'N happy Coding :)

Paste Special OR Json attribute to class in C-Sharp C#

noreply@blogger.com (SImplyAsp) — Tue, 24 Sep 2013 18:22:00 +0530

Convert JSON attribute to Class in c# Or Paste Special in Visual Studio 2012

Action Delegates in c#

noreply@blogger.com (SImplyAsp) — Mon, 23 Sep 2013 16:44:00 +0530

In my last post i shown FUNC Delegates now going around ACTION delegates

Action instance can receive parameters, but cannot return values.

Example below:

How to execute a line
How to execute a method

using FUNC in c#

noreply@blogger.com (SImplyAsp) — Thu, 19 Sep 2013 17:40:00 +0530

Here i'm presenting how to use FUNC in C#

Simple Example

SQL Function return SQL TABLE

noreply@blogger.com (SImplyAsp) — Wed, 18 Sep 2013 11:58:00 +0530

using table values parameter we can achieve it

Function :

CREATE FUNCTION FunctionName
(
@id INT
)
returns table as
return
(
Select * from TableName WHERE id=@id
)

How to call:

select * from FunctionName(1)

If u had any trouble just ask, Happy to help u :)
Stay Tune...
Have a nice day... 'N happy Coding :)

HAPPY ONAM 2013

noreply@blogger.com (SImplyAsp) — Tue, 17 Sep 2013 11:46:00 +0530

I Wish You A Very Happy Onam,
May The God Bless You And Fill Your Heart
With Joy & Happiness.
May The Color And Lights Of Onam Fill Your Home
With Happiness And Joy.
Have The Most Beautiful Onam.

Setting RadDatePicker Date Without Firing ValueChanged using javascript On Telerik radcontrols

noreply@blogger.com (SImplyAsp) — Wed, 11 Sep 2013 09:27:00 +0530

Hi *.*,

This is the first time I'm writing a post about Telerik rad controls help.

Accessing active directory using c#

noreply@blogger.com (SImplyAsp) — Mon, 15 Jul 2013 17:29:00 +0530

Hi *.*,
Today i'm sharing a snippet to Accessing active directory using c#. i had created a class file for modular access.Here it goes

using System;

using System.DirectoryServices.AccountManagement;

using System.DirectoryServices;

using System.Configuration;

using System.Collections.Generic;

Tutorial for Visual Studio Zen Coding

noreply@blogger.com (SImplyAsp) — Thu, 4 Jul 2013 16:29:00 +0530

Visual Studio Zen Coding is a visual studio plugin for high-speed HTML, XML, XSL (or any other structured code format) coding and editing.

Just type HTML tag in zen syntax and press alt + z to expand tag to normal form. Its so smooth as touching a flower.

Visual Studio Zen Coding 2012

Visual Studio Zen Coding 2010

Visual Studio Zen Coding 2008

Sanitize database inputs

noreply@blogger.com (SImplyAsp) — Thu, 27 Jun 2013 15:29:00 +0530

A lesson to all developers

Sanitize database inputs

If u had any trouble just ask, Happy to help u :)
Stay Tune... Have a nice day... 'N happy Coding :)

call C# dll using Javascript ActiveX Object

noreply@blogger.com (SImplyAsp) — Sun, 21 Apr 2013 12:35:00 +0530

call C# dll using Javascript ActiveX Object

I got a chance to work with siebel crm . The Version they were using is working with ActiveX Object. My objective is we had a dll which has been created in .net class library output.I need to call that library using javascript and do some functionality. Here i'm sharing how i communicate dll with ActiveX using javascript.

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

Retrieve data from sugarcrm using c# api with conditional query

noreply@blogger.com (SImplyAsp) — Fri, 19 Apr 2013 16:52:00 +0530

Retrieve data from sugarcrm using c# api with conditional query

Before going through this module i strongly recommend to go through my previous post abt this topic as i'm writing as a continuation its difficult to get in track for new readers. Previous Post

create an instance of the dll

SugarCRMCL.SugarSOAP.sugarsoap client = new SugarCRMCL.SugarSOAP.sugarsoap();

To reterive data

NB: While using query keep in mind that its key sensitive

If u had any trouble just ask, Happy to help u :)
Stay Tune...
Have a nice day... 'N happy Coding :)

Login Using Sugar API in asp.net c#

noreply@blogger.com (SImplyAsp) — Tue, 9 Apr 2013 17:42:00 +0530

Hi *.*,

Before going through this module i strongly recommend to go through my previous post abt this topic as i'm writing as a continuation its difficult to get in track for new readers. Previous Post

Create an instance of the dll we refereed.

SugarCRMCL.SugarSOAP.sugarsoap client = new SugarCRMCL.SugarSOAP.sugarsoap();

Login Module

Your password should be encrypted before sending to the crm. Sample encryption method below

If u had any trouble just ask, Happy to help u :)
Stay Tune...
Have a nice day... 'N happy Coding :)

Passing store procedure result to another store procedure as parameter

noreply@blogger.com (SImplyAsp) — Mon, 8 Apr 2013 21:50:00 +0530

Passing store procedure result to another store procedure as parameter

-- First Stored ProcedureCREATE PROCEDURE SquareSP@MyFirstParam INT
AS
DECLARE @MyFirstParamSquare INT
SELECT @MyFirstParamSquare = @MyFirstParam*@MyFirstParam-- Additional CodeRETURN (@MyFirstParamSquare)GO
Read more »