Comments by Member 11589429 (Top 27 by date)

I got the answer.Here is my logic.SELECT *
FROM (
SELECT [UserId],[CourseId],[SubjectId],[TeacherCode],[RDate],[status],
ROW_NUMBER() OVER(PARTITION BY [UserId],[CourseId],[SubjectId] ORDER BY [UserId],[CourseId],[SubjectId]) rn
FROM [UserDetail]
) a
WHERE rn = 1

Thanks for reply.

Thanks for reply....

Hi SRS(The Coder),thanks for ur help.But I want to ask one thing.When we say variable is static,scope of it at application level.R u sure will this thing will not apply to control

Hi Zafar Sultan,thanks for ur advice.According to my knowledge it is portal where person can ask question.If person is able to do,will not ask here.If u don't understand need a code,better not reply like this.

Thanks Sergey Alexandrovich Kryukov for ur advice.I know postback happen.Actually I was expecting answer not theory part.By the way I handled it using hidden field.It is always better to answer question if u know instead of diverting mind.

user 1 log into system,onclick of button exec query.I am showing time taken by that query.If to high,cancel/stop query from web application.

Hi Karthik,thanks for ur help.That help me lot. setInterval(setTime, 1000) means call setTime() function,after every 1000 miliseconds.

@OriginalGriff,I got answer of 3 and 4 question but not 1 and second.I searched lot in google.I though here will get the answer.I am doing my homework.Not telling other to do that

If I tried to set ValiodateRequest="False" in page directive,it is not working.It work only for framework 2.0 not framework 4.5

Thanks kartik for ur help.I think,my logic was wrong.I wrote like this

if ('<%=Session["Time"] == null%>')
{
alert('null session');
}

Session return true or false.False means not null and true means null.I suppose to change my code if ('<%=Session["Time"] == null%>')
{
alert('Not null session');
}

Thanks KARTHIK,for ur help...

Does it a right approach?

Hi Kartik thanks for ur help.I am selecting date from date picker,that gives me date like this '03/30/2016',I have another dropdownlist for selecting hours and min. I want to add hours and time in selected date.Hours is in 24.Time in 60.As u said to use like this.var d = new Date(year, month, day, hours, minutes, seconds, milliseconds);Again I have to split date to get month,day and year.The code which I used is right to add min and hours in specific date.I showing 2 dates in alert box.Format of like this.One date is Wed Mar 30 2016 11:48:43 GMT+0530(India standard Time) and another is Tue Mar 29 2016 17:54:00 GMT+530(India standard Time). If (d2 > d) { alert('Scheduled date should be greater than current datetime'); }

Maxlength work with textbox when textmode is singal not multiple.By default textmode is singal.

If I want to create first application and then schedule that application?Which application shall I prefer?

yes Peter

Hello Rajat,I know how to make user defined table type.My question is not like that....

I am using vs 2013 and sql server 2012.

No I don't have any problem.If I used first one,still it work.

I done with the help of @@ROWCOUNT

Even I can do with the help of @@ROWCOUNT