Click here to Skip to main content
15,887,430 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
GeneralRe: Strange Characters Appended to every url as #cCccCc Pin
Luc Pattyn4-Jun-10 15:07
sitebuilderLuc Pattyn4-Jun-10 15:07 
GeneralRe: Strange Characters Appended to every url as #cCccCc Pin
Shawn Souto4-Jun-10 15:08
Shawn Souto4-Jun-10 15:08 
AnswerRe: Strange Characters Appended to every url as #cCccCc Pin
Shawn Souto4-Jun-10 15:07
Shawn Souto4-Jun-10 15:07 
QuestionRead external configuration file at runtime Pin
rbc10254-Jun-10 7:10
rbc10254-Jun-10 7:10 
AnswerRe: Read external configuration file at runtime Pin
Not Active4-Jun-10 7:56
mentorNot Active4-Jun-10 7:56 
GeneralRe: Read external configuration file at runtime Pin
rbc10254-Jun-10 19:08
rbc10254-Jun-10 19:08 
GeneralRe: Read external configuration file at runtime Pin
Not Active5-Jun-10 2:47
mentorNot Active5-Jun-10 2:47 
QuestionError:Passing parameter to Sp Pin
Sabui4-Jun-10 1:23
Sabui4-Jun-10 1:23 
Dears,

Iam new to vb.net,please help me to pass parameter to for my VB.net project,

I want to pass @Ridfrom to SP:usp_Procedure and return value to @PidTo .

The below mentioned is my codings.can u susggest a way to solve the error

Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged
Dim combo As String
Dim SQLEV As SqlClient.SqlConnection = New SqlClient.SqlConnection
SQLEV.ConnectionString = "Persist Security Info=False;Integrated Security=SSPI;database=db_chart;server=nrppc-mis1\sqlexpress"

combo = ComboBox1.SelectedValue.ToString

Dim command As New SqlCommand("usp_Procedure", SQLEV)
Dim adapter As New SqlDataAdapter(command)

command.CommandType = CommandType.StoredProcedure
With command.Parameters
.Add(New SqlParameter("@Ridfrom", SqlDbType.NVarChar))
.Add(New SqlParameter("@PidTo", SqlDbType.Money)).Direction = ParameterDirection.Output
.Add(New SqlParameter("Returnvalue", SqlDbType.Int)).Direction = ParameterDirection.ReturnValue
End With
End Sub


this is my stored procedure

eg:If i pass @RidFrom=1 im getting Output value @pidTo=3

ALTER PROCEDURE usp_Procedure
@Ridfrom nVarChar(50),
@PidTo nVarchar(20) output

AS

SELECT @PidTo = ProcDetails.Procedure_ID
FROM ReportMaster INNER JOIN
ProcDetails ON ReportMaster.Procedure_ID = ProcDetails.Procedure_ID
WHERE ReportMaster.Report_ID = @Ridfrom

RETURN

AnswerRe: Error:Passing parameter to Sp Pin
Not Active4-Jun-10 1:51
mentorNot Active4-Jun-10 1:51 
GeneralRe: Error:Passing parameter to Sp Pin
Sabui4-Jun-10 20:09
Sabui4-Jun-10 20:09 
GeneralRe: Error:Passing parameter to Sp Pin
Not Active5-Jun-10 2:43
mentorNot Active5-Jun-10 2:43 
AnswerRe: Error:Passing parameter to Sp Pin
Peace ON4-Jun-10 2:33
Peace ON4-Jun-10 2:33 
QuestionHow the machine know if the .net code is re-compile by the JIT compiler ? Pin
Yanshof4-Jun-10 0:33
Yanshof4-Jun-10 0:33 
AnswerRe: How the machine know if the .net code is re-compile by the JIT compiler ? Pin
_Erik_4-Jun-10 0:46
_Erik_4-Jun-10 0:46 
AnswerRe: How the machine know if the .net code is re-compile by the JIT compiler ? Pin
Luc Pattyn4-Jun-10 0:51
sitebuilderLuc Pattyn4-Jun-10 0:51 
AnswerRe: How the machine know if the .net code is re-compile by the JIT compiler ? Pin
Henry Minute4-Jun-10 0:55
Henry Minute4-Jun-10 0:55 
AnswerRe: How the machine know if the .net code is re-compile by the JIT compiler ? Pin
dan!sh 4-Jun-10 3:06
professional dan!sh 4-Jun-10 3:06 
Question.net remoting OR web services OR WCF Service Pin
divyesh14323-Jun-10 19:27
divyesh14323-Jun-10 19:27 
AnswerRe: .net remoting OR web services OR WCF Service Pin
dan!sh 3-Jun-10 21:29
professional dan!sh 3-Jun-10 21:29 
AnswerRe: .net remoting OR web services OR WCF Service Pin
Peace ON3-Jun-10 21:42
Peace ON3-Jun-10 21:42 
AnswerRe: .net remoting OR web services OR WCF Service Pin
Abhinav S3-Jun-10 21:45
Abhinav S3-Jun-10 21:45 
GeneralRe: .net remoting OR web services OR WCF Service Pin
dan!sh 3-Jun-10 21:51
professional dan!sh 3-Jun-10 21:51 
QuestionsqlDependency cache- notification model Pin
senthu33-Jun-10 11:55
senthu33-Jun-10 11:55 
QuestionSending a keystroke to all applications Pin
Kevin Geary2-Jun-10 6:55
Kevin Geary2-Jun-10 6:55 
AnswerRe: Sending a keystroke to all applications Pin
Luc Pattyn2-Jun-10 7:24
sitebuilderLuc Pattyn2-Jun-10 7:24 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.