15,867,453 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 Python 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 kalyan10qwerty (Top 38 by date)
kalyan10qwerty
22-Feb-16 5:11am
View
select count(*) from Students s, Organisations o, Classes c
where s.ClassId=c.Id and c.OrganisationId=o.Id and o.OrganisationCode='204050'
above is the query for which i got student count as i specified the particular organisation code.
I have around 800 org so please give me the solution
kalyan10qwerty
22-Feb-16 4:56am
View
select o.organisationcode, o.organisationname, ( select count(*) from Students s,Classes c,Organisations o where s.ClassId=c.Id and c.OrganisationId=o.Id ) as StudentCount from Organisations o,Students s,Classes c
where s.ClassId=c.Id and c.OrganisationId=o.Id
In studentCount it is retrieving all organisation students count in-stud of that particular org student count :(. Some where i am missing the condition. Unable to figure it out. So help me
kalyan10qwerty
22-Feb-16 4:33am
View
yes your right. but i am unable to write complete query even though after referring to the information provided by you. so give me the solution
kalyan10qwerty
22-Feb-16 4:22am
View
Hi OriginalGriff
I have tried half query
select count(*) from Students s,Classes c,Organisations o where s.ClassId=c.Id and c.OrganisationId=o.Id
now i need orgname which is in orgtable along with the above query so please help me
kalyan10qwerty
2-Mar-15 3:45am
View
I have already done that then it is saying
The best overload method match for 'System.Data.OleDb.OleDbCommand(string, System.Data.OleDb.OleDbConnection) has some invalid arguments
So plz give another solution
kalyan10qwerty
7-Nov-13 0:53am
View
i have written same coding in .cs file in my project so for every visit of my client to my website it is fetching my server mac address and ip address as the project is installed in my server so i need a code which execute in browser side by which i can fetch atleast ip address. Thanks for the response
kalyan10qwerty
7-Nov-13 0:48am
View
so can i trace atleast ip address of those who are using my project
kalyan10qwerty
21-Jun-13 8:03am
View
ok thanq. plz rply 2maroo
kalyan10qwerty
21-Jun-13 7:11am
View
ya but now if i change datatype to datetime it wont accept as previous values are stored in string format so i am trying it in code behind..
kalyan10qwerty
21-Jun-13 6:59am
View
that is comming from client side.
kalyan10qwerty
21-Jun-13 6:30am
View
DateTime kd1 = DateTime.Parse(Mintime.ToString(DformatMin));
for the above line
kalyan10qwerty
21-Jun-13 5:52am
View
Error 2 Argument '1': cannot convert from 'string' to 'System.IFormatProvider'
kalyan10qwerty
21-Jun-13 5:05am
View
ok thank you for your valuable response
kalyan10qwerty
21-Jun-13 4:56am
View
I have changed capital H to small h but again the same result.Please help meeeeee
kalyan10qwerty
21-Jun-13 4:43am
View
string DformatMin = "dd/MMMM/yyyy HH:mm:ss";
DateTime kd1 = DateTime.Parse(Mintime.ToString(DformatMin));
It is showing same error.
kalyan10qwerty
21-Jun-13 4:23am
View
string mindate = 15/06/2013 11:03:24
string DformatMin = "dd/mm/yyyy HH:mm:ss";
datetime kd1 = DateTime.Parse(mindate.tostring(DformatMin));
Error 1 The best overloaded method match for 'System.DateTime.Parse(string, System.IFormatProvider)' has some invalid arguments
kalyan10qwerty
21-Jun-13 4:20am
View
What is g and i am able to get only culture but not cultureinfo.
kalyan10qwerty
14-Mar-13 3:13am
View
Can you provide a sample code please
kalyan10qwerty
28-Feb-13 1:53am
View
i am using calendar control in standard. I am not using ajax control. so can you give solution for calendar control which is present in standard
kalyan10qwerty
27-Feb-13 4:10am
View
Its working for me babu. Thank you.
kalyan10qwerty
7-Dec-12 5:10am
View
so no solutions 4m any!!!!
kalyan10qwerty
7-Dec-12 0:48am
View
i need to eliminate 939868 and 939869 records completely from above sample data.
kalyan10qwerty
6-Dec-12 7:04am
View
i dint get what is input r what is output. if u c above sample a_id 939868 and 939869 generated 1 and 1 which is ubnormal...so those records should be eliminated. i need query to eliminate those records.those two 1's which i gave are just sample.i have huge data as same as those which is to b eliminated. so i need query to eliminate those type of records.
thank you
kalyan10qwerty
17-Aug-12 3:00am
View
i think u deleted ur query
kalyan10qwerty
17-Aug-12 2:46am
View
ok ok....
kalyan10qwerty
2-Mar-12 3:12am
View
TABLE_A
AUTO_ID IMEI LATITUDE LONGITUDE TIME_STAMP
1 111 19.77 18.88 2:00:00
2 111 19.77 18.88 2:20:00
3 111 19.77 18.88 2:30:00
TABLE_B
AUTO_ID IMEI LATITUDE LONGITUDE TIME_STAMP
1 111 19.77 18.88 2:00:00
2 111 19.77 18.88 2:20:00
3 111 19.77 18.88 2:30:00
4 123 24.20 21.24 4:10:00
5 124 25.20 22.24 4:20:00
6 125 26.20 23.24 4:30:00
I NEED TO SELECT DISTINCT RECORDS FROM THE ABOVE TO TABLES AND THE RESULTANT WILL BE STORED IN A NEW TABLE. NEED TOTAL ROW NOT A COLUMN
kalyan10qwerty
2-Mar-12 3:09am
View
i just gave you the sample table.i need to filter data from two table.for the above sample your query works fine:-) suppose if it gives same lat and long for the same imei then again issue raises
kalyan10qwerty
29-Feb-12 23:27pm
View
thanq satish...
kalyan10qwerty
7-Jan-12 0:51am
View
hi will you please provide the code for reverse geocode on map click.
kalyan10qwerty
12-Dec-11 6:16am
View
if u get the query plz do let me know...
thank you
kalyan10qwerty
12-Dec-11 4:43am
View
ok i will also provide you with my stored procedure table
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SP_GETLATESTRECORDRAW_SELECT]
(
@DEVICE_ID NVARCHAR(50)
)
AS
SELECT DEVICE_ID,TIME_STAMP,SENSOR1,SENSOR2,SENSOR3,SENSOR4,SENSOR5 FROM M2M_SC_RAW_DATA WHERE A_ID=(SELECT MAX(A_ID) FROM M2M_SC_PROCESSED_DATA WHERE DEVICE_ID=@DEVICE_ID)
kalyan10qwerty
12-Dec-11 4:17am
View
did u got the query....
kalyan10qwerty
12-Dec-11 3:22am
View
thank you Mr Amir, please help me regarding this coz for past 6days i am unable to get the perfect query and my dead line is tomorrow..
kalyan10qwerty
12-Dec-11 3:15am
View
mine is sql server 2005,i need output in this type( display only 3:36 report of s-1 with respect to time and 1:2pm of s-1 report with respect to time)i don't want in between records.for this i need query
kalyan10qwerty
12-Dec-11 2:33am
View
I D ABOVE RAW DATA S-1 IS IDLE FROM 3:36 TO 8:5 and it changed its status to load at 1:2pm so i want to display only 3:36 report of s-1 with respect to time and 1:2pm of s-1 report with respect to time.i don't want in between records.for this i need query
kalyan10qwerty
12-Dec-11 2:27am
View
OK...
AUTOID IMEINO DEVICEID TMIE STAMP S-1 S-2 S-3 S-4 S-5
1 2 DEV_001 1/1/2011 11:03:36 AM IDLE LOAD LOAD LOAD LOAD
2 4 DEV_002 1/1/2011 8:03:36 AM IDLE LOAD LOAD LOAD LOAD
3 6 DEV_003 1/1/2011 1:00:36 PM IDLE LOAD LOAD LOAD LOAD
4 8 DEV_004 1/1/2011 11:03:36 AM IDLE LOAD LOAD LOAD LOAD
5 10 DEV_005 1/1/2011 11:03:36 AM IDLE LOAD LOAD LOAD LOAD
6 2 DEV_001 1/1/2011 11:05:38 AM IDLE LOAD LOAD LOAD LOAD
7 4 DEV_002 1/1/2011 8:05:38 AM IDLE LOAD LOAD LOAD LOAD
8 6 DEV_003 1/1/2011 1:02:38 PM LOAD LOAD LOAD LOAD LOAD
9 8 DEV_004 1/3/2011 11:03:38 AM LOAD LOAD LOAD LOAD LOAD
10 10 DEV_005 1/3/2011 11:03:38 AM LOAD LOAD LOAD LOAD LOAD
11 2 DEV_001 1/3/2011 11:07:38 AM LOAD LOAD LOAD LOAD LOAD
12 4 DEV_002 1/3/2011 8:07:38 AM LOAD LOAD LOAD LOAD LOAD
13 6 DEV_003 1/3/2011 1:04:38 PM LOAD LOAD LOAD LOAD LOAD
14 8 DEV_004 1/3/2011 11:03:38 AM LOAD LOAD LOAD LOAD LOAD
15 10 DEV_005 1/3/2011 11:03:38 AM LOAD LOAD LOAD LOAD LOAD
16 2 DEV_001 2/3/2011 11:09:38 AM LOAD LOAD LOAD LOAD LOAD
17 4 DEV_002 2/3/2011 8:09:38 AM OFF LOAD LOAD LOAD LOAD
18 6 DEV_003 2/3/2011 1:06:38 PM OFF LOAD LOAD LOAD LOAD
19 8 DEV_004 2/3/2011 11:03:38 AM OFF LOAD LOAD LOAD LOAD
20 10 DEV_005 2/3/2011 11:03:38 AM OFF LOAD LOAD LOAD LOAD
21 2 DEV_001 2/2/2011 11:11:40 AM OFF LOAD LOAD LOAD LOAD
22 4 DEV_002 2/2/2011 8:11:40 AM LOAD LOAD LOAD LOAD LOAD
23 6 DEV_003 2/2/2011 1:08:40 PM LOAD LOAD LOAD LOAD LOAD
24 8 DEV_004 2/2/2011 11:03:40 AM LOAD LOAD LOAD LOAD LOAD
25 10 DEV_005 2/2/2011 11:03:40 AM LOAD LOAD LOAD LOAD LOAD
kalyan10qwerty
12-Dec-11 2:08am
View
PLEASE GIVE YOUR MAIL ID,I WILL SEND U THE FILE
kalyan10qwerty
12-Dec-11 2:06am
View
Deleted
1 2 DEV_001 6 6 1/1/2011 11:03:36 AM 16 6 7 8 9 Ramesh IDLE LOAD LOAD LOAD LOAD 'NULL' 'NULL' 'NULL' 'NULL' 'NULL'
2 4 DEV_002 7 7 1/1/2011 8:03:36 AM 17 7 8 9 10 Ramesh IDLE LOAD LOAD LOAD LOAD 'NULL' 'NULL' 'NULL' 'NULL' 'NULL'
3 6 DEV_003 8 8 1/1/2011 1:00:36 PM 18 8 9 10 11 Ramesh IDLE LOAD LOAD LOAD LOAD 'NULL' 'NULL' 'NULL' 'NULL' 'NULL'
4 8 DEV_004 9 9 1/1/2011 11:03:36 AM 19 9 10 11 12 Ramesh IDLE LOAD LOAD LOAD LOAD 'NULL' 'NULL' 'NULL' 'NULL' 'NULL'
5 10 DEV_005 10 10 1/1/2011 11:03:36 AM 20 10 11 12 13 Ramesh IDLE LOAD LOAD LOAD LOAD 'NULL' 'NULL' 'NULL' 'NULL' 'NULL'
6 2 DEV_001 6 6 1/1/2011 11:05:38 AM 16 6 7 8 9 Ramesh IDLE LOAD LOAD LOAD LOAD 'NULL' 'NULL' 'NULL' 'NULL' 'NULL'
7 4 DEV_002 7 7 1/1/2011 8:05:38 AM 17 7 8 9 10 Ramesh IDLE LOAD LOAD LOAD LOAD 'NULL' 'NULL' 'NULL' 'NULL' 'NULL'
8 6 DEV_003 8 8 1/1/2011 1:02:38 PM 18 8 9 10 11 Ramesh LOAD LOAD LOAD LOAD LOAD 'NULL' 'NULL' 'NULL' 'NULL' 'NULL'
9 8 DEV_004 9 9 1/3/2011 11:03:38 AM 19 9 10 11 12 Ramesh LOAD LOAD LOAD LOAD LOAD 'NULL' 'NULL' 'NULL' 'NULL' 'NULL'
10 10 DEV_005 10 10 1/3/2011 11:03:38 AM 20 10 11 12 13 Ramesh LOAD LOAD LOAD LOAD LOAD 'NULL' 'NULL' 'NULL' 'NULL' 'NULL'
11 2 DEV_001 6 6 1/3/2011 11:07:38 AM 16 6 7 8 9 Ramesh LOAD LOAD LOAD LOAD LOAD 'NULL' 'NULL' 'NULL' 'NULL' 'NULL'
12 4 DEV_002 7 7 1/3/2011 8:07:38 AM 17 7 8 9 10 Ramesh LOAD LOAD LOAD LOAD LOAD 'NULL' 'NULL' 'NULL' 'NULL' 'NULL'
13 6 DEV_003 8 8 1/3/2011 1:04:38 PM 18 8 9 10 11 Ramesh LOAD LOAD LOAD LOAD LOAD 'NULL' 'NULL' 'NULL' 'NULL' 'NULL'
14 8 DEV_004 9 9 1/3/2011 11:03:38 AM 19 9 10 11 12 Ramesh LOAD LOAD LOAD LOAD LOAD 'NULL' 'NULL' 'NULL' 'NULL' 'NULL'
15 10 DEV_005 10 10 1/3/2011 11:03:38 AM 20 10 11 12 13 Ramesh LOAD LOAD LOAD LOAD LOAD 'NULL' 'NULL' 'NULL' 'NULL' 'NULL'
16 2 DEV_001 6 6 2/3/2011 11:09:38 AM 16 6 7 8 9 Ramesh LOAD LOAD LOAD LOAD LOAD 'NULL' 'NULL' 'NULL' 'NULL' 'NULL'
17 4 DEV_002 7 7 2/3/2011 8:09:38 AM 17 7 8 9 10 Ramesh OFF LOAD LOAD LOAD LOAD 'NULL' 'NULL' 'NULL' 'NULL' 'NULL'
18 6 DEV_003 8 8 2/3/2011 1:06:38 PM 18 8 9 10 11 Ramesh OFF LOAD LOAD LOAD LOAD 'NULL' 'NULL' 'NULL' 'NULL' 'NULL'
19 8 DEV_004 9 9 2/3/2011 11:03:38 AM 19 9 10 11 12 Ramesh OFF LOAD LOAD LOAD LOAD 'NULL' 'NULL' 'NULL' 'NULL' 'NULL'
20 10 DEV_005 10 10 2/3/2011 11:03:38 AM 20 10 11 12 13 Ramesh OFF LOAD LOAD LOAD LOAD 'NULL' 'NULL' 'NULL' 'NULL' 'NULL'
21 2 DEV_001 6 6 2/2/2011 11:11:40 AM 16 6 7 8 9 Ramesh OFF LOAD LOAD LOAD LOAD 'NULL' 'NULL' 'NULL' 'NULL' 'NULL'
22 4 DEV_002 7 7 2/2/2011 8:11:40 AM 17 7 8 9 10 Ramesh LOAD LOAD LOAD LOAD LOAD 'NULL' 'NULL' 'NULL' 'NULL' 'NULL'
23 6 DEV_003 8 8 2/2/2011 1:08:40 PM 18 8 9 10 11 Ramesh LOAD LOAD LOAD LOAD LOAD 'NULL' 'NULL' 'NULL' 'NULL' 'NULL'
24 8 DEV_004 9 9 2/2/2011 11:03:40 AM 19 9 10 11 12 Ramesh LOAD LOAD LOAD LOAD LOAD 'NULL' 'NULL' 'NULL' 'NULL' 'NULL'
25 10 DEV_005 10 10 2/2/2011 11:03:40 AM 20 10 11 12 13 Ramesh LOAD LOAD LOAD LOAD LOAD 'NULL' 'NULL' 'NULL' 'NULL' 'NULL'
Show More