16,017,167 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View .NET questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by Ankit Patel(AP) (Top 18 by date)
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...
Show More