Click here to Skip to main content
15,914,163 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: DataGrid with CHECKBOX and RADIOBUTTON in the column. Pin
User 418025427-Apr-17 11:14
User 418025427-Apr-17 11:14 
QuestionForce Browser to use updated pdf file instead of cache version Pin
Blikkies26-Apr-17 6:51
professionalBlikkies26-Apr-17 6:51 
AnswerRe: Force Browser to use updated pdf file instead of cache version Pin
jkirkerx26-Apr-17 9:37
professionaljkirkerx26-Apr-17 9:37 
GeneralRe: Force Browser to use updated pdf file instead of cache version Pin
Blikkies26-Apr-17 9:43
professionalBlikkies26-Apr-17 9:43 
AnswerRe: Force Browser to use updated pdf file instead of cache version Pin
ZurdoDev26-Apr-17 10:21
professionalZurdoDev26-Apr-17 10:21 
AnswerRe: Force Browser to use updated pdf file instead of cache version Pin
jkirkerx26-Apr-17 12:49
professionaljkirkerx26-Apr-17 12:49 
QuestionRDLC SetPageSettings Pin
D.Manivelan26-Apr-17 4:16
D.Manivelan26-Apr-17 4:16 
QuestionRE-Drop Down List Error Pin
Member 1116162526-Apr-17 2:32
Member 1116162526-Apr-17 2:32 
HI,

I am getting the following Errors,while inserting drop down list values in sql server database

ERROR:

Server Error in '/Online_Book_Shopping' Application.
Procedure or function 'spRegisteruser' expects parameter '@countryname', which was not supplied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Procedure or function 'spRegisteruser' expects parameter '@countryname', which was not supplied.

Source Error:

Line 60: cmd.Parameters.Add(password);
Line 61: con.Open();
Line 62: int i= cmd.ExecuteNonQuery();
Line 63: con.Close();
Line 64: }

Source File: e:\Vijaya\Online_Book_Shopping\SignUp.aspx.cs Line: 62

How to solve this???Please Help???

This is my code:
aspx.cs:-

protected void btnn_Click(object sender, EventArgs e)
{
string constr = ConfigurationManager.ConnectionStrings["CS"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constr))
    {

        SqlCommand cmd = new SqlCommand("spRegisteruser", con);
        cmd.CommandType = CommandType.StoredProcedure;
        SqlParameter name = new SqlParameter("@name", txtusername.Text);
        SqlParameter mobile = new SqlParameter("@mobile", txtmobilenumber.Text);
        SqlParameter password = new SqlParameter("@password", txtpassword.Text);
        SqlParameter dropdown = new SqlParameter("@country",DropDownList1.SelectedItem.Value);
        cmd.Parameters.Add(name);
        cmd.Parameters.Add(dropdown);
        cmd.Parameters.Add(mobile);
        cmd.Parameters.Add(password);
        con.Open();
     int i=  cmd.ExecuteNonQuery();
        con.Close();
    }

    Sql table:-

Create Table dbo.RegisteredUsers
(
ID int identity Primary Key,
Name nvarchar(20),
Country_Name nvarchar(30),
Mobile_No bigint,
[Password] nvarchar(20)
)
Go

This is storedprocedure:-

Alter Proc spRegisteruser
@Name nvarchar(20),
@countryname nvarchar(30),
@mobile bigint,
@password nvarchar(20)
As
Begin
Insert dbo.RegisteredUsers Values(@Name,@countryname,@mobile,@password)
End
Web.config:-

<connectionstrings>
<add name="CS" connectionstring="Server=.;Initial Catalog=Sample;Integrated Security=True;">

AnswerRe: RE-Drop Down List Error PinPopular
Jochen Arndt26-Apr-17 2:41
professionalJochen Arndt26-Apr-17 2:41 
GeneralRe: RE-Drop Down List Error Pin
ZurdoDev26-Apr-17 3:22
professionalZurdoDev26-Apr-17 3:22 
AnswerRe: RE-Drop Down List Error Pin
jsc4226-Apr-17 2:52
professionaljsc4226-Apr-17 2:52 
QuestionI want to show data in gridview even if only one dropdown is selected Pin
Member 1314815825-Apr-17 20:05
Member 1314815825-Apr-17 20:05 
AnswerRe: I want to show data in gridview even if only one dropdown is selected Pin
User 418025426-Apr-17 4:15
User 418025426-Apr-17 4:15 
QuestionI want to show data in gridview even if only one dropdown is selected..what will be the store procedure Pin
Member 1314815825-Apr-17 2:35
Member 1314815825-Apr-17 2:35 
AnswerRe: I want to show data in gridview even if only one dropdown is selected..what will be the store procedure Pin
User 418025425-Apr-17 2:43
User 418025425-Apr-17 2:43 
GeneralRe: I want to show data in gridview even if only one dropdown is selected..what will be the store procedure Pin
Member 1314815825-Apr-17 19:48
Member 1314815825-Apr-17 19:48 
GeneralRe: I want to show data in gridview even if only one dropdown is selected..what will be the store procedure Pin
User 418025426-Apr-17 4:18
User 418025426-Apr-17 4:18 
QuestionIE 11 giving XML5619: Incorrect document syntax Pin
dpkcp24-Apr-17 0:03
dpkcp24-Apr-17 0:03 
AnswerRe: IE 11 giving XML5619: Incorrect document syntax Pin
User 418025424-Apr-17 3:08
User 418025424-Apr-17 3:08 
QuestionDecide flow/featurs of ASP.NET MVC Project Pin
Member 1266445222-Apr-17 0:57
Member 1266445222-Apr-17 0:57 
AnswerRe: Decide flow/featurs of ASP.NET MVC Project Pin
User 418025422-Apr-17 4:18
User 418025422-Apr-17 4:18 
QuestionError Page , 404, 500 Pin
jkirkerx20-Apr-17 11:00
professionaljkirkerx20-Apr-17 11:00 
AnswerRe: Error Page , 404, 500 [got it to work, not sure if its solved] Pin
jkirkerx20-Apr-17 11:40
professionaljkirkerx20-Apr-17 11:40 
QuestionDevelop a Module in ASP.NET Pin
Muhammad Bilal20-Apr-17 4:08
Muhammad Bilal20-Apr-17 4:08 
AnswerRe: Develop a Module in ASP.NET Pin
User 418025420-Apr-17 14:29
User 418025420-Apr-17 14:29 

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.