Kamal Jindal

Paging using Database - Basis on Page Number and Page Size

noreply@blogger.com (Kamal Jindal) — Mon, 14 Nov 2011 01:33:00 PST

Create Proc [dbo].[uspCustomersWithPaging_Select]
@PageNumber int,
@PageSize int

as

DECLARE @sqlStatement nvarchar(max)
Declare @ErrNo Int
SET NOCOUNT ON
Declare @RowCounter int
Declare @Rec_count int
Declare @Rec_start int, @Rec_End int
set @Rec_start=((@PageNumber-1)*@PageSize)+1
set @Rec_End = @Rec_start + @PageSize -1

Select
@RowCounter=Count(CustomerId)
From
tblCustomers
Begin
With Cte
As
(
SELECT ROW_NUMBER() OVER (order by tblCustomers.CustomerId asc ) AS RowNumber,
CONVERT(varchar(9), @RowCounter) as 'RowCounter' ,
tblCustomers.CustomerId,
Name,
Address1,
Phone,
Mobile,
isNull((Select Sum(isNull(Amount,0)) from tblCustomerCommission where tblCustomerCommission.CustomerId=tblCustomers.CustomerId),0) as 'TotalCommission'
from
tblCustomers
)

Select
RowCounter,
CustomerId,
Name,
Address1,
Phone,
Mobile,
TotalCommission
From
CTE
Where RowNumber between @Rec_start and @Rec_End
End

How To Handle Multiple Results by Using the DataReader

noreply@blogger.com (Kamal Jindal) — Wed, 09 Nov 2011 21:28:36 PST

NextResult() function is used for handle m results by using the DataReader

Example:-

    SqlDataReader reader = cmd.ExecuteReader();
    do
    {

      while (reader.Read())
      {
        for (int field = 0; field < reader.FieldCount; field++)
        {
          // htmlStr.Append(reader.GetName(field).ToString());          
         //  htmlStr.Append(reader.GetValue(field).ToString());
        }
      }
      htmlStr.Append("

");
      i++;
    } while (reader.NextResult());


    reader.Close();

Debugging in Firefox & Internet Explorer

noreply@blogger.com (Kamal Jindal) — Tue, 22 Nov 2011 03:40:39 PST

Add Firebug, measure it and web developer toolbar for Firefox (add-ons)

Add developer toolbar for Internet Explorer

Aggregate Functions (MAX, MIN, SUM, COUNT) on DataTable

noreply@blogger.com (Kamal Jindal) — Tue, 08 Nov 2011 22:33:06 PST

DataTable has a public method called Compute. We can use the aggregate functions in this method as,

StudentTable.Compute("MAX(Row_ID)", "")

public Object Compute(
string expression,
string filter
)

expression (The expression parameter requires an aggregate function. )
Type: System.String
The expression to compute.

filter (filter, determines which rows are used in the expression)
Type: System.String
The filter to limit the rows that evaluate in the expression.

Example

private void ComputeBySalesSalesID(DataSet dataSet)
{
// Presumes a DataTable named "Orders" that has a column named "Total."
DataTable table;
table = dataSet.Tables["Orders"];

// Declare an object variable.
object sumObject;
sumObject = table.Compute("Sum(Total)", "EmpID = 5");
}

Dalhousie Khajjiar Trip (1-4 Oct 2009)

noreply@blogger.com (Kamal Jindal) — Thu, 08 Oct 2009 05:46:13 PDT

Kamal Jindal

Kamal Jindal & Anuj (My Friend)

Rishikesh snap - Kamal Jindal, Rajnish Pandey & Satosh

noreply@blogger.com (Kamal Jindal) — Tue, 07 Jul 2009 05:43:23 PDT

Kamal Jindal, Rajnish Pandey & Satosh

Interview Question for HR

noreply@blogger.com (Kamal Jindal) — Tue, 15 Apr 2008 09:42:33 PDT

Tell me something about yourself?
I believe in characters, values, vision and action. I am quick learner. I learn from my mistakes and others. I try to get a creative solution to problem.

Why do you want to job?
To survive my life, we need income source. For that there are two ways, one is business and second is job. For business, we need big place, much money and deep knowledge of business that I don’t have. For job, I have interest, qualification and working attitude. I have, that’s why I want to do job.

Why we should give you this job?
What is the required qualification, I have. Everybody has some qualifications that are waiting for his turn. I can say only myself because I know my knowledge and quality which will fulfill your requirement. I will not give u chance to repent on my selection that’s why I should be given a chance to work with this dynamic organization.

How can you say “you are best deserving candidate”?
What I am saying to you by words, it can’t be prove by the words. For that, a person should be chance to work. I assure you if I get a chance I will live up to your expectation.

What is your strength or positive point?
Optimistic
Good Learner

What is your weakness or negative point?
Sometimes I get nervous when I talk to my seniors.
I am workaholic.
More time to get decision
Frank
Sometimes Lazy

How do you overcome your workaholic nature?
I have some good friends, when they see me in this condition, they come to me and they make me aware. Because of my friends, I overcome this my weakness.

Define yourself in one word?
Chirpy or Amiable

How long will work with us?
As much as possible, I will work with this company.

If we reject you, how would you react?
I will congratulate that person, who got select their. I will say u to thanks to get me a chance to prepare myself for a good job, because you give me a chance to observe my demerits.

What is ideal job according to you?
Ideal job is that where we can use an education and professional qualification, where we can get a chance to explore our knowledge.

Few Tips To start

noreply@blogger.com (Kamal Jindal) — Tue, 08 Apr 2008 22:24:11 PDT

Few Tips To strt

I wish I was one of your tears, so I could be born in your eye, run down your cheek, and die on your lips.
Did you know they changed the alphabet? They put U andI together.
Are your legs tired? 'cause you been running throughmy mind ALL day long.
Are you lost? 'cause it's so strange to see an angelso far from heaven.
Do you believe in love at first sight, or do I have towalk by you again?
What's that in your eye? Oh...it's a sparkle.
Do you have a map? I just got lost in your eyes.
You can forget about going to heaven because it's sin to look that good.
If I had eleven roses and you, I'd have a dozen.

Hope u will use it and get positive results...

Kamal Jindal

noreply@blogger.com (Kamal Jindal) — Sun, 10 Jan 2010 22:12:51 PST

Kamal Jindal
Senior Software Developer at Classic Informatics Pvt. Ltd.
Email-Id : Kamal.Jindal@classicinformatics.com , Kamal.Jindal@GharExpert.com
Website : http://www.winkbill.com/, http://www.GharExpert.com

Kamal Jindal’s Education

BSC IT from Sikkam Manipal Univeristy
HNC Diploma From NIIT

Kamal Jindal's Blog

www.kamaljindal.blogspot.com

Kamal Jindal's Contact

999 110 1929

Kamal Jindal's Profile on GharExpert.com

www.gharexpert.com/profile/view_profile.aspx?uid=86

GharExpert Profile Of Kamal Jindal Friends

Pawan Batra www.gharexpert.com/profile/view_profile.aspx?uid=97
------------------------------------------------------------------------
Upasna Jindal www.gharexpert.com/profile/view_profile.aspx?uid=111
------------------------------------------------------------------------
Anil Nain www.gharexpert.com/profile/view_profile.aspx?uid=141
------------------------------------------------------------------------
Nitin Garg www.gharexpert.com/profile/view_profile.aspx?uid=142
------------------------------------------------------------------------
Gulshan Bareja www.gharexpert.com/profile/view_profile.aspx?uid=168
------------------------------------------------------------------------
Monica www.gharexpert.com/profile/view_profile.aspx?uid=2027

If u want to create an gharexpert account then click on www.gharexpert.com/home/register_page.aspx

and go to Kamal Jindal Profile By Clicking Below Link:

www.gharexpert.com/profile/view_profile.aspx?uid=86.

Kamal Jindal

noreply@blogger.com (Kamal Jindal) — Sun, 21 Dec 2008 20:18:26 PST

Hello Friends,

I am a Senior Software Developer. Currently working as a Senior Software Developer' in Classic Informatics Private Limited. I am working on a web site named as http://www.Winkbill.com. Winkbill.com is an online invoice application. I worked for anthor website http://www.GharExpert.com.

Winkbill is a simple online invoicing service, working as your complete web based invoicing and billing manager. You can easily create, send, and track all your invoices online with the help of Winkbill.
GharExpert.com is India's fast growing website for interior, exterior, construction, vastu and home improvement resources.

GharExpert.com helps you build your dream home/office by providing all the tips and trick you will ever need. You can ask questions from the community, share your problems, respond to problems as well as share your success stories. You will also find information about the new trends, latest product reviews and expert analysis.

GharExpert.com is for everyone

People building a new home.

People taking up a construction, renovation or home improvement project.

Homemakers making lifestyle design changes to their home.

Youngsters wanting to style their rooms to reflect their youth and passion.

Experts who want to share their knowledge with the community.

Companies intending to showcase their products.

Please create an account on this website by clicking on the link given below

www.gharexpert.com/home/register_page.aspx

Thanks & Regards

Kamal Jindal

Senior Software Developer

Kamal.Jindal@ClassicInformatics.com
Kamal.Jindal@gharexpert.com

0 999 110 1929