i run the programe but the following error occur....
code in lass libary
public class Class1
{
public bool addguest(int guest_id, string first_name, string phone_number,string email_address)
{
try
{
Database db = DatabaseFactory.CreateDatabase("sed");
db.ExecuteDataSet("addguest", new object[] { guest_id, first_name, phone_number,email_address });
return true;
}
catch
{
return false;
}
}
public DataTable show()
{
Database db = DatabaseFactory.CreateDatabase("sed");
return db.ExecuteDataSet("view").Tables[0];
}
and code in
application in whih i add template files and this class library in this application
public class Class1
{
public bool addguest(int guest_id, string first_name, string phone_number,string email_address)
{
try
{
Database db = DatabaseFactory.CreateDatabase("sed");
db.ExecuteDataSet("addguest", new object[] { guest_id, first_name, phone_number,email_address });
return true;
}
catch
{
return false;
}
}
public DataTable show()
{
Database db = DatabaseFactory.CreateDatabase("sed");
return db.ExecuteDataSet("view").Tables[0];
}
in this line error occur
return db.ExecuteDataSet("view").Tables[0];
and store proedure is
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[view]
@Guest_ID int,
@first_name nvarchar(50),
@phone_number nvarchar(50),
@email_address nvarchar(50)
as
select GuestInfo.Guest_id,GuestInfo.first_name,GuestInfo.phone_number,GuestInfo.email_address from GuestInfo
and add guest store procedure is
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[addguest]
@Guest_ID int,
@first_name nvarchar(50),
@phone_number nvarchar(50),
@email_address nvarchar(50)
as
insert into GuestInfo(Guest_ID,First_name,Phone_number,Email_address)
values(@Guest_ID,@first_name,@Phone_number,@email_address)
this error occur....
the number of parameters does not match number of values for stored procedure
Bakhtawar As...
Member
26 Points
141 Posts
parameters
Feb 23, 2013 05:47 PM|LINK
i run the programe but the following error occur....
code in lass libary
public class Class1 { public bool addguest(int guest_id, string first_name, string phone_number,string email_address) { try { Database db = DatabaseFactory.CreateDatabase("sed"); db.ExecuteDataSet("addguest", new object[] { guest_id, first_name, phone_number,email_address }); return true; } catch { return false; } } public DataTable show() { Database db = DatabaseFactory.CreateDatabase("sed"); return db.ExecuteDataSet("view").Tables[0]; }and code in
application in whih i add template files and this class library in this application
public class Class1 { public bool addguest(int guest_id, string first_name, string phone_number,string email_address) { try { Database db = DatabaseFactory.CreateDatabase("sed"); db.ExecuteDataSet("addguest", new object[] { guest_id, first_name, phone_number,email_address }); return true; } catch { return false; } } public DataTable show() { Database db = DatabaseFactory.CreateDatabase("sed"); return db.ExecuteDataSet("view").Tables[0]; }in this line error occur
return db.ExecuteDataSet("view").Tables[0];and store proedure is
and add guest store procedure is
this error occur....
the number of parameters does not match number of values for stored procedure
ToughMan
Participant
1490 Points
635 Posts
Re: parameters
Feb 24, 2013 02:40 AM|LINK
How did u write this?
Bakhtawar As...
Member
26 Points
141 Posts
Re: parameters
Feb 24, 2013 06:15 AM|LINK
hm..so what i write?
ToughMan
Participant
1490 Points
635 Posts
Re: parameters
Feb 24, 2013 06:20 AM|LINK
Ur codes in detail of the function
Bakhtawar As...
Member
26 Points
141 Posts
Re: parameters
Feb 24, 2013 06:32 AM|LINK
sorry i cant understand your point...can u tell in briefly..
ToughMan
Participant
1490 Points
635 Posts
Re: parameters
Feb 25, 2013 12:43 AM|LINK
Plz show us your detail codes of
chetan.sarod...
All-Star
65719 Points
11133 Posts
Re: parameters
Feb 25, 2013 02:31 AM|LINK
This mean stored procedure has more parameters specified then parameters' values received.
Senior Software Engineer,
Approva Systems Pvt Ltd, Pune, India.
Bakhtawar As...
Member
26 Points
141 Posts
Re: parameters
Feb 27, 2013 07:17 PM|LINK
i check but the parameters is same as as in the database ...