16,012,061 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 RKparmar (Top 9 by date)
RKparmar
14-Nov-17 0:12am
View
Thanks for solution.
But in winform Application there is not contentType Property.
so how can i manage this ?
DataRowView drv = dgvDocument.Rows[e.RowIndex].DataBoundItem as DataRowView;
string sql_string = "SELECT DOC_FILE FROM DOC_DET where SEQ_NO = " + drv["SEQ_NO"];
using (SqlCommand cmd = new SqlCommand(sql_string, con))
{
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(dr);
Byte[] bytes = (Byte[])dt.Rows[0]["DOC_FILE"];
con.Close();
if (drv["DOC_TYPE"].ToString() == ".pdf")
{
MemoryStream stream = new MemoryStream(bytes);
webBrowser1.DocumentStream = stream;
webBrowser1.Show();
}
}
RKparmar
28-Dec-14 23:24pm
View
I AM USING MORE THEN ONE TABLE , AND I ALREADY MENTION WHAT I AM GETTING RESULT.
RKparmar
28-Dec-14 0:22am
View
SELECT TITAL,PCS,RGH_CTS,VALUE
FROM (
SELECT COUNT(VPACKET_NO) PCS, SUM(CTS) RGH_CTS , SUM(TTL_NET_VALUE) VALUE , 'SEND' TITAL
FROM (
SELECT SEQ_NO,VPACKET_NO,CTS,MAX(TOTAL_NET_VALUE) TTL_NET_VALUE FROM (
SELECT ID.SEQ_NO, ID.VPACKET_NO,ID.CTS,
SUM((DBO.DISC_RATE(ISNULL(psd.RATE, ISNULL(tp.RATE,tp.RATE)), ISNULL(psd.DISC_PER, ISNULL(tp.DISC_PER,0))) * ROUND(ISNULL(psd.EXP_CTS, tp.EXP_CTS),3,1))) OVER (PARTITION BY tp.TRANS_ID, tp.PLAN_SEQ) TOTAL_NET_VALUE
FROM INV_DET ID
INNER JOIN TRANS_PLAN TP ON TP.INV_DET_SEQ = ID.SEQ_NO
LEFT JOIN PLAN_SEND_DET PSD ON PSD.SEQ_NO = TP.SEQ_NO
INNER JOIN PLAN_SEND_MAS PSM ON PSM.SEQ_NO = PSD.PLAN_SEND_SEQ
WHERE CAST(PSM.TRANS_DATE AS DATE) = CAST(GETDATE()-3 AS DATE) and
PSD.CANCEL_DATE IS NULL
)X
GROUP BY SEQ_NO,VPACKET_NO,CTS
)SND
UNION ALL
SELECT COUNT(VPACKET_NO) PCS , SUM(CTS) CTS , SUM(TTL_NET_VALUE) VALUE , 'BID' TITAL
FROM (
SELECT SEQ_NO,VPACKET_NO,CTS,MAX(TOTAL_NET_VALUE) TTL_NET_VALUE FROM (
SELECT ID.SEQ_NO, ID.VPACKET_NO,ID.CTS,
SUM((DBO.DISC_RATE(ISNULL(psd.RATE,TP.RATE), ISNULL(pb.DISC_PER,ISNULL(psd.DISC_PER,TP.DISC_PER))) * ROUND(ISNULL(psd.EXP_CTS, tp.EXP_CTS),3,1))) OVER (PARTITION BY tp.TRANS_ID, tp.PLAN_SEQ) TOTAL_NET_VALUE
FROM INV_DET ID
INNER JOIN TRANS_PLAN TP ON TP.INV_DET_SEQ = ID.SEQ_NO
INNER JOIN PLAN_SEND_DET PSD ON PSD.SEQ_NO = TP.SEQ_NO AND TP.IS_REJECT = 0
INNER JOIN PLAN_BID_DET PBD ON TP.SEQ_NO = PBD.TRANS_PLAN_SEQ
INNER JOIN PLAN_BID_MAS PBM ON PBD.PLAN_BID_SEQ = PBM.SEQ_NO
LEFT JOIN ( SELECT pbdX.*, pbmX.TRANS_DATE BID_DATE
FROM PLAN_BID_DET pbdX
INNER JOIN PLAN_BID_MAS pbmX on pbdX.PLAN_BID_SEQ = pbmX.SEQ_NO
INNER JOIN PLAN_SEND_DET psdX on pbdX.TRANS_PLAN_SEQ = psdX.SEQ_NO AND psdX.CANCEL_DATE IS NULL
WHERE pbmX.BIDDER_SEQ = ISNULL(23, pbmX.BIDDER_SEQ)
) pb ON pb.TRANS_PLAN_SEQ = psd.SEQ_NO
LEFT JOIN NAME_MAS NM ON NM.SEQ_NO = TP.EMP_SEQ
WHERE CAST(pbm.TRANS_DATE AS DATE) = CAST(GETDATE()-3 AS DATE)
AND PBD.CANCEL_DATE IS NULL AND PSD.BID_DET_SEQ IS NOT NULL
AND tp.TRANS_TYPE_SEQ IN (1162)
AND NM.CODE_NO <> 'TRY'
AND TP.IS_REJECT = 0
)X
GROUP BY SEQ_NO,VPACKET_NO,CTS
)BID
UNION ALL
SELECT COUNT(VPACKET_NO) PCS , SUM(CTS) CTS , SUM(TTL_NET_VALUE) VALUE , 'FINAL' TITAL
FROM (
SELECT SEQ_NO,VPACKET_NO,CTS,MAX(TOTAL_NET_VALUE) TTL_NET_VALUE FROM (
SELECT ID.SEQ_NO, ID.VPACKET_NO,ID.CTS,
SUM((DBO.DISC_RATE(ISNULL(psd.RATE,TP.RATE), ISNULL(pb.DISC_PER,ISNULL(psd.DISC_PER,TP.DISC_PER))) * ROUND(ISNULL(psd.EXP_CTS, tp.EXP_CTS),3,1))) OVER (PARTITION BY tp.TRANS_ID, tp.PLAN_SEQ) TOTAL_NET_VALUE
FROM INV_DET ID
INNER JOIN TRANS_PLAN TP ON TP.INV_DET_SEQ = ID.SEQ_NO
INNER JOIN PLAN_SEND_DET PSD ON PSD.SEQ_NO = TP.SEQ_NO
LEFT JOIN ( SELECT pbdX.*, pbmX.TRANS_DATE BID_DATE
FROM PLAN_BID_DET pbdX
INNER JOIN PLAN_BID_MAS pbmX on pbdX.PLAN_BID_SEQ = pbmX.SEQ_NO
INNER JOIN PLAN_SEND_DET psdX on pbdX.TRANS_PLAN_SEQ = psdX.SEQ_NO AND psdX.CANCEL_DATE IS NULL
WHERE pbmX.BIDDER_SEQ = ISNULL(23, pbmX.BIDDER_SEQ)
) pb ON pb.TRANS_PLAN_SEQ = psd.SEQ_NO
WHERE CAST(PSD.FINAL_DATE AS DATE) = CAST(GETDATE()-3 AS DATE) AND PSD.FINAL_TYPE= 1 AND PSD.CANCEL_DATE IS NULL
)X
GROUP BY SEQ_NO,VPACKET_NO,CTS
)BID
) MAIN
RKparmar
21-Jan-14 4:20am
View
yes
RKparmar
9-Jan-14 2:28am
View
HI ,
I use this but in this i m not calculate sum of time
select right('0' + cast(datediff(hh, '2014-01-02 08:30:00.000','2014-01-04 18:20:00.000') as varchar),2) +':' + right('0' + cast(datediff(mi, '2014-01-02 08:30:00.000','2014-01-04 18:20:00.000') % 60 as varchar),2) as HoursMin
i got more then one record from database . how to sum this all HoursMin column sum ?
RKparmar
8-Jan-14 6:46am
View
from : at 8:00 AM to 7:00 PM and Sunday is holidays.
RKparmar
7-Jan-14 6:20am
View
Hi use this :
SELECT select CONVERT(varchar(10),NW_NewsDate,110) FROM news_master WHERE NW_NewsDate between '2014-01-07 00:00:00' AND '2014-01-07 23:59:00' ORDER BY NW_SerialNo ASC
RKparmar
3-Jan-14 8:18am
View
Thank You .
RKparmar
30-Dec-13 0:06am
View
Hi ,
thank you for your reply .
i read and implement that but i want to replicate two server between on was in surat location and another in mumbai . on network and web base any solution ? to create any IIS configuration require ?
thank you. :)
Show More