15,905,229 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 rajin kp (Top 57 by date)
rajin kp
24-Apr-17 1:29am
View
Deleted
not working
rajin kp
24-Apr-17 1:23am
View
i want to add it in a sing list
rajin kp
24-Apr-17 1:23am
View
Deleted
it is not working .
rajin kp
16-Jul-14 2:46am
View
hum Client .
rajin kp
16-Jul-14 2:38am
View
have another option ?pls share
rajin kp
26-Jun-14 3:17am
View
@Xiao Ling
i got a n exception "org.docx4j.openpackaging.exceptions.Docx4JException: Exception exporting package "
rajin kp
13-Jun-14 0:43am
View
so only way to solve my problem is purchase office for my server ?
rajin kp
12-Jun-14 8:28am
View
i search a lot and could not find a proper answer :(. tks 4 replay
rajin kp
12-Jun-14 8:25am
View
thanks for replay . i m looking for an open source . Is there any open source
rajin kp
31-May-14 1:54am
View
@RyanDev ,@Tadit Dash i got error Unable to load DLL 'gsdll32.dll': Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED
rajin kp
29-May-14 7:57am
View
in simple English can i use it in bin folder of my web app to create thumbnail for pdf .
rajin kp
28-Jan-14 6:09am
View
@Kornfeld Eliyahu Peter
Line: 4621
Error: Sys.ArgumentException: Value must not be null for Controls and Behaviors.
Parameter name: element
rajin kp
9-Jan-14 2:22am
View
i m not looking for how join work :D
rajin kp
9-Jan-14 2:20am
View
select null as 'FoodAlternateID',P. *,"F" as A_F from FoodAptID P inner join Appointment A on A.AID=P.AID where A.Date ='1-1-2013'
union
select S.* from AlternateFoodList S inner join ( select null as 'FoodAlternateID',P. *,"F" as A_F from FoodAptID P inner join Appointment A on A.AID=P.AID where A.Date ='1-1-2013')PP on PP.FoodAptID =S.FoodAptID see the second part of union it use sane result in first part ie PP is same as in first part can i use result in first part At PP,ie my question.Actually there are more table in join .i fear that using join @ both side of union will reduce speed :(
rajin kp
8-Jan-14 3:51am
View
FoodAptID is PK for FoodLsit and FK for AlternateFoodList
rajin kp
8-Jan-14 2:03am
View
Need All Data from Tables with appointment date 1-1-2013 see result table .problem is that i didnt add AID in subtable insted it contain FoodAptID and Table FoodLsit has AID . Is this possible to use result we get before Union to use inside query after union .ie
(select null as 'FoodAlternateID',P. *,"F" as A_F from FoodAptID P inner join Appointment A on A.AID=P.AID where A.Date ='1-1-2013') as TT
union
(some query where i can USe TT to join with AlternateFoodList so that only reuired row come in here )
rajin kp
20-Dec-13 4:37am
View
tks Maciej
rajin kp
20-Dec-13 4:05am
View
sorry for my bad English . what i mean that in each month last entered value for each patient taken
rajin kp
2-May-13 0:59am
View
see question
http://www.codeproject.com/Questions/586472/radioplusbuttonplusgroupplus-3apluseventplusisplus
rajin kp
2-May-13 0:46am
View
i cant remove default checked property its requirement in my application.During edit mode some times radio button 1 is checked sometimes radio button is checked. consider that first load as edit mode
rajin kp
1-May-13 6:48am
View
controlvalue is avilable after databound isnt it ?
rajin kp
1-May-13 5:42am
View
i solve this as
protected void OTSDGView_ItemDataBound(object sender, DataGridItemEventArgs e)
{
try
{
//if (e.Row.RowType == DataControlRowType.DataRow)
//{
if (Convert.ToString(DataBinder.Eval(e.Item.DataItem, "AppointmentTypeID")) == "1")
{
e.Item.CssClass = "tr_Analysis";
}
else if (Convert.ToString(DataBinder.Eval(e.Item.DataItem, "AppointmentTypeID")) == "2")
{
e.Item.CssClass = "tr_Dietitian";
}
else if (Convert.ToString(DataBinder.Eval(e.Item.DataItem, "AppointmentTypeID")) == "3")
{
e.Item.CssClass = "tr_Doctor";
}
//}
}
catch (Exception ex)
{
//ErrorLabel.Text = ex.Message;
}
}
tks all
rajin kp
30-Apr-13 1:32am
View
bro , do you know data grid and grid view are different :)
rajin kp
13-Apr-13 2:27am
View
need two columns date and count list
rajin kp
3-Apr-13 1:58am
View
@Dionisios Karatzas
when i connected to other database such problems for date doesn't come. i am using Collation Arabic_CI_AS.Is it related to database. plz give some useful link.plz explain reason
rajin kp
2-Apr-13 7:17am
View
String was not recognized as a valid DateTime. PLZ check date format :23-04-2013 12:00::00:AM
rajin kp
2-Apr-13 7:14am
View
if (DateTime.TryParse(dr["PatientCreationDate"].ToString(), out TempDate))
{
CreationDate = TempDate;
}
iam reading data from data table .Convert.ToDateTime() not working
rajin kp
2-Apr-13 6:29am
View
still error
rajin kp
28-Jan-13 1:27am
View
@Zoltán Zörgő , @Tharaka MTR My attendance table inserted by using information from excel. Consider that one student take leave from 5-1-13 to 7-1-13 with reason 1 and we make and entry in excel for this. but end of that year student may submit some medical certificate for his leave then teacher enter data in to another excel with date 5-1-13 to 6-1-13 with reason 3 and 7-1-13 to 7-1-13 with reason1 .teachers never search for previous data and try to modify it..s/w must be able to find the appropriate value and delete it and insert while uploading the data using these excel sheet.
We give priority for last data.ie based on the last data table must be inserted or updated. if the above reason come in reverse table must be inserted with values from 5-1-13 to 7-1-13 with reason 1.
Also another sheet may contain value 6-1-13 to 9-1-13 reason 2 for same student. then table updated with last values from 5-1-13 to 5-1-13 with reason 1 and 6-1-13 to9-1-13 with reason 2.
rajin kp
28-Jan-13 0:43am
View
Deleted
my code is shown below.
declare @StartDate smalldatetime='2013-02-12 00:00:00';
declare @EndDate smalldatetime='2013-02-15 00:00:00';
declare @Notes nvarchar(500);
declare @AbsentReasonCode int;
--12 - 19 => 12 - 15,16 - 19
declare @_StartDateTable smalldatetime ;
declare @_EndDateTable smalldatetime ;
declare @_AbsentReasonCode int ;
declare @_update int=0;
declare CursorAttendance cursor for
select StartDate,EndDate,AbsentReasonCode from attendance
where StartDate<@EndDate and EndDate>@StartDate and StudentID=@StudentID
order by StartDate;
--case 1
open CursorAttendance;
FETCH NEXT
FROM CursorAttendance INTO @_StartDateTable , @_EndDateTable,@_AbsentReasonCode
WHILE @@FETCH_STATUS = 0
BEGIN
set @_update=0;
while dbo.GetDatePart(@_StartDateTable)<dbo.getdatepart(@_enddatetable)
begin
="" --print(cast(="" @_startdatetable="" as="" nvarchar(50))+','+cast(="" @enddate="" nvarchar(50)))
="" if="" dbo.getdatepart(@_startdatetable)="">=dbo.GetDatePart(@StartDate)
and dbo.GetDatePart(@_StartDateTable)<= dbo.GetDatePart(@EndDate)
begin
set @_update=1;
end
--else if dbo.GetDatePart(@_StartDateTable)<dbo.getdatepart(@startdate)
--="" and="" dbo.getdatepart(@_startdatetable)<="dbo.GetDatePart(@EndDate)
" begin
="" set="" @_update="2;
"
="" --end
="" ------------------------------------------
="" @_startdatetable="@_StartDateTable+1;
" ------------------------------------------="" if="" dbo.getdatepart(@_startdatetable)="">dbo.GetDatePart(@EndDate)
begin
print('****--------splited date for student 42457,AttendanceID=100 -----*****');
set @_update=0;
print (cast( @StartDate as nvarchar(50))+','+cast(@EndDate as nvarchar(50)));
print (cast( @_StartDateTable as nvarchar(50))+','+cast(@_EndDateTable as nvarchar(50)));
print('****--------------*****');
--print(@_StartDateTable)print(@_EndDateTable);
--insert into dbo.Attendance values( @StartDate,@EndDate);
--insert into dbo.Attendance values( @_StartDateTable,@_EndDateTable,@_AbsentReasonCode);
--delete from Attendance where AttendanceID=@AttendanceID;
--
end
else if @_update=2
begin
print('****------@_update=2-------*****');
end
end
-------------------------------------------
FETCH NEXT
FROM CursorAttendance INTO @_StartDateTable , @_EndDateTable,@_AbsentReasonCode END
CLOSE CursorAttendance
DEALLOCATE CursorAttendance
-------------------------------------------------------
rajin kp
20-Jan-13 23:33pm
View
@Gittu Dash procedure "deleteActivity" may call by multiple users at same time and i want to store deleted values in to history.
rajin kp
11-Jan-13 5:46am
View
Deleted
consider that my table contain Schoolid and classid and yearid,table contain stunt leave details from different year id .I want to datediff based on yearid,studentid.ie basic query "select sum(datediff(d,startdate,enddate)),yearid,studentid from table_name group by yearid,studentid". this is the first query i write.I want apply PIVOT on this query to make result in a single row : student,acyear,class,reason1,...
rajin kp
11-Jan-13 5:39am
View
consider that my table contain other field such as SchoolID,ClassID,Acadamicyear..how can i add these values ,such that i want to find datediff() based on these values.
rajin kp
11-Jan-13 0:36am
View
thanks for quick response
rajin kp
11-Jan-13 0:35am
View
select AT.StudentID,AT.ArabicName as StudentAr,AT.EnglishName StudentEn,AT.ClassAr,AT.Description,
isnull (R1.Reason1,0) as Reason1,isnull(R2.Reason2,0) as Reason2,isnull(R3.Reason3,0) as Reason3 ,AT.SchoolAr
from
(select distinct A.StudentID,S.ArabicName,S.EnglishName,C.ArabicName as ClassAr,AY.Description,S.ArabicName as SchoolAr from
Attendance A inner join dbo.Student S on A.StudentID=S.StudentID
inner join Class C on A.ClassID=C.ClassID
inner Join AcademicYear AY on A.AcademicYearID=AY.AcademicYearID
inner Join School SC on SC.SchoolID= A.SchoolID
where (@StudentID=0 or A.StudentID=@StudentID)
and (@SchoolID=0 or A.SchoolID=@SchoolID)
and(@ClassID=0 or A.ClassID=@ClassID) )AT
left join
(select sum(DATEDIFF(dd,(StartDate+1),EndDate))as Reason1 ,A.StudentID from Attendance A inner join AbsentReason R
on A.AbsentReasonCode=R.AbsentReasonID
group by R.AbsentReasonCode,A.StudentID,A.AcademicYearID having R.AbsentReasonCode=1)R1
on AT.StudentID=R1.StudentID
left Join
(select sum(DATEDIFF(dd,(StartDate+1),EndDate))as Reason2 ,A.StudentID from Attendance A inner join AbsentReason R
on A.AbsentReasonCode=R.AbsentReasonID
group by R.AbsentReasonCode,A.StudentID,A.AcademicYearID having R.AbsentReasonCode=2)R2
on AT.StudentID=R2.StudentID
left join
(select sum(DATEDIFF(dd,(StartDate+1),EndDate))as Reason3 ,A.StudentID from Attendance A inner join AbsentReason R
on A.AbsentReasonCode=R.AbsentReasonID
group by R.AbsentReasonCode,A.StudentID,A.AcademicYearID having R.AbsentReasonCode=9)R3
on AT.StudentID=R3.StudentID
i Solve this like this and getcorrect answer so far i want to know is there any other way to solve more efficintly than my sol
rajin kp
10-Jan-13 6:09am
View
thanks.When i use Convert.ToDateTime(stringdate) problem solved.
rajin kp
10-Jan-13 5:14am
View
DateTime d= DateTime.Parse(MeetingTime,CultureInfo.InvariantCulture);
cmdobj.Parameters.AddWithValue("@MeetingTime",d );
Now new error "The string was not recognized as a valid DateTime. There is a unknown word starting at index 17."
rajin kp
19-Dec-12 4:16am
View
i found all those result ,but i want to know which one is best solution for .net 2.0
rajin kp
13-Dec-12 1:47am
View
thanks
rajin kp
7-Dec-12 2:08am
View
thanks Krunal Rohit
Icheck this It can acees each row but My code addClass('classname') does not work with my gridview
rajin kp
4-Dec-12 1:45am
View
tks Ravi Bhavnani1
rajin kp
10-Oct-12 0:47am
View
thanks gladiatron
rajin kp
8-Oct-12 2:48am
View
THANKS
rajin kp
8-Oct-12 2:48am
View
THANKS
rajin kp
8-Oct-12 2:48am
View
THANKS
rajin kp
8-Oct-12 2:47am
View
THANKS
rajin kp
4-Oct-12 2:10am
View
iam tried this
in allsumFormula:
WhilePrintingRecords ;
shared numberVar totalsetPsum;
shared numberVar totalPiecesPSum;
shared numberVar totalAmountPSum;
totalsetPsum:=totalsetPsum+{sp_report_select_view_madeup_shipping_instruction_details;1.totalsetreg};
totalPiecesPSum:=totalPiecesPSum+{sp_report_select_view_madeup_shipping_instruction_details;1.totalpcsreg};
totalAmountPSum:=totalAmountPSum+{sp_report_select_view_madeup_shipping_instruction_details;1.value};
inn sumheadder:
WhilePrintingRecords ;
shared numberVar totalsetPsum;
if PageNumber <>1 then
totalsetPsum-{sp_report_select_view_madeup_shipping_instruction_details;1.totalsetreg};
but in odd and even pages they give different value
rajin kp
13-Jun-12 7:54am
View
Iam check that but still get result for condition 2 only
rajin kp
12-Jun-12 7:50am
View
i can explain with an example:
in my sails report i'm grouping items by salesperson.so the group section header comes little above the item sold
Sam
item1 $40 2/2/12
item2 $20 2/2/12
Ram
item1 $20 2/2/12
.....................
Like that
But my requirement is that I need the group header in the first row of items as shown below
Sam item1 $40 2/2/12
item2 $20 2/2/12
Ram item1 $20 2/2/12
.....................
see the group header(Sam ,Ram) come to the first rows of items and they are not repeating
rajin kp
12-Jun-12 7:50am
View
i can explain with an example:
in my sails report i'm grouping items by salesperson.so the group section header comes little above the item sold
Sam
item1 $40 2/2/12
item2 $20 2/2/12
Ram
item1 $20 2/2/12
.....................
Like that
But my requirement is that I need the group header in the first row of items as shown below
Sam item1 $40 2/2/12
item2 $20 2/2/12
Ram item1 $20 2/2/12
.....................
see the group header(Sam ,Ram) come to the first rows of items and they are not repeating
rajin kp
8-Jun-12 0:34am
View
Thanks BobJanova.
Plz suggest some links for Linq
rajin kp
25-May-12 6:17am
View
thanks Manas Bhardwaj
rajin kp
25-May-12 5:59am
View
If i use inner join matching rows selected
i need result as
B sum(A) sum(K)
1 20
2 30
3 40 20
5 20
6 70
rajin kp
25-May-12 4:55am
View
Thanks for replay,
Field 'B' in Table1 and Table2 is a foreign key and some rows in table1 may not be in table two and vise versa .I want all data form table1 and table2
rajin kp
25-May-12 4:46am
View
thanks
rajin kp
25-May-12 4:46am
View
thanks
rajin kp
18-May-12 5:22am
View
Thaks for your replay,
Actually My problem is not related to date. data displayed in auto completion {"9/3","3/22","3/22e"} are foreign key in the form.
Show More