Comments by Ankit Patel(AP)

Ankit Patel(AP) 15-Nov-14 7:42am View

BUT THIS Query Retun More then One Value

Ankit Patel(AP) 15-Nov-14 6:22am View

User_Master.UserCode IS One Fild And '_EmaillAddressInfo' IS A String

My Query Is

SELECT (CONVERT(VARCHAR(MAX), UserCode) + 'EmailAddressInfo').EmailId AS NewFieldName

FROM SUser_Master

But Error Is Occured : Cannot call methods on varchar(max)

Ankit Patel(AP) 11-Aug-14 1:59am View

U Have Demo ???

So Plz Upload Here

Ankit Patel(AP) 28-Jul-14 8:30am View

Thanks for your help but i did not get my output . Please help me if possible

Thanks for reply

Ankit Patel(AP) 28-Jul-14 7:55am View

Deleted

IF Pass User Id = 3

Then Output Is 2,4

But Your Output Is 3,1

Ankit Patel(AP) 28-Jul-14 7:54am View

No..

Ankit Patel(AP) 28-Jul-14 7:46am View

DECLARE @UserMaster TABLE (UserId INT IDENTITY(1,1), UserName VARCHAR(30))

INSERT INTO @UserMaster (UserName)

VALUES('user a'),('user b'),('user c'),('user d')

DECLARE @RequestMaster TABLE (RepId INT IDENTITY(1,1), SenderId INT, Recieverid INT)

INSERT INTO @RequestMaster ( SenderId, Recieverid)
VALUES(1, 2), (3,1)

SELECT RM.RepId, UM.UserName AS Sender, (SELECT UserName FROM @UserMaster WHERE UserId = RM.Recieverid ) AS Reciever
FROM @RequestMaster AS RM
LEFT JOIN @UserMaster AS UM ON RM.SenderId = UM.UserId

WHERE UM.UserId = 3

THEN Output IS : 2 User c User a

But this is Wrong Output

Right Output Is Below
IF Pass UserId = 3

OutPut Is :

User B
User D

AND

IF Pass User_Id = 4

THEN OUTPUT IS :

User A
User B
User C

Ankit Patel(AP) 28-Jul-14 6:29am View

NO Data Display...Write Query..

SELECT RM.Request_Id, UM.FirstName AS Sender, UM1.FirstName

FROM Request_Master AS RM

LEFT JOIN User_Master AS UM ON RM.Sender_Id = UM.UserId

LEFT JOIN User_Master AS UM1 ON RM.Reciver_Id = UM1.UserId

WHERE UM.UserId = 2 AND UM1.UserId = 2

THEN OUTPUT IS C AND D

BUT NOT WORK THIS Query..

Not Display any data

Ankit Patel(AP) 26-Jul-14 5:08am View

This error display when use your query

The correlation name 'UM' is specified multiple times in a FROM clause.

Ankit Patel(AP) 26-Jul-14 5:07am View

i want Unfriend data which are not friend of one user

Ankit Patel(AP) 26-Jul-14 5:05am View

This error display when use your query

The correlation name 'UM' is specified multiple times in a FROM clause.

Ankit Patel(AP) 21-Jul-14 6:30am View

But My problem is That export gridview in pdf at that time border is not display..

Ankit Patel(AP) 21-Jul-14 6:28am View

i want to export datgridview to pdf with borders

Ankit Patel(AP) 19-Jul-14 5:56am View

i dont know what problem you face out .. can you explain with proper example so i can help you.

Thanks

Ankit Patel(AP) 23-Nov-13 2:33am View

Hello BillWoodruff

Thanks for Reply But thing is that i install software in pendrive and it's work fine but i want my database also in the same location and that thing i don't know how to do if you have any idea than please tell me.

Thanks and Regards

Ankit Patel(AP) 23-Nov-13 2:30am View

But I Develop 90% of application and it is not possible to transfer all the database to sqllite because i also done code using a stored producer and as per my knowledge sqllite is not supported to stored producers,
So there is any other solution than please tell me

Thanks and Regards

Ankit Patel(AP) 19-Nov-13 8:04am View

Change Your Check box auto-post back property true.
And your problem has solved, I hope it's work...

Ankit Patel(AP) 20-Sep-13 4:24am View

I am Sorry for that and i apologize for that...
I am working on web application and Here i give you the exact scenario of my requirement ,
Let me take one example , I have one registration form and on the click event of the registration submit button, i want to show one message box with the successfully register Message, Now on that message box i put one button with ok ,

Now if i press enter key at that time it take by default ok and close the message box...

Comments by Ankit Patel(AP) (Top 18 by date)