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
pankaj sharma
NA
3
0
problem with output parameter of stored procedure
Oct 31 2008 9:27 AM
I am getting error
System.Data.SqlClient.SqlException: Procedure or Function 'sp_login' expects parameter '@Results', which was not supplied. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at login.signin_Click(Object sender, ImageClickEventArgs e) in d:\Careforindiafinal\login.aspx.cs:line 40
my C# code is
SqlConnection myConnection;
connection dbconnection = new connection();
myConnection = dbconnection.connectiondb();
SqlCommand myCommand = new SqlCommand("[careforindia].[dbo].[sp_login]", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Connection = myConnection;
myCommand.CommandText = "sp_login";
myCommand.Parameters.Add(new SqlParameter("@username", SqlDbType.VarChar,255, "username"));
myCommand.Parameters.Add(new SqlParameter("@password", SqlDbType.VarChar,255, "password"));
myCommand.Parameters["@username"].Value = username.Value;
myCommand.Parameters["@password"].Value = password.Value;
// myCommand.Parameters.Add(new SqlParameter("@Result", SqlDbType.Int, 5, ParameterDirection.Output, false, 0, 50, "Result", DataRowVersion.Default, null));
SqlParameter Result = myCommand.Parameters.Add("@Result", SqlDbType.Int, 5);
Result.Direction = ParameterDirection.Output;
int res=1;
myCommand.ExecuteNonQuery();
res = (int)myCommand.Parameters["@Result"].Value;
My Procedure is
ALTER PROCEDURE [dbo].[sp_login]
-- Add the parameters for the stored procedure here
@username varchar ,
@password varchar ,
@Results int Output
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
Set @Results = (Select count(*) from [dbo].[user] where username = @username and password = password )
END
Can anyone help me to remove the error
for creating database connection i have created seprate class
Reply
Answers (
2
)
reading a text file, line by line and put it in 3D array in C#
Accessing form components from thread