Procedure 'Create_User' expects parameter '@Password', which was not supplied.

Hi All
Getting Procedure 'Create_User' expects parameter '@Password', which was not supplied error
I can't register new user in role based system app, the following code is from register.aspx:


private void Submit_Click(object sender, System.EventArgs e)


{


User user;


if (Context.User.Identity.IsAuthenticated)


user = new User(((SiteIdentity)User.Identity).UserID);


else


user = new User();


user.FullName = FullName.Text;


user.Email = Email.Text;


user.Password = Password.Text;


user.Biography = Biography.Text;


if (Context.User.Identity.IsAuthenticated)


{


user.Update();


Response.Redirect("Default.aspx");


}


else


{


if (user.Add() == -1)


ErrorMessage.Visible = true;


else


{


FormsAuthentication.SetAuthCookie( Email.Text, true );


Response.Redirect("Default.aspx");


}


}


}

The procedure is


ALTER PROCEDURE Create_User


@FullName varchar(100),


@Email varchar(100),


@Password varchar(16),


@Biography varchar(500)


AS


INSERT INTO Users (FullName, Email, Password, Biography, DateAdded)


VALUES (@FullName, @Email, @Password, @Biography, GETDATE())

Also if some can help me convert this code to vb.net
Don't know much C#
Best Regards
Primillo
Best Regards
Primillo
0
Primillo
11/16/2005 10:38:12 PM
asp.net.getting-started 91979 articles. 4 followers. Follow

5 Replies
725 Views

Similar Articles

[PageSpeed] 56
See related articles to this posting 


Hi All
 The last code breakes in the line when creating a new user:
if (user.Add() == -1)

Any Idea!
Regards
Best Regards
Primillo
0
Primillo
11/17/2005 1:10:24 AM 
An INSERT Statement will normally return 1 (one) when the insert was successful. See below for an example of how to check if the new User was successfully inserted into DataBase. I take it for granted that Add() Method is returning an Integer value. Without knowing all the facts here I would probably write my code something like this:

private void Submit_Click(object sender, System.EventArgs e)
{

    User user;
    
    // This leads me to ask if you are also using the Form to Update User information?
    // Is the SiteIdentity Class your own Class implementation or perhaps a User Control?
    if (Context.User.Identity.IsAuthenticated)
    {
        user = new User(((SiteIdentity)User.Identity).UserID);
        user.Update();
        Response.Redirect("Default.aspx");
        Response.End();
    }

    string fullName = FullName.Text;
    string email = Email.Text;
    string password = Password.Text;
    string biography = Biography.Text;

    user = new User();

    user.FullName = fullName;
    user.Email = email;
    user.Password = password;
    user.Biography = biography;

    int chkInsert = user.Add();

    if (chkInsert < 1)
    {
        ErrorMessage.Visible = true;
        return;
    }

    FormsAuthentication.SetAuthCookie(email, true);
    Response.Redirect("Default.aspx");

}

Translating this into VB.Net is really easy. You should try to do it yourself, and I recommend that you learn how to write code in C# as well, as a majority of examples and solutions are presented primarily in C#.
Regards

Andre Colbiornsen 
---------------------------------
Seventh Day
Råbygatan 1A,
SE-223 61 Lund
Sweden
Mob.: +46-(0)708-97 78 79
Mail: info@seventhday.se
--------------------------------
0
adec
11/17/2005 1:43:23 AM 
Hi adec
THX for the code, work ok, after I found the source of the issue:


I add the next two lines to the class User.cs
command.Parameters.Add("@Password", password);
command.Parameters.Add("@Biography", biography);

All code bellow:


public int Add()


{


int rowsAffected;


SqlConnection connection = new SqlConnection(connectionString);


SqlCommand command = new SqlCommand("Create_User", connection);


command.Parameters.Add("@FullName", fullName);


command.Parameters.Add("@Email", email);


// Next two lines added


command.Parameters.Add("@Password", password);


command.Parameters.Add("@Biography", biography);


command.CommandType = CommandType.StoredProcedure;


connection.Open();




try 


{


rowsAffected = command.ExecuteNonQuery();


}


catch (SqlException sqle)


{




if (sqle.Number == 2627)


return -1;


else


throw sqle;


}


finally


{


command.Dispose();


connection.Close();


}


return rowsAffected;


}

Best Regards
Pura Vida
Primillo
Best Regards
Primillo
0
Primillo
11/17/2005 3:41:29 AM 
Adec,

How did you format the code you posted so nicely?  Whenever I post code to the forum it's in this ugly font, and I don't get the right spacing like you have in your code.  Can you share your secret?


Kevin
People are like teabags.  You have to put them in hot water to know how strong they are.
0
thompsok
11/17/2005 5:55:27 AM 
Just manual labor. I switch to HTML mode, add <pre></pre> tags and paste my code example inside them. Switch back to Design mode and your code looks good, but the colour is gone.
Regards

Andre Colbiornsen 
---------------------------------
Seventh Day
Råbygatan 1A,
SE-223 61 Lund
Sweden
Mob.: +46-(0)708-97 78 79
Mail: info@seventhday.se
--------------------------------
0
adec
11/17/2005 6:20:21 AM
Reply:

Similar Artilces:

''''''''''''''''''''
Name: haznen Email: haznenatyahoodotcom Product: Gran Paradiso Alpha 8 Summary: '''''''''''''''''''' Comments: '''''''''''''''''''''''''''''''''''' Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9a1) Gecko/20061204 UGES/1.7.2.0 GranParadiso/3.0a1 From URL: http://www.mozilla.org/projects/granparadiso/ Note to readers: Hendrix gives...

'''''
Name: mario Email: ramar17atfastwebnetdotit Product: Gran Paradiso Alpha 2 Summary: ''''' Comments: K: Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9a2) Gecko/20070206 GranParadiso/3.0a2 ...

Procedure 'CRMC_ProductDetails' expects parameter '@Color', which was not supplied
I keep getting this error when I browse the productsdetail.aspx page... I am using the C# SDK version of the Commerce kit... I have added a new col in th eDB called "Color", and *thought* that I had fixed the strored proc, and the product.cs file... I can get the color from the db to display on the productslist.aspx page fine... Any ideas? Did you modify the ProductDetails GetProductDetails function in productsdb.cs?...

Procedure 'sp_GetEEByDept' expects parameter '@tkdept', which was not supplied.
I have a basic vb.net form with a few text fields and dropdown boxes.  In one of the dropdown boxes, I ask the user to select a department.  After the user selects the department, I want to fill another dropdown box with employees that belong to the selected dept.  I keep getting an error for my procedure that is to get the employees, because I can't figure out how to pass in the department selected in the first drop down box.  ARGH... Also, do I need to set the employee dropdown box visible to false until the first dropdown selection is made, otherwise, it'd be b...

Procedure 'JaiDeleteUser' expects parameter '@user_name', which was not supplied
<html xmlns="http://www.w3.org/1999/xhtml"> <head id="Head1" runat="server"><title>Untitled Page</title> </head> <body>   <form id="form1" runat="server"> <asp:ScriptManager ID="ScriptManager1" runat="server"> </asp:ScriptManager>   <div>   <br /> <asp:Label ID="lblUserInfo" runat="server" Text="Label"></asp:Label><asp:SqlDataSource ID="SqlDataSource1" runat="server"...

Procedure 'sp03_Delete_Usuario' expects parameter '@AN001_CDUSUARIO', which was not supplied.
I´m having problem to delete/update using stored procedure with gridview. Actually I made an update and delete work but just by itself not togheter. I made update ONLY works If I dont pass any fields from gridview to datakeynames and the delete show the following error: Procedure 'sp03_Delete_Usuario' expects parameter '@AN001_CDUSUARIO', which was not supplied. But the delete ONLY works if I pass all the fields form gridview to datakeynames. So the update stops to work. The code is:<%@ Page Language="VB" AutoEventWireup="false" CodeF...

Procedure 'x' expects parameter '@y' which was not supplied.
I'm trying to update a member's record via stored procedure. The procedure is thus: ********************************* CREATE PROCEDURE upd_MemberProfile( @MemberID VarChar(10), @FirstName VarChar(20), @LastName VarChar(20), @Address VarChar(50), @City VarChar(40), @StateID Char(2), @ZipCode Char(5), @Email VarChar(30), @PayPalSubscrID VarChar(22) ) AS UPDATE Members SET FirstName = @FirstName, LastName = @LastName, Address = @Address, City = @City, StateID = @StateID, ZipCode = @ZipCode, Email = @Email, PayPalSubscrID = @PayPalSubscrID WHERE Me...

Procedure or Function 'SubscribeToNewsletters' expects parameter '@emailAddress', which was not supplied.
Hi i have been trying to insert some values selected in a checkbox list into the database, however it is giving me the following error "Procedure or Function 'SubscribeToNewsletters' expects parameter '@emailAddress', which was not supplied. "public void Page_Load(object sender, EventArgs e) -- on page load the checkbox list is populated through stored procedure (stream_NewsletterTypes) { try {SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["streamConnectionString"].ConnectionString); SqlCommand command = new SqlCommand(...

Procedure or Function 'retrieve_product' expects parameter '@productPrice', which was not supplied.
Hi i am getting this error whenever i try to execute a stored procedure, below is my stored procedure;  ALTER PROCEDURE [dbo].[retrieve_product] -- Add the parameters for the stored procedure here @productPrice decimal (10,2), @productInfoURL varchar (255), @categoryName varchar (255),@companyName varchar (255), @subCategoryName varchar (255), @companyWebsiteURL varchar (255) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here SELECT Categories.categoryName, SubC...

Procedure or Function 'syl_EmailQueueInsert' expects parameter '@EmailCC', which was not supplied.
We have a email table in the database (SQL Server 2005). When we try to execute the Insert Stored Proc in the database to add a record and leave the EmailCC and EmailBCC fields blank we are getting the following error: Msg 201, Level 16, State 4, Procedure syl_EmailQueueInsert, Line 0Procedure or Function 'syl_EmailQueueInsert' expects parameter '@EmailCC', which was not supplied. The EmailCC and EmailBCC are set to allow nulls. Shouldn’t the system automatically insert nulls into those colums if no value is supplied??? What am I doing wrong? Newbie I a...

Procedure or Function 'UpdateContactInfoProc' expects parameter '@SUBURB', which was not supplied.
I tried to use this update stored procedure from a objectdatasource which calls the method "UpdateCompanyInfo", however, once I leave an item to be empty I got the error as title.My stored procedure:ALTER PROCEDURE dbo.UpdateContactInfoProc@Contact_ID int,@Contact_Type_ID int,@Name nvarchar(100),@TEL nvarchar(50),@EMAIL nvarchar(50),@ADDRESS nvarchar(200),@SUBURB nvarchar(50),@FAX nvarchar(50),@STATE nvarchar(50),@POSTCODE nvarchar(50),@COUNTRY nvarchar(50),@Description textASUpdate Contactset Contact_Type_ID = @Contact_Type_ID, [Name] = @Name, TEL = @TEL, EMAIL = @EMAIL, ADDRESS=@...

Error--Procedure 'SP_Insert_NewPipeLine' expects parameter '@CompanyId', which was not supplied.
Can any body help me in solving this problem. First I use to get Error which reads "Object Must Implement Iconvertible" After using the overloaded Sp.paramerers.add() function It started giving this problem. I am giving the sample code. ConObject = new SqlConnection(ConString); ConObject.Open(); string SpString ="dbo.SP_Insert_NewPipeLine"; SqlCommand CmdObject = new SqlCommand(SpString,ConObject); CmdObject.CommandType = CommandType.StoredProcedure; CmdObject.Parameters.Add("@RequestTypeId",SqlDbType.Int,4,"0"); //CmdObject.Parameters["@RequestTypeId"].Value= 0; CmdObject.Parame...

SQL_Error Procedure 'DelectHostName' expects parameter '@Host', which was not supplied.
How do I supply the parameter @Host?  Below is the part of my code that has the call to the stored procedure  public void DeleteHostName() { // start of the method using (SqlConnection cn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]))            {                 cn.Open();                SqlCommand cmd = new SqlCommand("hnDeleteHost&...

Procedure or function 'selectFromView' expects parameter '@Year', which was not supplied. ???
 hay all, i'm trying to pass parameters to a stored procedure ..and i keep getting this error "Procedure or function 'selectFromView' expects parameter '@Year', which was not supplied." this is the procedure implementation : ALTER PROCEDURE dbo.selectFromView @Year as varchar(10), @Country as varchar(10), @Family as varchar(10), @Manu as varchar(10), @Status as varchar(10), @Type as varchar(10), @Operator as varchar(10) AS SELECT * FROM ViewofAll WHERE ProductionYear = @Year...

Web resources about - Procedure 'Create_User' expects parameter '@Password', which was not supplied. - asp.net.getting-started

Resources last updated: 12/24/2015 1:49:16 AM