how to call stored procedure with parameters

Question

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"

Shweta Lodha · Answer

Hi, You can do something like below sample code: bool result= false ; SqlCommand scCommand = new SqlCommand( "SP_GetInvoiceHeaderReport" , sqlCon); scCommand.CommandType = CommandType.StoredProcedure; scCommand.Parameters.Add( "@Name" , SqlDbType.VarChar, 50).Value = txtName.Text; try { if (scCommand.Connection.State == ConnectionState.Closed) { scCommand.Connection.Open(); } scCommand.ExecuteNonQuery(); result = Convert.ToBoolean(scCommand.Parameters[ "@Result" ].Value); } catch (Exception) { } finally { scCommand.Connection.Close(); } https://stackoverflow.com/questions/15569860/passing-parameter-to-stored-procedure-in-c-sharp