Comments by xpertzgurtej (Top 78 by date)

thanks.. It worked as required..

did not work..got error : Invalid object name '#tbEmp'

separator is not fixed. So i cant use {'$'}

I found the solution:
string str = "12$$34$$45";
string separator = "$$";

string[] partsFromString = str.Split(new string[] { separator }, StringSplitOptions.None);

with single $ it works. but for :
string str = "12$$34$$45";
string [] result= Regex.Split(str, @"\$$");

it doesn't work. How to handle this?

Actually i want to split my string and separator may be of multiple characters.
e.g.:
string str = "12$$34$$45";
string separator = "$~$";
string [] result= Regex.Split(str, @"\"+ separator + "");

It worked.thanks a lot for your time :)

Can anybody help

DECLARE @tbDate TABLE(Sno INT IDENTITY(1,1), AttendanceDate DATE, USerId INT)

INSERT INTO @tbDate SELECT DISTINCT CAST(InOutDateTime AS DATE),UserId FROM @tb

DECLARE @tbDateCount INT=(SELECT COUNT(*) FROM @tbDate), @RowId INT=1

DECLARE @AttDate DATE,@UId INT,@MaxInOutTime DATETIME,@MinInOutTime DATETIME

DECLARE @FinalResult TABLE(EmployeeId INT, InTime DATETIME, OutTime DATETIME)

WHILE @RowId<=@tbDateCount
BEGIN
SELECT @AttDate=AttendanceDate , @UId=UserId FROM @tbDate WHERE Sno=@RowId

SELECT @MinInOutTime=(SELECT MIN(InOutDateTime) FROM @tb
WHERE CAST(InOutDateTime AS DATE)=@AttDate AND USerId=@UId AND ISNULL(AttendanceType,'')= CASE WHEN AttendanceType IS NOT NULL THEN 'I' ELSE '' END),
@MaxInOutTime=(SELECT MAX(InOutDateTime) FROM @tb
WHERE CAST(InOutDateTime AS DATE)=@AttDate AND USerId=@UId AND ISNULL(AttendanceType,'')= CASE WHEN AttendanceType IS NOT NULL THEN 'O' ELSE '' END)

INSERT INTO @FinalResult SELECT @UId, @MinInOutTime,@MaxInOutTime
SET @RowId=@RowId+1
END

SELECT * FROM @FinalResult


I am able to get the result what i want. But it is not optimized way. It works very slow. I want the result without looping through each record

i tried select UserId,AttendanceType, min(InOutDateTime) min_InDateTime, max(InOutDateTime) max_OutDateTime
from @tb group by UserId, CAST(InOutDateTime AS DATE),AttendanceType
having AttendanceType in ('I','O')
ORDER BY UserId, CAST(InOutDateTime AS DATE). It is giving me 6 rows instead of 3 rows

thanks for your suggestion. I tried but could not find the desired result.

No..it is not working as per ur solution:
DECLARE @tb TABLE (Id INT, Name NVARCHAR(100));

insert into @tb VALUES (1,'Aman');
insert into @tb VALUES (2,N'سانديب');
insert into @tb VALUES (3,'Anuj');
insert into @tb VALUES (4,N'فيكاس');
insert into @tb VALUES (5,N'اليت');
insert into @tb VALUES (6,'Sunil');
insert into @tb VALUES (7,'Ajay');
insert into @tb VALUES (8,N'فيشال');
insert into @tb VALUES (9,'Tarun');


DECLARE @str NVARCHAR(50)='سانديب'

DECLARE @str1 NVARCHAR(50)
SET @str1=N'' + @str
SELECT * FROM @tb WHERE Name LIKE '%'+ @str1 +'%'

no results

& cant be used for concatenation. Showing error :The data types nvarchar and nvarchar are incompatible in the '&' operator.

it worked..thanks

i already tried with OR instead of And.. OR works fine to prevent data in between existing range but not for overlapping range like 1-70 as i asked in my question

Thanks for your solution. I got idea from this example and completed my actual requirement

thanks for your suggestions. :)

i have written instruction note below password textbox. I just wanted to validate whether user has typed valid password as per rule or not.. I think in that case your regex answer will be ok. is not it?

thanks for your suggestions

its working as expected

:(

.

So what should i do now? Should i use ValidateRequest="false" at page directive or something else?

i don't want to set ValidateRequest="false" because it will allow XSS attacks. What to do in this case? how to ensure this?

yes..its working..Actually i was looking for single update statement solution. But no problem..thanks for your help

thanks for your help..It worked same as i want..

that work when we click on checkbox but i want to fire event on checkbox item name

i know the use of fileupload control in this scenario but I was thinking to get this done without uploading the file. i have to go for fileupload control. thanks for your time.

But through file upload control, my database file of size 400 MB will first upload on server then i will be able to get the file path. I don't want to upload the file, just want to get the path.

Suppose the table has Only 3 fields . FirstName, MiddleName and LastName. And there are 1000 records and i want to delete last 10 records. Then how to delete them

I read the article mentioned by you. But not able to decide what to use. Please suggest as per my case.

But is it right to read from session 50 times? which approach is better, the one i am using as mentioned in my question or as suggested by you. I mean Reading 50 times from cookie or session? Which one is better?
Please clarify

So u mean i should store schoolid in viewstate and then i can fetch from viewstate whereevere required? But is it right to read viewstate 50 times? which approach is better, the one i am using as mentioned in my question or as suggested by you. I mean Reading 50 times from cookie or viewstate? Which one is better?
Please clarify

because my gridview has a hiddenfield Control. If i don't generate dynamic form tag then i get the error 'ctl00_ContentPlaceHolder1_gridView_ctl00_hdEmployeeid' of type 'HiddenField' must be placed inside a form tag with runat=server.

Thanks Rajdeep. I got the idea with your help. With little modification i was able to achieve my goal..

Thanks. Its working with little modification to make it work on asp.net page..

It is yyyy-yy. Bacause i want the user to enter academic session in this format e.g. 2014-15

tried maskededitextender but no luck

finally implemented the solution suggested by you..thanks

Thanks for you suggestion.If no other solution found then i will go with your solution.

Yes that works..But i want to restrict user to enter those useless long words because they worth nothing

There wil be lots of tables, SP's in the database. And many concurrent users. Is it possible with VistaDb?

Thanks..It helped me in getting my requirement done

there is also a column AttendanceType which stores 0 for intime and 1 for outime in Table1

yes time is stored as datetime

yes there is date column in both tables

Thanks for your reply..But is there any direct running example as per my requirement?

actually i have to implement this functionality in asp.net because i am using asp.net and sql server in my project and want to import access data into my sql server table

Thanks OriginalGriff for your help..it solved my problem.

Thanks its working as per required..:)

Thanks for your reply..But my required is: 7 which will be passed in stored procedure as a parameter and i want to check whether it exists in any of the row of #MyTable or not?

thanks magic wonder your updated solution was awesome..:).. Can you please also suggest if country is also nullable then what changes are reuired?

These are database values and i want to get single concatenated field

Not workoing as required..It is displayinh -> where there are Nulls

.

.

Thanks for your suggestions virusstorm..Can we use Hangfire for my requirement? Does it work for Asp.Net(Not MVC).

I just want to implement those requirements and need guidance..

Thanks for your valuable suggestions..your solution worked for me..I also got another solution:
namespace MyNamespace
{
public class demo1:demo2
{
public static int Myfunction1()
{
return demo2.Myfunction2(100,400);
}
}

public class demo2
{
protected static int Myfunction2(int a, int b)
{
retutn a+b;
}
}
}


This way user can't access Myfunction2

that will create complexity..still if there are no other options then it could it a nested class. How to do that?

Yes. My class structure is like that..

Both the classes are in same namespace. And user is calling them form the same project(from the front end) I want user can call Myfunction1 but not Myfunction2

making them static was my requirement..Can't change them..Please suggest a solution having them as it is..

Ok.thanks for your suggestions

I know that way..But my requirement is to get property names from the ApplicantInfo object without a separate loop..I think there must be some way to handle this..

I know that way..But my requirement is to get property names from the ApplicantInfo object without a separate loop..

thanks for the reply. But can you please provide suitable example to achieve my requirement?

thanks for the reply but i have to find all the tags wrapped in {} not just the {}. Please reply with suitable example if possible