User-1259781382 posted
Hi......
I have problem regarding calling stored procedure.......
Everytime i make a call to stored procedure in database...it generates exception "Procedure or function has too many arguments specified".....it works somewhere but in sum cases it generates exception.
Here is my code....
public DataSet getPropDetails(string strPropId)
{
//throw new NotImplementedException();
DataSet ds = new DataSet();
try
{
dVar.command.Connection = this.openConnection();
dVar.command.CommandText = "spGetPropertyDetails";
dVar.command.CommandType = CommandType.StoredProcedure;
//dVar.command.Parameters.Add("@propertyId", SqlDbType.NVarChar, 50).Value = strPropId;
SqlParameter param1 = new SqlParameter("@propertyId", SqlDbType.VarChar, 50);
param1.Value = strPropId;
dVar.command.Parameters.Add(param1);
dVar.da.SelectCommand = dVar.command;
dVar.da.Fill(ds);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dVar.command.Dispose();
dVar.da.Dispose();
dVar.connection.Close();
dVar.connection.Dispose();
}
return ds;
}
public DataSet getPropDetails(string strPropId)
{
//throw new NotImplementedException();
DataSet ds = new DataSet();
try
{
dVar.command.Connection = this.openConnection();
dVar.command.CommandText = "spGetPropertyDetails";
dVar.command.CommandType = CommandType.StoredProcedure;
SqlParameter param1 = new SqlParameter("@propertyId", SqlDbType.VarChar, 50);
param1.Value = strPropId;
dVar.command.Parameters.Add(param1);
dVar.da.SelectCommand = dVar.command;
dVar.da.Fill(ds);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dVar.command.Dispose();
dVar.da.Dispose();
dVar.connection.Close();
dVar.connection.Dispose();
}
return ds;
}
//here is my SQL stored procedure:
ALTER PROCEDURE [dbo].[spGetPropertyDetails]
-- Add the parameters for the stored procedure here
@propertyId varchar(50)
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 tblPropertyInfo.propOthDetails, tblPropertyInfo.propPastOwn, tblPropertyInfo.propBudget, tblPropertyInfo.propCarpetArea, tblPropertyInfo.propVideoLnk, tblPropertyInfo.propBhkType, tblPropertyAme.propAmeName,
tblPropertyVastu.propVastuName, tblPropertyArea.propAreaName, tblPropertyInfo.propertyId, tblPropertyInfo.propAmeId, tblPropertyInfo.propVastuId, tblPropertyInfo.propAreaIdFROM tblPropertyInfo INNER JOIN
tblPropertyAme ON tblPropertyInfo.propAmeId = tblPropertyAme.propAmeId INNER JOIN
tblPropertyVastu ON tblPropertyInfo.propVastuId = tblPropertyVastu.propVastuId INNER JOIN
tblPropertyArea ON tblPropertyInfo.propAreaId = tblPropertyArea.propAreaId
WHERE (tblPropertyInfo.propertyId = @propertyId);
END
What wrong m i doin ?????....waiting for ur reply....
Regards
