TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
mounika madhavaram
NA
42
11k
how to call stored procedure with parameters
May 7 2018 11:17 PM
how to call stored procedure with parameters
public
readonly
static
string
FREIGHTHEAD =
"SELECT SR.ApprovalNumber ,SR.Remarks SRRemarks,"
+
" P.Description PDescription,SP.Description SPDescription,U.FirstName UFirstName, L.Description LDescriptionFrom, "
+
" LO.Description LODescriptionTo,cn.OriginalContainerNumber ContainerNumber FROM SeaFreightApprovalRateDetails SR INNER JOIN SeaFreightApproval S ON "
+
" SR.SeaFreightApprovalId=S.Id LEFT JOIN Party P ON SR.PartyId=P.Id LEFT JOIN Shipments SP ON S.ShipmentId=SP.Id "
+
" LEFT JOIN Users U ON SR.ApprovedById=U.Id LEFT JOIN Locations L ON S.FromLocationId=L.Id LEFT JOIN Locations LO ON"
+
" S.ToLocationId=LO.Id INNER JOIN Containers cn ON S.ContainerId=cn.Id WHERE S.ContainerId=@_ContainerId"
;
previously am using a query like this by passing parameter
Now i want to call stored procedure how to pass the parameters to that stored procedure
public
readonly
static
string
GETINVOICEHEADERREPORT =
"EXEC SP_GetInvoiceHeaderReport"
Reply
Answers (
1
)
how can i write inside panel using label ?
datgrid view values to store in database mysql