"Procedure or function sptblTrgFACalculator_Insert_v2 has too many arguments specified"
This error was produced when i tried to insert 12 arguments into my table.Is there a limit to the number of arguments you can pass into your stored procedure?
I have an SqlDataSource control on my aspx page, this is connected to database by a built in procedure that returns a string dependent upon and ID passed in.
I have the followinbg codewhich is not complet, I woiuld appriciate any help to produce the correct code for the code file
Function GetCategoryName(ByVal ID As Integer) As String sdsCategoriesByID.SelectParameters("ID").Direction = Data.ParameterDirection.Input sdsCategoriesByID.SelectParameters.Item("ID").DefaultValue = 3 sdsCategoriesByID.Select() <<<< THIS LINE COMES UP WITH ERROR 1End Function
ERROR AS FOLLOWS
argument not specified for parameter 'arguments' of public function Select(arguments as System.Web.DatasourceSelect Arguments as Collections ienumerable
Help I have not got much more hair to loose
Thanks Steve
Hi,
I've found that I'm not the first one to get the error
"Procedure or function x has too many arguments specified"
while working with Stored Procedures (which is no surprise at all). But
all suggested solutions didn't help, maybe this is because I
misunderstood the whole concept. The situation is: On my page there is
a FormView control including the EditItemTemplate. The database
contains a Stored Procedure called UpdatePersonByID which is working
fine as long as executed in Visual Web Developer. Here's the procedure
code:
ALTER PROCEDURE dbo.UpdatePersonByID
(
@LastName varchar(50),
@FirstName varchar(50),
@Phone varchar(50),
@PhonePrivate varchar(50),
@PhoneMobile varchar(50),
@Email varchar(50)
)
AS
UPDATE
tblPersons
SET
PersonLastName = @LastName,
PersonFirstName = @FirstName,
PersonPhone = @Phone,
PersonPhonePrivate = @PhonePrivate,
PersonPhoneMobile = @PhoneMobile,
PersonEmail = @Email
WHERE
PersonLastName = @LastName
RETURN
This is not exactly what it will finally have to do, of course the
WHERE-clause later will contain an ID comparison. But since I tried to
break down my code as much as possible I changed it to what you see
right now. Here's the aspx-source (the red stuff is what I think is
important):
<%@ Page
Language="VB"
MasterPageFile="fb10.master"
AutoEventWireup="false"
CodeFile="codebehind/staff.aspx.vb"
Inherits="staff"
meta:ResourceKey="PageResource"
%>
<%@ MasterType VirtualPath ="~/fb10.master" %>
<asp:Content
ID="ContentStaff"
ContentPlaceHolderID="cphContentMain"
Runat="Server">
<h3 id="hdStaff" runat="server" meta:resourcekey="Staff" />
<!-- DataSource srcStaff collects all persons from staff table in database. -->
<asp:SqlDataSource
ID="srcStaff"
runat="server"
ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommandType="StoredProcedure"
SelectCommand="SelectPersonNames"
/>
<asp:DropDownList
ID="ddlStaff"
runat="server"
DataSourceID="srcStaff"
DataTextField="CompleteName"
DataValueField="PersonID"
AutoPostBack="True">
</asp:DropDownList>
<!-- DataSource srcPerson gets person selected in DropDownList "ddlStaff". -->
<asp:SqlDataSource
ID="srcPerson"
runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
ProviderName="System.Data.SqlClient"
SelectCommand="SelectPersonByID"
SelectCommandType="StoredProcedure"
UpdateCommand="UpdatePersonByID"
UpdateCommandType="StoredProcedure"
OldValuesParameterFormatString="{0}" >
<SelectParameters>
<asp:ControlParameter
ControlID="ddlStaff"
DefaultValue="1"
Name="ID"
PropertyName="SelectedValue"
Type="Int32" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="LastName" Type="String" />
<asp:Parameter Name="FirstName" Type="String" />
<asp:Parameter Name="Phone" Type="String" />
<asp:Parameter Name="PhonePrivate" Type="String" />
<asp:Parameter Name="PhoneMobile" Type="String" />
<asp:Parameter Name="Email" Type="String" />
</UpdateParameters>
</asp:SqlDataSource>
<!-- DataSource srcBuildings gets all buildings from building table in database. -->
<asp:SqlDataSource
ID="srcBuildings"
runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
ProviderName="System.Data.SqlClient"
SelectCommand="SelectBuildings"
SelectCommandType="StoredProcedure">
</asp:SqlDataSource>
<asp:FormView
ID="fvStaff"
runat="server"
DataSourceID="srcPerson">
<EditItemTemplate>
<!--
DataSource srcRooms gets all rooms from room table in database. -->
<asp:SqlDataSource
ID="srcRooms"
runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
ProviderName="System.Data.SqlClient"
SelectCommand="SelectRoomsByBuildingID"
SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:ControlParameter
ControlID="ddlBuildings"
DefaultValue="1"
Name="ID"
PropertyName="SelectedValue"
Type="Int32"
/>
</SelectParameters>
</asp:SqlDataSource>
<asp:Label
cssClass="lblIdentifier" ID="lblLastName" runat="server"
meta:resourcekey="LastName" />
<asp:TextBox cssClass="staff" ID="LastName" runat="server"
Text='<%# Bind("PersonLastName")
%>'></asp:TextBox><br />
<asp:Label
cssClass="lblIdentifier" ID="lblFirstName" runat="server"
meta:resourcekey="FirstName" />
<asp:TextBox cssClass="staff" ID="FirstName" runat="server"
Text='<%# Bind("PersonFirstName")
%>'></asp:TextBox><br />
<asp:Label
CssClass="lblIdentifier" ID="lblBuilding" runat="server"
meta:resourcekey="Building"></asp:Label>
<asp:DropDownList
ID="ddlBuildings"
cssClass="small"
runat="server"
DataSourceID="srcBuildings"
DataTextField="BuildingAbbreviation"
DataValueField="BuildingID"
AutoPostBack="True"
SelectedValue='<%# Bind("RoomBuildingID") %>'
OnSelectedIndexChanged="ddlBuildings_SelectedIndexChanged">
</asp:DropDownList><br />
<asp:Label
cssClass="lblIdentifier" ID="lblRoom" runat="server"
meta:resourcekey="Room" />
<asp:DropDownList
ID="ddlRooms"
cssClass="small"
runat="server"
DataSourceID="srcRooms"
DataTextField="RoomName"
DataValueField="RoomID"
AutoPostBack="true"
SelectedValue='<%# Bind("PersonRoomID") %>'>
</asp:DropDownList><br />
<asp:Label
cssClass="lblIdentifier" ID="lblPhone" runat="server"
meta:resourcekey="Phone" />
<asp:TextBox cssClass="staff" ID="Phone" runat="server" Text='<%#
Bind("PersonPhone") %>'></asp:TextBox><br />
<asp:Label
cssClass="lblIdentifier" ID="lblPhonePrivate" runat="server"
meta:resourcekey="Private" />
<asp:TextBox cssClass="staff" ID="PhonePrivate" runat="server"
Text='<%# Bind("PersonPhonePrivate")
%>'></asp:TextBox><br />
<asp:Label
cssClass="lblIdentifier" ID="lblPhoneMobile" runat="server"
meta:resourcekey="Mobile" />
<asp:TextBox cssClass="staff" ID="PhoneMobile" runat="server"
Text='<%# Bind("PersonPhoneMobile")
%>'></asp:TextBox><br />
<asp:Label
cssClass="lblIdentifier" ID="lblEmail" runat="server"
meta:resourcekey="Email" />
<asp:TextBox cssClass="staff" ID="Email" runat="server" Text='<%#
Bind("PersonEmail") %>'></asp:TextBox><br />
<asp:LinkButton cssClass="lnkButton" ID="UpdateCancelButton"
runat="server" CausesValidation="False" CommandName="Cancel"
Text="<%$resources:translations,
Cancel%>"></asp:LinkButton>
<asp:LinkButton cssClass="lnkButton" ID="UpdateButton"
runat="server" CausesValidation="True" CommandName="Update"
Text="<%$resources:translations,
Update%>"></asp:LinkButton>
</EditItemTemplate>
<InsertItemTemplate>
<asp:Label
cssClass="lblIdentifier" ID="lblLastName" runat="server"
meta:resourcekey="LastName" />
<asp:TextBox ID="PersonLastNameTextBox"
runat="server"></asp:TextBox><br />
<asp:Label
cssClass="lblIdentifier" ID="lblFirstName" runat="server"
meta:resourcekey="FirstName" />
<asp:TextBox ID="PersonFirstNameTextBox"
runat="server"></asp:TextBox><br />
<asp:Label
cssClass="lblIdentifier" ID="lblBuilding" runat="server"
meta:resourcekey="Building" />
<asp:TextBox ID="BuildingAbbreviationTextBox"
runat="server"></asp:TextBox><br />
<asp:Label
cssClass="lblIdentifier" ID="lblRoom" runat="server"
meta:resourcekey="Room" />
<asp:TextBox ID="RoomNameTextBox"
runat="server"></asp:TextBox><br />
<asp:LinkButton cssClass="lnkButton" ID="InsertCancelButton"
runat="server" CausesValidation="False" CommandName="Cancel"
Text="<%$resources:translations,
Cancel%>"></asp:LinkButton>
<asp:LinkButton cssClass="lnkButton" ID="InsertButton"
runat="server" CausesValidation="True" CommandName="Insert"
Text="<%$resources:translations,
Insert%>"></asp:LinkButton>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label
cssClass="lblIdentifier" ID="lblLastName" runat="server"
meta:resourcekey="LastName" />
<asp:Label
cssClass="lblValue" ID="PersonLastNameLabel" runat="server"
Text='<%# Bind("PersonLastName") %>'></asp:Label><br
/>
<asp:Label
cssClass="lblIdentifier" ID="lblFirstName" runat="server"
meta:resourcekey="FirstName" />
<asp:Label
cssClass="lblValue" ID="PersonFirstNameLabel" runat="server"
Text='<%# Bind("PersonFirstName") %>'></asp:Label><br
/>
<asp:Label
cssClass="lblIdentifier" ID="lblBuilding" runat="server"
meta:resourcekey="Building" />
<asp:Label
cssClass="lblValue" ID="BuildingAbbreviationLabel" runat="server"
Text='<%# Bind("BuildingAbbreviation")
%>'></asp:Label><br />
<asp:Label
cssClass="lblIdentifier" ID="lblRoom" runat="server"
meta:resourcekey="Room" />
<asp:Label
cssClass="lblValue" ID="RoomLabel" runat="server" Text='<%#
Bind("RoomName") %>'></asp:Label><br />
<asp:Label
cssClass="lblIdentifier" ID="lblPhone" runat="server"
meta:resourcekey="Phone" />
<asp:Label
cssClass="lblValue" ID="PhoneLabel" runat="server" Text='<%#
Bind("PersonPhone") %>'></asp:Label><br />
<asp:Label
cssClass="lblIdentifier" ID="lplPhonePrivate" runat="server"
meta:resourcekey="Private" />
<asp:Label
cssClass="lblValue" ID="PhonePrivateLabel" runat="server" Text='<%#
Bind("PersonPhonePrivate") %>'></asp:Label><br />
<asp:Label
cssClass="lblIdentifier" ID="lblPhoneMobile" runat="server"
meta:resourcekey="Mobile" />
<asp:Label
cssClass="lblValue" ID="PhoneMobileLabel" runat="server" Text='<%#
Bind("PersonPhoneMobile") %>'></asp:Label><br />
<asp:Label
cssClass="lblIdentifier" ID="lblEmail" runat="server"
meta:resourcekey="Email" />
<asp:Label
cssClass="lblValue" ID="EmailLabel" runat="server" Text='<%#
Bind("PersonEmail") %>'></asp:Label><br />
<asp:LinkButton cssClass="lnkButton" ID="DeleteButton"
runat="server" CausesValidation="False" CommandName="Delete"
Text="<%$resources:translations,
Delete%>"></asp:LinkButton>
<asp:LinkButton cssClass="lnkButton" ID="EditButton" runat="server"
CausesValidation="False" CommandName="Edit"
Text="<%$resources:translations,
Edit%>"></asp:LinkButton>
</ItemTemplate>
</asp:FormView>
</asp:Content>
And then once again a totally different question: Is there a way to
post the highlighted aspx or vb code into this forum and keep the
colors? i think I've seen that in some posts but didn't wanna do it
manually.
Thanks once again for trying to help,
Toob
Im currently using Access 2000 which is connected to a SQL database. I have a query (Or View) that runs every month. The problem i had was i had to manually make some changes every month to get to the data i needed so i changed this View into a Function with a parameter so i can input the detail(s) i need and it will run correctly - this works so far but the original View was also used within other queries that were created. Now the problem i have now is some of the other views that are now connected with the newly created Function comes up with the error:
ADO error: an insufficient number of arguments were supplied for the procedure or function Name_Of_Function.
I called the newly created function the exact name as the original view to ensure i had no problems. Any idea of whats happening here and how to resolve?
Thanks
Hi,
We have an application written in ASP that calls a MS-SQL stored procedure and passes several parameters. Once in a while, we get this error, but most of the time it works. We can also run this in SQL query analyzer without ever a problem. We've looked at the obvious and found nothing wrong.
Please help! Any suggestions are appreciated.
(I posted this in ASP discussion board but no one replied)
Colleen
--------------------------------------------------------------------------------
|
Procedure or function sp_AddDealer has too many arguments specified.
I am experiencing the 'too many arguments specified' error. I am running on SQL 2005. The Parameters lists on SQL server (when I view a dropdown under the sp name) shows a 'returns integer' (but without the @ the signifies a parameter).I have looked around the forums and haven't seen quite this flavor of this error. My forehead is sore from beating it against the wall... any clue would be appreciated!
The error occurs when I click the 'new' link button, enter some data and then click the update link button after ... BOOM - Procedure or function sp_AddDealer has too many arguments specified.
Thanks!!
Chip Kigar
Here is the stored Procedure:
set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgo
ALTER PROCEDURE [dbo].[sp_AddDealer] @sCarcareSystem varchar(100), @sDealerName varchar(50), @sDealerPhysAddrStreet varchar(200), @sDealerPhysAddrCity varchar(100), @sDealerPhysAddrState varchar(10), @sDealerPhysAddrZip varchar(20), @nReturnCode bigint output, @nReturnId bigint output AS
SET NOCOUNT ON DECLARE @m_nCt bigint SET @nReturnCode = 0 SET @nReturnId = 0
-- VALIDATE IF (@nReturnCode = 0) BEGIN SELECT @m_nCt = COUNT(tblDealers.[_DealerId]) FROM tblDealers WHERE [Dealer Name] = @sDealerName IF (@m_nCt >0) BEGIN SET @nReturnCode = -2000 --'Error for exsiting Dealer' SET @nReturnId = 0 END END
-- PROCESS IF (@nReturnCode = 0) BEGIN SET @nReturnCode = -2 --' Error getting new record id' DECLARE @m_nNewRecId bigint SET @m_nNewRecId = 0 EXEC sp_GetNewRecId @m_nNewRecId output IF (@m_nNewRecId > 0) BEGIN SET @nReturnCode = -1 --'Error adding Dealer' INSERT INTO tblDealers ( [_DealerId], [Carcare System], [Dealer Name], [Dealer Phys Addr Street], [Dealer Phys Addr City], [Dealer Phys Addr State], [Dealer Phys Addr Zip] ) VALUES ( @m_nNewRecId, @sCarcareSystem, @sDealerName, @sDealerPhysAddrStreet, @sDealerPhysAddrCity, @sDealerPhysAddrState, @sDealerPhysAddrZip ) SET @nReturnCode = 0 --'Success' SET @nReturnId = @m_nNewRecId
END END
Here is the SQLDataSource. I plugged the ID parameter, so I got a schema back, but no data.
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" InsertCommand="sp_AddDealer" InsertCommandType="StoredProcedure" SelectCommand="sp_GetDealerByDealerId" SelectCommandType="StoredProcedure"> <SelectParameters> <asp:Parameter DefaultValue="2" Name="nDealerId" Type="Int64" /> <asp:Parameter DefaultValue="" Direction="Output" Name="nReturnCode" Type="Int64" /> <asp:Parameter Direction="Output" Name="nReturnId" Type="Int64" /> </SelectParameters> <InsertParameters> <asp:Parameter Name="sCarcareSystem" Type="String" /> <asp:Parameter Name="sDealerName" Type="String" /> <asp:Parameter Name="sDealerPhysAddrStreet" Type="String" /> <asp:Parameter Name="sDealerPhysAddrCity" Type="String" /> <asp:Parameter Name="sDealerPhysAddrState" Type="String" /> <asp:Parameter Name="sDealerPhysAddrZip" Type="String" /> <asp:Parameter Direction="InputOutput" Name="nReturnCode" Type="Int64" /> <asp:Parameter Direction="InputOutput" Name="nReturnId" Type="Int64" /> </InsertParameters> </asp:SqlDataSource>
Here is the Formview:
<asp:FormView ID="FormView1" runat="server" DataSourceID="SqlDataSource1"> <EditItemTemplate> _DealerId: <asp:TextBox ID="_DealerIdTextBox" runat="server" Text='<%# Bind("_DealerId") %>'> </asp:TextBox><br /> Carcare System: <asp:TextBox ID="Carcare_SystemTextBox" runat="server" Text='<%# Bind("[Carcare System]") %>'> </asp:TextBox><br /> Dealer Name: <asp:TextBox ID="Dealer_NameTextBox" runat="server" Text='<%# Bind("[Dealer Name]") %>'> </asp:TextBox><br /> Address Street: <asp:TextBox ID="Address_StreetTextBox" runat="server" Text='<%# Bind("[Address Street]") %>'> </asp:TextBox><br /> Address City: <asp:TextBox ID="Address_CityTextBox" runat="server" Text='<%# Bind("[Address City]") %>'> </asp:TextBox><br /> Address State: <asp:TextBox ID="Address_StateTextBox" runat="server" Text='<%# Bind("[Address State]") %>'> </asp:TextBox><br /> Address Zip: <asp:TextBox ID="Address_ZipTextBox" runat="server" Text='<%# Bind("[Address Zip]") %>'> </asp:TextBox><br /> <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update" Text="Update"> </asp:LinkButton> <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel"> </asp:LinkButton> </EditItemTemplate> <InsertItemTemplate> _DealerId: <asp:TextBox ID="_DealerIdTextBox" runat="server" Text='<%# Bind("_DealerId") %>'> </asp:TextBox><br /> Carcare System: <asp:TextBox ID="Carcare_SystemTextBox" runat="server" Text='<%# Bind("[Carcare System]") %>'> </asp:TextBox><br /> Dealer Name: <asp:TextBox ID="Dealer_NameTextBox" runat="server" Text='<%# Bind("[Dealer Name]") %>'> </asp:TextBox><br /> Address Street: <asp:TextBox ID="Address_StreetTextBox" runat="server" Text='<%# Bind("[Address Street]") %>'> </asp:TextBox><br /> Address City: <asp:TextBox ID="Address_CityTextBox" runat="server" Text='<%# Bind("[Address City]") %>'> </asp:TextBox><br /> Address State: <asp:TextBox ID="Address_StateTextBox" runat="server" Text='<%# Bind("[Address State]") %>'> </asp:TextBox><br /> Address Zip: <asp:TextBox ID="Address_ZipTextBox" runat="server" Text='<%# Bind("[Address Zip]") %>'> </asp:TextBox><br /> <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert" Text="Insert"> </asp:LinkButton> <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel"> </asp:LinkButton> </InsertItemTemplate> <ItemTemplate> _DealerId: <asp:Label ID="_DealerIdLabel" runat="server" Text='<%# Bind("_DealerId") %>'> </asp:Label><br /> Carcare System: <asp:Label ID="Carcare_SystemLabel" runat="server" Text='<%# Bind("[Carcare System]") %>'> </asp:Label><br /> Dealer Name: <asp:Label ID="Dealer_NameLabel" runat="server" Text='<%# Bind("[Dealer Name]") %>'> </asp:Label><br /> Address Street: <asp:Label ID="Address_StreetLabel" runat="server" Text='<%# Bind("[Address Street]") %>'> </asp:Label><br /> Address City: <asp:Label ID="Address_CityLabel" runat="server" Text='<%# Bind("[Address City]") %>'> </asp:Label><br /> Address State: <asp:Label ID="Address_StateLabel" runat="server" Text='<%# Bind("[Address State]") %>'> </asp:Label><br /> Address Zip: <asp:Label ID="Address_ZipLabel" runat="server" Text='<%# Bind("[Address Zip]") %>'> </asp:Label><br /> <asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" CommandName="New" Text="New"> </asp:LinkButton> </ItemTemplate> </asp:FormView>
Dear All,
I have a problem while trying to update the content of my page to the database by the means of a stored procedure
string OcompConnection = ConfigurationManager.ConnectionStrings["GenUserCode"].ConnectionString;
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(OcompConnection);
System.Data.SqlClient.SqlCommand ocmd = new System.Data.SqlClient.SqlCommand("Dealer_Insert", conn);ocmd.CommandType = CommandType.StoredProcedure;
ocmd.Parameters.Add(new SqlParameter("@UserCode"), SqlDbType.NVarChar);
ocmd.Parameters["@UserCode"] = TxtUserCode;
and also there is another error message saying that argument1: can not comvert from system.data.sqlclient.sqlparameter to string.
What am i Missing???
Eventually there is the try{open} and finally{close}
Many Thanks
Hi all,
In Object Explorer of my ComputerNameSQLEXPRESS, I have a Database "shcDB" with Table "dbo.MyFriends" which has fields "PersonID" (Int), "FirstName", "LastName", "StreetAddress", "City", "State", "ZipCode", "E-MailAddress" set up. When I executed the following query:
/////----shcSP-1.sql---////
USE shcDB
GO
EXEC sp_insertRecord 3, "Mary", "Smith", "789 New St.", "Chicago", "Illinos", "12345", "M_Smith@Yahoo.com"
GO
/////////////////////////////////////////////////////////////
I got the following error message:
Msg 8144, Level 16, State 2, Procure sp_insertRecord, Line 0
Procedure or Function sp_insertRecord has too many arguments specified.
(1) Why did I get this error?
(2) Where can I get the documents for explaining the procedures like 'sp_insertRecord', 'sp_delecteRocord', 'sp_getRecord', 'sp_updateRecord', etc. and error messages?
Please help and give me the answers for the above-mentioned questions.
Thanks in advance,
Scott Chang
P. S.
I used my PC at home to post the above message. I have not been able to post it by using my office PC in our LAN system. In my office LAN system, I have been struggling to figure out and solve the following strange thing: I log in http://forums.microsoft.com and "Sign Out" is on all the time. If I click on "Sign Out", I get "Logout: You have been successfully logged out of the the forums." page all the time. What is the cause to log me out? How can I get it resolved? Our Computer Administrator? Or Microsoft? What Department in Microsoft can help me to solve this problem? Please advise on this strange thing. Thanks.
Hello, I want to get data from datatable as below. I am getting error:
BC30516: Overload resolution failed because no accessible 'New' accepts this number of arguments. I did not understand what is wrong. Because everything is same as msdn library.
my codebehind is:
Imports System.Data
Imports System.Data.Sql
Imports System.Data.SqlClientPartial Class Default2 Inherits System.Web.UI.Page
Private Shared Function GetConnectionString() As String
' To avoid storing the connection string in your code,
' you can retrieve it from a configuration file.
Return "Data Source=Database;Initial Catalog=otel;Integrated Security=True;Pooling=False"
End FunctionProtected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.LoadDim connectionString As String = _
GetConnectionString()
' Create a SqlConnection to the database.Using connection As SqlConnection = New SqlConnection(connectionString)
' Create a SqlDataAdapter for the Suppliers table.Dim mailsAdapter As SqlDataAdapter = _ New SqlDataAdapter()
' A table mapping names the DataTable.mailsAdapter.TableMappings.Add("Table", "Pages")
connection.Open()Dim PagesCommand As SqlCommand = New SqlCommand( _"SELECT * FROM Pages", _
connection)
PagesCommand.CommandType = CommandType.Text
' Set the SqlDataAdapter's SelectCommand.
mailsAdapter.SelectCommand = PagesCommand
' Fill the DataSet.
Dim dataSet1 As Dataset = New Dataset("Pages") 'ERROR MESSAGE HERE...........................................mailsAdapter.Fill(dataSet1)
connection.Close()LblPageName.Text = CStr(dataSet1.Tables("Pages").Rows(0).Item(1))
TxtPageTitle.Text = CStr(dataSet1.Tables("Pages").Rows(0).Item(2))TxtPageSummary.Text = CStr(dataSet1.Tables("Pages").Rows(0).Item(3))
Rte1.Text = CStr(dataSet1.Tables("Pages").Rows(0).Item(4))TxtPageimgUrl.Text = CStr(dataSet1.Tables("Pages").Rows(0).Item(5))
End Using
End Sub
End Class
I have problem with LINQ. I have created SQL Server 2005 database Database.mdf in App_Data folder with two tables - Pages and PagesGroups. Table Pages consist of fields PageID, AspxForm, DescriptionEN, DescriptionPL, PagesGroupID, NavNameEN, NavNamePL, PageActive, NavToolTipEN, NavToolTipPL and table PagesGroups consist of PagesGroupID, NavGroupNameEN, NavGroupNamePL, NavGroupToolTipEN, NavGroupToolTipPL, GroupDescriptionPL, GroupDescriptionEN, GroupActive. I added example rows. I created DataClasses.dbml, where Pages is child of PagesGroups, and DataClasses.designer.cs, which cause error "No overload for method 'DataContext' takes '0' arguments", in App_Code folder. I started writing LINQ commands in master page (DataClassesDataContext db = new DataClassesDataContext(); var pages = from p in db.Pages select new { Description = p.PagesGroup.GroupDescriptionPL };).
What should I write in DataClasses.designer.cs that errors does not occur? What is wrong in my DataClasses.designer.cs?
I wrote source of DataClasses.designer.cs, MasterPage.master and error message below.
App_Code/DataClasses.designer.cs:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.Linq;
using System.Data.Linq.Mapping;
using System.Linq;
using System.Linq.Expressions;using System.Reflection;
[System.Data.Linq.Mapping.DatabaseAttribute(Name="Database")]
public partial class DataClassesDataContext : System.Data.Linq.DataContext
{
private static System.Data.Linq.Mapping.MappingSource mappingSource = new AttributeMappingSource();
public System.Data.Linq.Table<Page> Pages
{
get
{return this.GetTable<Page>();
}
}
public System.Data.Linq.Table<PagesGroup> PagesGroups
{
get
{return this.GetTable<PagesGroup>();
}
}
}
[Table(Name="dbo.Pages")]
public partial class Page : INotifyPropertyChanging, INotifyPropertyChanged
{
private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);
private int _PageID;
private string _AspxForm;
private string _DescriptionEN;
private string _DescriptionPL;
private int _PagesGroupID;
private string _NavNameEN;
private string _NavNamePL;
private bool _PageActive;
private string _NavToolTipEN;
private string _NavToolTipPL;
private EntityRef<PagesGroup> _PagesGroup;
public Page()
{
this._PagesGroup = default(EntityRef<PagesGroup>);
}
[Column(Storage="_PageID", AutoSync=AutoSync.Always, DbType="Int NOT NULL IDENTITY", IsPrimaryKey=true, IsDbGenerated=true)]
public int PageID
{
get
{
return this._PageID;
}
set
{
if ((this._PageID != value))
{
this.SendPropertyChanging();
this._PageID = value;
this.SendPropertyChanged("PageID");
}
}
}
[Column(Storage="_AspxForm", DbType="Char(10) NOT NULL", CanBeNull=false)]
public string AspxForm
{
get
{
return this._AspxForm;
}
set
{
if ((this._AspxForm != value))
{
this.SendPropertyChanging();
this._AspxForm = value;
this.SendPropertyChanged("AspxForm");
}
}
}
[Column(Storage="_DescriptionEN", DbType="NText", UpdateCheck=UpdateCheck.Never)]
public string DescriptionEN
{
get
{
return this._DescriptionEN;
}
set
{
if ((this._DescriptionEN != value))
{
this.SendPropertyChanging();
this._DescriptionEN = value;
this.SendPropertyChanged("DescriptionEN");
}
}
}
[Column(Storage="_DescriptionPL", DbType="NText", UpdateCheck=UpdateCheck.Never)]
public string DescriptionPL
{
get
{
return this._DescriptionPL;
}
set
{
if ((this._DescriptionPL != value))
{
this.SendPropertyChanging();
this._DescriptionPL = value;
this.SendPropertyChanged("DescriptionPL");
}
}
}
[Column(Storage="_PagesGroupID", DbType="Int NOT NULL")]
public int PagesGroupID
{
get
{
return this._PagesGroupID;
}
set
{
if ((this._PagesGroupID != value))
{
if (this._PagesGroup.HasLoadedOrAssignedValue)
{
throw new System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException();
}
this.SendPropertyChanging();
this._PagesGroupID = value;
this.SendPropertyChanged("PagesGroupID");
}
}
}
[Column(Storage="_NavNameEN", DbType="NVarChar(50) NOT NULL", CanBeNull=false)]
public string NavNameEN
{
get
{
return this._NavNameEN;
}
set
{
if ((this._NavNameEN != value))
{
this.SendPropertyChanging();
this._NavNameEN = value;
this.SendPropertyChanged("NavNameEN");
}
}
}
[Column(Storage="_NavNamePL", DbType="NVarChar(50) NOT NULL", CanBeNull=false)]
public string NavNamePL
{
get
{
return this._NavNamePL;
}
set
{
if ((this._NavNamePL != value))
{
this.SendPropertyChanging();
this._NavNamePL = value;
this.SendPropertyChanged("NavNamePL");
}
}
}
[Column(Storage="_PageActive", DbType="Bit NOT NULL")]
public bool PageActive
{
get
{
return this._PageActive;
}
set
{
{
this.OnPageActiveChanging(value);
this.SendPropertyChanging();
this._PageActive = value;
this.SendPropertyChanged("PageActive");
}
}
}
private void OnPageActiveChanging(bool value)
{
throw new NotImplementedException();
}
[Column(Storage="_NavToolTipEN", DbType="NText", UpdateCheck=UpdateCheck.Never)]
public string NavToolTipEN
{
get
{
return this._NavToolTipEN;
}
set
{
if ((this._NavToolTipEN != value))
{
this.SendPropertyChanging();
this._NavToolTipEN = value;
this.SendPropertyChanged("NavToolTipEN");
}
}
}
[Column(Storage="_NavToolTipPL", DbType="NText", UpdateCheck=UpdateCheck.Never)]
public string NavToolTipPL
{
get
{
return this._NavToolTipPL;
}
set
{
if ((this._NavToolTipPL != value))
{
this.SendPropertyChanging();
this._NavToolTipPL = value;
this.SendPropertyChanged("NavToolTipPL");
}
}
}
[Association(Name="PagesGroup_Page", Storage="_PagesGroup", ThisKey="PagesGroupID", IsForeignKey=true)]
public PagesGroup PagesGroup
{
get
{
return this._PagesGroup.Entity;
}
set
{
PagesGroup previousValue = this._PagesGroup.Entity;
if (((previousValue != value)
|| (this._PagesGroup.HasLoadedOrAssignedValue == false)))
{
this.SendPropertyChanging();
if ((previousValue != null))
{
this._PagesGroup.Entity = null;
previousValue.Pages.Remove(this);
}
this._PagesGroup.Entity = value;
if ((value != null))
{
value.Pages.Add(this);
this._PagesGroupID = value.PagesGroupID;
}
else
{
this._PagesGroupID = default(int);
}
this.SendPropertyChanged("PagesGroup");
}
}
}
public event PropertyChangingEventHandler PropertyChanging;
public event PropertyChangedEventHandler PropertyChanged;
protected virtual void SendPropertyChanging()
{
if ((this.PropertyChanging != null))
{
this.PropertyChanging(this, emptyChangingEventArgs);
}
}
protected virtual void SendPropertyChanged(String propertyName)
{
if ((this.PropertyChanged != null))
{
this.PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
}
}
}
[Table(Name="dbo.PagesGroups")]
public partial class PagesGroup : INotifyPropertyChanging, INotifyPropertyChanged
{
private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);
private int _PagesGroupID;
private string _NavGroupNameEN;
private string _NavGroupNamePL;
private string _NavGroupToolTipEN;
private string _NavGroupToolTipPL;
private string _GroupDescriptionEN;
private string _GroupDescriptionPL;
private bool _GroupActive;
private EntitySet<Page> _Pages;
public PagesGroup()
{
this._Pages = new EntitySet<Page>(new Action<Page>(this.attach_Pages), new Action<Page>(this.detach_Pages));
}
[Column(Storage="_PagesGroupID", AutoSync=AutoSync.Always, DbType="Int NOT NULL IDENTITY", IsPrimaryKey=true, IsDbGenerated=true)]
public int PagesGroupID
{
get
{
return this._PagesGroupID;
}
set
{
if ((this._PagesGroupID != value))
{
this.SendPropertyChanging();
this._PagesGroupID = value;
this.SendPropertyChanged("PagesGroupID");
}
}
}
[Column(Storage="_NavGroupNameEN", DbType="NVarChar(50) NOT NULL", CanBeNull=false)]
public string NavGroupNameEN
{
get
{
return this._NavGroupNameEN;
}
set
{
if ((this._NavGroupNameEN != value))
{
this.SendPropertyChanging();
this._NavGroupNameEN = value;
this.SendPropertyChanged("NavGroupNameEN");
}
}
}
[Column(Storage="_NavGroupNamePL", DbType="NVarChar(50) NOT NULL", CanBeNull=false)]
public string NavGroupNamePL
{
get
{
return this._NavGroupNamePL;
}
set
{
if ((this._NavGroupNamePL != value))
{
this.SendPropertyChanging();
this._NavGroupNamePL = value;
this.SendPropertyChanged("NavGroupNamePL");
}
}
}
[Column(Storage="_NavGroupToolTipEN", DbType="NText", UpdateCheck=UpdateCheck.Never)]
public string NavGroupToolTipEN
{
get
{
return this._NavGroupToolTipEN;
}
set
{
if ((this._NavGroupToolTipEN != value))
{
this.SendPropertyChanging();
this._NavGroupToolTipEN = value;
this.SendPropertyChanged("NavGroupToolTipEN");
}
}
}
[Column(Storage="_NavGroupToolTipPL", DbType="NText", UpdateCheck=UpdateCheck.Never)]
public string NavGroupToolTipPL
{
get
{
return this._NavGroupToolTipPL;
}
set
{
if ((this._NavGroupToolTipPL != value))
{
this.SendPropertyChanging();
this._NavGroupToolTipPL = value;
this.SendPropertyChanged("NavGroupToolTipPL");
}
}
}
[Column(Storage="_GroupDescriptionEN", DbType="NText", UpdateCheck=UpdateCheck.Never)]
public string GroupDescriptionEN
{
get
{
return this._GroupDescriptionEN;
}
set
{
if ((this._GroupDescriptionEN != value))
{
this.SendPropertyChanging();
this._GroupDescriptionEN = value;
this.SendPropertyChanged("GroupDescriptionEN");
}
}
}
[Column(Storage="_GroupDescriptionPL", DbType="NText", UpdateCheck=UpdateCheck.Never)]
public string GroupDescriptionPL
{
get
{
return this._GroupDescriptionPL;
}
set
{
if ((this._GroupDescriptionPL != value))
{
this.SendPropertyChanging();
this._GroupDescriptionPL = value;
this.SendPropertyChanged("GroupDescriptionPL");
}
}
}
[Column(Storage="_GroupActive", DbType="Bit NOT NULL")]
public bool GroupActive
{
get
{
return this._GroupActive;
}
set
{
if ((this._GroupActive != value))
{
this.SendPropertyChanging();
this._GroupActive = value;
this.SendPropertyChanged("GroupActive");
}
}
}
[Association(Name="PagesGroup_Page", Storage="_Pages", OtherKey="PagesGroupID")]
public EntitySet<Page> Pages
{
get
{
return this._Pages;
}
set
{
this._Pages.Assign(value);
}
}
public event PropertyChangingEventHandler PropertyChanging;
public event PropertyChangedEventHandler PropertyChanged;
protected virtual void SendPropertyChanging()
{
if ((this.PropertyChanging != null))
{
this.PropertyChanging(this, emptyChangingEventArgs);
}
}
protected virtual void SendPropertyChanged(String propertyName)
{
if ((this.PropertyChanged != null))
{
this.PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
}
}
private void attach_Pages(Page entity)
{
this.SendPropertyChanging();
entity.PagesGroup = this;
}
private void detach_Pages(Page entity)
{
this.SendPropertyChanging();
entity.PagesGroup = null;
}
}
MasterPage.master:
...
using System.Data.Linq;
using System.Data.Linq.Mapping;
using System.Globalization;
using System.Linq;
using System.Linq.Expressions;
...
public partial class MasterPage : System.Web.UI.MasterPage
{public void Page_Load(object sender, EventArgs e)
{
...
DataClassesDataContext db = new DataClassesDataContext();
...
if (Page.UICulture == "Polish")
{
...var pages = from p in db.Pages
where p.PagesGroup.GroupActive == true && p.PageActive == trueselect new { PagesGroupDescription = p.PagesGroup.GroupDescriptionPL };
}
else
{var pages = from p in db.Pages
where p.PagesGroup.GroupActive == true && p.PageActive == true
select new { PagesGroupDescription = p.PagesGroup.GroupDescriptionEN };
...
}
...
}
}
Error:
Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: CS1501: No overload for method 'DataContext' takes '0' argumentsc:UsersAdministratorDocumentsMy Web SitesKamil Szmit (szmitek)App_CodeDataClasses.designer.cs(25,22): error CS1501: No overload for method 'DataContext' takes '0' arguments
c:WindowsassemblyGAC_MSILSystem.Data.Linq3.5.0.0__b77a5c561934e089System.Data.Linq.dll: (Location of symbol related to previous error)
How do I convert Oracle's LTRIM(char, set) to SQL Server?
Thanks,
Jake
Can someone help me with this issue? I am trying to update a record using a sp. The db table has an identity column. I seem to have set up everything correctly for Gridview and SqlDataSource but have no clue where my additional, phanton arguments are being generated. If I specify a custom statement rather than the stored procedure in the Data Source configuration wizard I have no problem. But if I use a stored procedure I keep getting the error "Procedure or function <sp name> has too many arguments specified." But thing is, I didn't specify too many parameters, I specified exactly the number of parameters there are. I read through some posts and saw that the gridview datakey fields are automatically passed as parameters, but when I eliminate the ID parameter from the sp, from the SqlDataSource parameters list, or from both (ID is the datakey field for the gridview) and pray that .net somehow knows which record to update -- I still get the error. I'd like a simple solution, please, as I'm really new to this. What is wrong with this picture? Thank you very much for any light you can shed on this.
View 9 Replies View RelatedHi,I'm trying to store values from a session to sql server table. I created an sql stored procedure to pass the values into the database. For some reason when I'm running the website and trying to store value from session to database an error is being displayed with the following message "Procedure or function OrderFromCart has too many arguments specified". OrderFromCart is the name of the stored procedure. Any Ideas??ThanksInter FC
View 11 Replies View RelatedMy stored procedure: ALTER PROCEDURE [dbo].[ShortUpdateSurvey]
@s_survey_id int,
@s_survey_num varchar(10),
@s_job_address varchar(30),
@s_job_city varchar(20),
@s_client_name varchar(50),
@s_date_ordered datetime,
@s_date_required datetime,
@s_amount money
AS
SET NOCOUNT OFF;
UPDATE [survey_master]
SET
[survey_num] = @s_survey_num,
[job_address] = @s_job_address,
[job_city] = @s_job_city,
[client_name] = @s_client_name,
[date_ordered] = @s_date_ordered,
[date_required] = @s_date_required,
[amount] = @s_amount
WHERE [survey_id] = @s_survey_id My ASP code:
<asp:BoundField DataField="survey_id" HeaderText="Survey ID" SortExpression="survey_id" />
<asp:BoundField DataField="survey_num" HeaderText="Survey Num." SortExpression="survey_num" />
<asp:BoundField DataField="job_address" HeaderText="Address" SortExpression="job_address" />
<asp:BoundField DataField="job_city" HeaderText="City" SortExpression="job_city" />
<asp:BoundField DataField="client_name" HeaderText="Client" SortExpression="client_name" ReadOnly="True" />
<asp:BoundField DataField="date_ordered" HeaderText="Ordered" SortExpression="date_ordered" DataFormatString="{0:d}" HtmlEncode="False" />
<asp:BoundField DataField="date_required" HeaderText="Needed" SortExpression="date_required" DataFormatString="{0:d}" HtmlEncode="False" />
<asp:BoundField DataField="amount" HeaderText="Amount" SortExpression="amount" />
...
SelectCommand="ShortAddressSearch"
SelectCommandType="StoredProcedure"
UpdateCommand="ShortUpdateSurvey"
UpdateCommandType="StoredProcedure">
...
<UpdateParameters>
<asp:Parameter Name="s_survey_id" Type="Int32" />
<asp:Parameter Name="s_survey_num" Type="String" />
<asp:Parameter Name="s_job_address" Type="String" />
<asp:Parameter Name="s_job_city" Type="String" />
<asp:Parameter Name="s_client_name" Type="String" />
<asp:Parameter Name="s_date_ordered" Type="DateTime" />
<asp:Parameter Name="s_date_required" Type="DateTime" />
<asp:Parameter Name="s_amount" Type="Decimal" />
...
and once again, the error message:
"Procedure or function ShortUpdateSurvey has too many arguments specified."
TIA
Can someone help me with this? For the life of me, I cannot figure out why I recieve this error: Procedure or function usp_ContactInfo_Update has too many arguments specified.Here is my code: <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"SelectCommand="usp_ContactInfo_Select" SelectCommandType="StoredProcedure" UpdateCommand="usp_ContactInfo_Update"UpdateCommandType="StoredProcedure"><UpdateParameters><asp:Parameter Name="Division" Type="String" /><asp:Parameter Name="Address" Type="String" /><asp:Parameter Name="City" Type="String" /><asp:Parameter Name="State" Type="String" /><asp:Parameter Name="Zip" Type="String" /><asp:Parameter Name="Phone" Type="String" /><asp:Parameter Name="TollFree" Type="String" /><asp:Parameter Name="Fax" Type="String" /><asp:Parameter Name="Email" Type="String" /><asp:Parameter Name="Res" Type="Boolean" /><asp:Parameter Name="Res_Rec" Type="Boolean" /><asp:Parameter Name="Com" Type="Boolean" /><asp:Parameter Name="Com_Rec" Type="Boolean" /><asp:Parameter Name="Temp" Type="Boolean" /><asp:Parameter Name="Temp_Rec" Type="Boolean" /><asp:Parameter Name="Port" Type="Boolean" /><asp:Parameter Name="Land" Type="Boolean" /><asp:Parameter Name="Drop" Type="Boolean" /></UpdateParameters><SelectParameters><asp:ProfileParameter Name="DivID" PropertyName="Division" Type="String" /></SelectParameters></asp:SqlDataSource>Here is my Stored Proc:ALTER PROCEDURE dbo.usp_ContactInfo_Update @Division varchar(1),@Address varchar(50),@City varchar(50),@State varchar(2),@Zip varchar(10),@Phone varchar(20),@TollFree varchar(20),@Fax varchar(20),@Email varchar(50),@Res bit,@Res_Rec bit,@Com bit,@Com_Rec bit,@Temp bit,@Temp_Rec bit,@Port bit,@Land bit,@Drop bit/*(@parameter1 int = 5,@parameter2 datatype OUTPUT)*/AS/* SET NOCOUNT ON */ UPDATE tblDivisionSET Division = @Division, Address = @Address, City = @City, State = @State, Zip = @Zip, Phone = @Phone, TollFree = @TollFree, Fax = @Fax, Email = @Email,Residential = @Res, Residential_Recycling = @Res_Rec, Commercial = @Com, Commercial_Recycling = @Com_Rec, Temp = @Temp, Temp_Recycling = @Temp_Rec, Portable_Restrooms = @Port, Landscaping = @Land, Drop_Off_Center = @DropWHERE (Division = @Division) RETURNAny Help is greatly appreciated!
View 2 Replies View Relatedi have written procedure like belowALTER PROCEDURE GetDetails
(@vpid int,
@vpname varchar(30) OUTPUT,
@vprice int OUTPUT
)
ASselect @vpname=productname,@vprice=price from fastfood where prod_id=@vpid
RETURN
and codeSqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["con"].ConnectionString;SqlCommand cmd = new SqlCommand("GetDetails",con);cmd.CommandType = CommandType.StoredProcedure;
con.Open();
Hashtable items=new Hashtable();items = (Hashtable)Session["basketdata"];string name,price;
foreach(int s in items.Keys)
{
SqlParameter p1 = new SqlParameter("@vpid", SqlDbType.Int, 10);p1.Direction = ParameterDirection.Input;
p1.Value = s;
cmd.Parameters.Add(p1);
//cmd.Parameters.Add("@vpid", SqlDbType.Int, 10).Value=s;cmd.Parameters.Add("@vpname", SqlDbType.Char, 30).Direction=ParameterDirection.Output; cmd.Parameters.Add("@vprice", SqlDbType.Int, 10).Direction=ParameterDirection.Output;
cmd.ExecuteNonQuery();
name = cmd.Parameters["@vpname"].Value.ToString();price = cmd.Parameters["@vprice"].Value.ToString();
%>
}
showing too many arguments to procedure
Hi,
In Oracle we can use the arguments for the Cursor, it's very useful. Not sure how to do it in MS SQL Server 7.0.
For example, in SQL server we use the following cursor in a stored procedure,
select @intID =10
DECLARE cur_test CURSOR FOR
select object_id, object_name from objects
where object_id = @intID
OPEN ....
FETCH ....
....
How about I need to change the @intID for the cursor based on logical condition in the code after a while??
Am I supposed to close the cursor cur_test and re-declare it?? Is there any way to make the code neat and short?
Any idea/help would be greatly appreciated!
Dana Jian
Im getting this error when looping through a gridview. Im trying to save each row into the database. The weird thing is that it saves the first row, but errors out on the second.If I only add one item to the gridview, it works. The second row is screwing it up somehow. Any ideas? ------------------------------------------------------------------------------------------------------------------------------------------------------------------Some of my code to get an idea of how im doing it:(This
is for a shopping cart. It displays the products in the shopping cart.
If the order is approved by the CC processing company, each product
entry is saved in the DB. The gridview is being populated by my
ShoppingCart Profile Object.) SqlConnection objConn = new SqlConnection(ConfigurationManager.ConnectionStrings["rdevie"].ConnectionString);
SqlCommand objCmd = new SqlCommand("InsertOrderDetails", objConn);
objCmd.CommandType = CommandType.StoredProcedure;
objConn.Open();
foreach (GridViewRow row in gvOrderDetails.Rows)
{
objCmd.Parameters.Add("@idOrder", SqlDbType.Int).Value = orderNum;
objCmd.Parameters.Add("@fldName", SqlDbType.NVarChar).Value = ((Label)row.FindControl("lblName")).Text;
objCmd.Parameters.Add("@fldUnitPrice", SqlDbType.Money).Value = ((Label)row.FindControl("lblUnitPrice")).Text;
objCmd.Parameters.Add("@fldQuantity", SqlDbType.Int).Value = Convert.ToInt32(((Label)row.FindControl("lblQuantity")).Text);
if (!String.IsNullOrEmpty(((Label)row.FindControl("lblSku")).Text))
objCmd.Parameters.Add("@fldSku", SqlDbType.NVarChar).Value = ((Label)row.FindControl("lblSku")).Text;
else
objCmd.Parameters.Add("@fldSku", SqlDbType.NVarChar).Value = DBNull.Value;
objCmd.Parameters.Add("@fldSize", SqlDbType.NVarChar).Value = ((Label)row.FindControl("lblSize")).Text;
objCmd.Parameters.Add("@fldLogo", SqlDbType.NVarChar).Value = ((Label)row.FindControl("lblLogo")).Text;
objCmd.Parameters.Add("@fldPlacement", SqlDbType.NVarChar).Value = ((Label)row.FindControl("lblPlacement")).Text;
objCmd.Parameters.Add("@fldColor", SqlDbType.NVarChar).Value = ((Label)row.FindControl("lblColor")).Text;
objCmd.ExecuteNonQuery();
}
objCmd.Dispose();
objConn.Close();
objConn.Dispose();
Hi,I have a simple stored procedure that basically SELECT some data from database. I am calling this stored procedure using a sqldatasource. The first time I try it, it works perfectly fine. But I get the error message "Procedure or function has too many arguments specified" the second time I try to search for thing. This is the code that I have that called the stored procedure: Session("SearchItem") = txtSearch.Text.Trim SqlDataSource1.SelectCommand = "_MyStoredProcedure" SqlDataSource1.SelectParameters.Add("SearchItem", Session("SearchItem")) SqlDataSource1.SelectCommandType = SqlDataSourceCommandType.StoredProcedure Gridview1.DataSourceID = "SqlDataSource1" Gridview1.DataBind() The following is the code in the stored procedure: CREATE PROCEDURE [dbo].[_MyStoredProcedure] ( @SearchItem nvarchar(255) = NULL)ASSELECT Field1, Field2, Field3 FROM Registration WHERE((@SearchItem IS NULL) OR (Field1 LIKE '%' + @SearchItem + '%') OR (Field2 LIKE '%' + @SearchItem + '%'))GO Please help.Stan
View 6 Replies View RelatedI am trying to delete from a SQL table using two arguments, I currently use the following on the aspx page: <ItemTemplate><asp:LinkButton ID="cmdDeleteJob" runat="server" CommandName="CancelJob" Text="Delete" CssClass="CommandButton" CommandArgument='<%# Bind("Type_of_service") %>' OnClientClick="return confirm('Are you sure you want to delete this item?');"></asp:LinkButton></ItemTemplate> and then I use the following on the aspx.vb page: If e.CommandName = "CancelJob" Then Dim typeService As Integer = CType(e.CommandArgument, Integer) Dim typeDesc As String = "" Dim wsDelete As New page1 wsDelete.deleteAgencySvcs(typeService) gvTech.DataBind() I need to be able to pick up two CommandArguments.
View 4 Replies View RelatedHi, I'm a bit stumped as to how to do this.I have a string[] with a list of users, and I want to query my database to select only the users in this array and bind the datasource to a GridView, but I don't know how to write an SQL query to search for multiple results from the same field.
E.g. Say I have two results in my string[], fred and bob.How can I select data from the database for just those two users - "SELECT * FROM tblUsers WHERE UserName='bob' AND ??";
IF this is possible, I also need to bind it to a gridview. I tried the following, but it didn't work as I needed it to:
for(int a = 0; a < userArray.Length; a++){ conn.Open(); SqlCommand command = new SqlCommand("SELECT * FROM tblUsers WHERE UserName='" + userArray[a] + "'", conn); SqlDataReader reader = command.ExecuteReader(); grid.DataSource = reader; grid.DataBind(); conn.Close()}
That 'worked', but as I'm sure you can see, the data that was bound to the gridview was only the last result found, not the whole result set.
Any help is greatly appreciated.
I have two tables: Person (member_no, name) and Participant (participant, member_no) member_no is the primary key in Person.The stored procedure is:CREATE PROCEDURE dbo.InsertRecs@member_no char(10),@name char(10),@participant char(10)ASbegininsert into person (member_no, name)values (@member_no, @name)select @member_no = @@Identityinsert into participant (participant, member_no)values (@participant, @member_no)endGOWhen I run this via the DetailsView control and try to insert a record I always get "Procedure or function InsertRecs has too many arguments specified"If I remove the second table from the stored procedure it works fine.Does anyone have any ideas?
View 9 Replies View RelatedHello All,
I am having a very strange problem which I cannot figure out. I am using the ASP.NET 2.0 SqlDataSource control to insert a news item into a SQL Express database. When inserting the a message I receive the following error: Procedure or function has too many arguments specified
However according to me every thing adds up. Can anyone please help me figure out what is wrong? Here is the code:
SqlDataSource: <asp:SqlDataSource ID="sqlNews" runat="server" ConnectionString="<%$ ConnectionStrings:FlevoOptiekDB %>" SelectCommandType="StoredProcedure" SelectCommand="dbo.usp_News_ByID" InsertCommandType="StoredProcedure" InsertCommand="dbo.usp_News_Insert" UpdateCommandType="StoredProcedure" UpdateCommand="dbo.usp_News_Update" DeleteCommandType="StoredProcedure" DeleteCommand="dbo.usp_News_Delete" OldValuesParameterFormatString="{0}"> <SelectParameters> <asp:QueryStringParameter Name="p_iNewsID" QueryStringField="news_ID" /> </SelectParameters> <UpdateParameters> <asp:Parameter Name="p_dtmPublished" Type="DateTime" /> <asp:Parameter Name="p_sTitle" /> <asp:Parameter Name="p_sDescription" /> <asp:Parameter Name="p_sStaticUrl" /> <asp:Parameter Name="p_iPhotoID" /> <asp:Parameter Name="p_iNewsID" /> <asp:Parameter Name="p_iAlbumID" /> </UpdateParameters> <InsertParameters> <asp:Parameter Name="p_dtmPublished" Type="DateTime" /> <asp:Parameter Name="p_sTitle" /> <asp:Parameter Name="p_sDescription" /> <asp:Parameter Name="p_sStaticUrl" /> <asp:Parameter Name="p_iPhotoID" /> <asp:Parameter Name="p_iAlbumID" /> </InsertParameters> <DeleteParameters> <asp:QueryStringParameter Name="p_iNewsID" QueryStringField="news_ID" /> </DeleteParameters> </asp:SqlDataSource>Stored procedure:ALTER PROCEDURE dbo.usp_News_Insert( @p_sTitle VARCHAR(256), @p_sDescription TEXT, @p_sStaticUrl VARCHAR(256), @p_dtmPublished DATETIME, @p_iPhotoID INT, @p_iAlbumID INT)AS /* SET NOCOUNT ON */ INSERT INTO dbo.tbNews(news_Title, news_Description, news_StaticUrl, news_Published, photo_ID, album_ID) VALUES(@p_sTitle, @p_sDescription, @p_sStaticUrl, @p_dtmPublished, @p_iPhotoID, @p_iAlbumID) RETURN
Thanks, Maurits
I have tried to introduce information in webform with sp and she leaves the following error
View 1 Replies View RelatedGreetings everyone.
A couple days ago, i posted a question on the Access boards.Here (http://forums.databasejournal.com/showthread.php?s=&threadid=36511)
Long story short, instead of filtering the results Locally, returned by query run locally on linked tables in an access front end, seems we should filter remotly. Seems easier and more secure.
We still want to hand out MS Access front ends. The results of queries run by users must be filtered based on authetication and values in the tables they query. There would be two ways to accomplish this.
1 - Stored procedures, apprearing as queries in Access.
2 - Views, appearing as tables.
Stored procedures are sure to work, but somewhat a hassle, sine we have to write code for each.
Views seem to be the simplest approach. we only need to build an SQL statement representing the new table. yet again, we have not done any constructive filtering. Is there a way to pass arguments to views just like stored procedures?
An exemple could be :
SELECT field1, field2, field3 FROM edu_details WHERE ID_department = @usr_dept AND ID_Division = $usr_div
usr_dept and usr_div being fields in the queried table(or course) AND auth information.
Cheers,
Lawrence
Hello. I am pretty new to SQL Stored Procedure, and ran into a problem. I am guessing there is a simple solution to this, as I am self-teaching myself this stuff.
I currently have a procedure that creates a new table, by reading in columns from a variety of Linked Servers (ODBC connection to to Sybase databases)
I will want to generalize a procedure by setting as arguments the ODBC connection name and the name of the new table that will be created ("CREATE TABLE") so I can pass these in.
As a test of this idea, I created this as a simple procedure, but I get a syntax error when I try to Check Syntax this. Do I have to do something else when I reference the string "argu1" to specify a new table name, or an OPEN QUERY Linked table name? Thanks and Happy New Year!
CREATE PROCEDURE gis.pr_PARCEL_TEST( @argu1 char(25)) AS
CREATE TABLE @argu1
GO
I'm kind of new at doing something like this. I'm trying to pull data into a results that exists in one of two databases. It works fine with query analyzer
but gives me the error "has no parameters and arguments were supplied" when I try to convert it to a stored procedure.
The procedure is as follows, any help would be appreciated.
CREATE PROCEDURE sp_getInvoiceNoTest AS
declare @InVoiceNo as VarChar(30)
delete From Invoice_NBR
Insert into Invoice_NBR (Tran_NBr,ADDR_Name,ADDR_Line2,ADDR_Line3,CITY_NAM E,State_Name,ADDR_NAME2,ADDR_LINE4,ADDR_LINE5,CITY _NAME2,State_Name2)
select a.TranNo,b.AddrLine1,b.AddrLine2,b.AddrLine3,b.cit y,b.StateID,c.AddrName,c.AddrLine2,c.AddrLine3,c.C ity,c.StateID
from Colucw17.Acuity_App.dbo.tarInvoice as a
inner join
Colucw17.Acuity_App.dbo.tciAddress as b
on a.BilltoAddrKey=b.AddrKey
inner join
Colucw17.Acuity_App.dbo.tciAddress as c
on a.BilltoAddrKey=c.AddrKey and a.BilltoAddrKey=a.BilltoCustAddrKey
inner join
Colucw17.Acuity_App.dbo.tarCustomer as d
on a.CustKey=d.CustKey
inner join
Colucw17.Acuity_App.dbo.tciContact as f
on a.confirmtoCntctKey=f.CntctKey
where a.CreateuserID<>'admin' and a.TranNo='@InvoiceNo'
--Insert into Invoice_NBr (Tran_NBr,ADDR_Name,ADDR_Line2,ADDR_Line3,CITY_NAM E,State_Name,ADDR_NAME2,ADDR_LINE4,ADDR_LINE5,CITY _NAME2,State_Name2)
select a.TranNo,b.AddrLine1,b.AddrLine2,b.AddrLine3,b.cit y,b.StateID,c.AddrName,c.AddrLine2,c.AddrLine3,c.C ity,c.StateID
from Colucw17.CSM_App.dbo.tarInvoice as a
inner join
Colucw17.CSM_App.dbo.tciAddress as b
on a.BilltoAddrKey=b.AddrKey
inner join
Colucw17.CSM_App.dbo.tciAddress as c
on a.BilltoAddrKey=c.AddrKey and a.BilltoAddrKey=a.BilltoCustAddrKey
inner join
Colucw17.CSM_App.dbo.tarCustomer as d
on a.CustKey=d.CustKey
inner join
Colucw17.CSM_App.dbo.tciContact as f
on a.confirmtoCntctKey=f.CntctKey
where a.CreateuserID<>'admin' and a.TranNo='@InvoiceNo'
GO
Hi,
we can use 'sp_executesql' to execute any statemens. I have made a search and people, seems, need the dynamic sql only to process some table/cloumn unknown in advance. My idea is that the dynamic SQL feature is ideal for passing blocks of code (aka delegates). Particularily, you may require to execute different procedures under some acquired locks. A procedure would acquire the locks, execute the code and release the locks. The problem is, however, that I cannot find the specification for the variable length parameters. It seems not feasible for SPs. Nevertheless, the 'sp_executesql itself does accept the variable number of parameters. How? Can we look at the defenition?
Hi all,
I have got this issue when I am trying to store an Image on a database through a stored procedure. I give you the code in C# and the stored procedure
Code Snippet
//I have got these two variables with the ID(foreign key) and the array of bytes of the Image (the values are OK)
int ID_Inmueble
byte[] imagen -- dimension 26246
SqlConnection conn = new SqlConnection(...) //The conexion works fine (I tested it).
SqlCommand cmd = new SqlCommand();
SqlParameter[] param = new SqlParameter[2];
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsertaUnaFoto";
cmd.Connection = conn;
param[0] = new SqlParameter("@ID_Inmueble", SqlDbType.BigInt);
param[0].Value = ID_Inmueble;
param[1] = new SqlParameter("@Foto", SqlDbType.Image);
param[1].Value = imagen;
cmd.Parameters.AddRange(param);
SqlDataAdapter da = new SqlDataAdapter(conexion.GetSqlCommand());
da.Fill(ds); //here I got the error
The stored Procedure
T
Code Snippet
ALTER PROCEDURE dbo.InsertaUnaFoto
(@ID_Inmueble bigint,
@Foto Image)
AS
INSERT into Fotos (ID_Inmueble, Foto) values (@ID_Inmueble, @Foto)
Many Thanks,
Hello,
When I try to call a stored procedure I get an SQL-exception reading "Procedure or function insert_member has too many arguments specified."
As far as I can see the number of parameters in the application match the number of arguments in the stored procedure. I supply 10 parameters in the application and 10 in the procedure. Is the location of the declaration of the argument cgpID a problem?
ALTER PROCEDURE [dbo].[insert_member]
(
@mbrFirstName nvarchar(15),
@mbrLastName nvarchar(15),
@mbrStreetAddress nvarchar(15),
@mbrPostalAddress nvarchar(15),
@mbrTelephoneHome nvarchar(15),
@mbrTelephoneJob nvarchar(15),
@mbrEmail nvarchar(15),
@mbrActivityGroupID int,
@mbrPaymentMethod int
)
AS
INSERT INTO dbo.member(mbrFirstName, mbrLastName, mbrStreetAddress, mbrPostalAddress, mbrTelephoneHome, mbrTelephoneJob, mbrEmail)
VALUES (@mbrFirstName, @mbrLastName, @mbrStreetAddress, @mbrPostalAddress, @mbrTelephoneHome, @mbrTelephoneJob, @mbrEmail)
declare @cgpID int
set @cgpID = (select cgpID from currentgroup where cgpActivityGroupID = @cgpActivityGroupID)
INSERT INTO member_currentgroup
(mbrID, cgpID, mcgPaymentMethod)
values
(@@identity, @cgpID, @mcgPaymentMethod)
Hi
While coding with ASP.NET 2.0 I came across this error "Procedure or function InsertUpdateArtist_Tracks has too many arguments specified."
Its quite frustrating because I dont know what arguments are being referred to because I've clearly assigned the correct parameters with their correct values to this Stored procedure :InsertUpdateArtist_Tracks
Please can some help me with this? is there something fundamentality wrong with my code (Below) or is this a know Microsoft stuff up?
or by the way I'm using SQL Server 2005 and ASP.NET 2.0
Below is my sample code:
..............
'Insert or Update Artist_tracks table
Response.Write("<br><b>Inserting or Updating Artist_tracks table</b>")
AT_Title = SearchArtistsResults(i).title
AT_Meta_ID = SearchArtistsResults(i).meta_id
AT_AA_ID = AA_ID
Dim ParamTitle As SqlParameter
Dim ParamMeta As SqlParameter
Dim ParamAA_ID As SqlParameter
dbCommand.CommandText = "InsertUpdateArtist_Tracks"
dbCommand.CommandType = Data.CommandType.StoredProcedure
dbCommand.Connection = conn
ParamTitle = dbCommand.Parameters.Add(New SqlParameter("@AT_Title", Data.SqlDbType.VarChar, 50))
ParamTitle.Value = AT_Title
ParamTitle.Direction = Data.ParameterDirection.Input
Response.Write("<br>Sent through this Title =" & AT_Title)
ParamMeta = dbCommand.Parameters.Add(New SqlParameter("@AT_Meta_ID", Data.SqlDbType.Int))
ParamMeta.Value = AT_Meta_ID
ParamMeta.Direction = Data.ParameterDirection.Input
Response.Write("<br>Sent through this Meta_id =" & AT_Meta_ID)
ParamAA_ID = dbCommand.Parameters.Add(New SqlParameter("@AT_AA_ID", Data.SqlDbType.Int))
ParamAA_ID.Value = AT_AA_ID
ParamAA_ID.Direction = Data.ParameterDirection.Input
Response.Write("<br>Sent through this AT_AA_ID =" & AT_AA_ID)
conn.Open()
dbCommand.ExecuteNonQuery()
conn.Close()
..................
Thanks in Advance
I'm Deleting my record in the database using stored procedure and I'm always getting this error :Procedure or function DeleteSender has too many arguments specified. same as I insert record... here's my stored proc for delete:set ANSI_NULLS ONset QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[DeleteSender]@RecNo int ASDELETE FROM [Sender] WHERE [RecNo] = @RecNo for insert:set ANSI_NULLS ONset QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[InsertSender](@SenderID nvarchar(50), @SenderLastName nvarchar(50), @SenderFirstName nvarchar(50), @SenderAddress nvarchar(50), @SenderCity nvarchar(50), @SenderState nvarchar(25), @SenderZip nvarchar(10), @SenderTel nvarchar(25), @FS int, @TB int, @Status nvarchar(10), @EndBalance money)ASINSERT INTO [Sender] ([SenderID], [SenderLastName], [SenderFirstName], [SenderAddress], [SenderCity], [SenderState], [SenderZip], [SenderTel], [FS], [TB], [Status], [EndBalance]) VALUES (@SenderID, @SenderLastName, @SenderFirstName, @SenderAddress, @SenderCity, @SenderState, @SenderZip, @SenderTel, @FS, @TB, @Status, @EndBalance) aspx:<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %><%@ Register src="FormControl.ascx" TagName="FormControl" TagPrefix="uc1" %><%@ Register Assembly="RadGrid.Net2" Namespace="Telerik.WebControls" TagPrefix="radG" %><%@ Register Assembly="RadComboBox.Net2" Namespace="Telerik.WebControls" TagPrefix="radC" %><%@ Register Assembly="RadInput.Net2" Namespace="Telerik.WebControls" TagPrefix="radI" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" ><head runat="server"> <title>Sender</title> <link href="sender.css" rel="stylesheet" type="text/css" /></head><body> <form id="form1" runat="server"> <div class="wrapper"> <div class="banner"> <radG:RadGrid ID="rgSender" runat="server" GridLines="None" DataSourceID="sqlDataSource1" EnableAJAX="True" ShowStatusBar="True" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AllowAutomaticDeletes="True" Skin="3D" AutoGenerateColumns="False"> <MasterTableView CommandItemDisplay="Top" DataKeyNames="RecNo" DataSourceID="sqlDataSource1"> <ExpandCollapseColumn Visible="False"> <HeaderStyle Width="19px" /> </ExpandCollapseColumn> <RowIndicatorColumn Visible="False"> <HeaderStyle Width="20px" /> </RowIndicatorColumn> <EditFormSettings EditFormType="Template"> <FormTemplate> <table border="0"> <tr> <td> <asp:Label ID="Label1" runat="server" Text="Record No.:" Visible='<%# rgSender.EditIndexes.Count > 0 %>'></asp:Label></td> <td> <radI:RadTextBox ID="rtbRecNo" runat="server" Text='<%# Bind("RecNo") %>' Visible='<%# rgSender.EditIndexes.Count > 0 %>'> </radI:RadTextBox></td> <td> <asp:Label ID="Label8" runat="server" Text="Zip Code:"></asp:Label></td> <td> <radI:RadTextBox ID="rtbZip" runat="server" Text='<%# Bind("SenderZip") %>'> </radI:RadTextBox></td> </tr> <tr> <td> <asp:Label ID="Label2" runat="server" Text="Sender ID:"></asp:Label></td> <td><radI:RadTextBox ID="rtbSenderID" runat="server" Text='<%# Bind("SenderID") %>'> </radI:RadTextBox></td> <td> <asp:Label ID="Label9" runat="server" Text="Telephone #:"></asp:Label></td> <td><radI:RadTextBox ID="rtbTel" runat="server" Text='<%# Bind("SenderTel") %>'> </radI:RadTextBox></td> </tr> <tr> <td><asp:Label ID="Label3" runat="server" Text="First Name:"></asp:Label></td> <td><radI:RadTextBox ID="rtbFName" runat="server" Text='<%# Bind("SenderFirstName") %>'> </radI:RadTextBox></td> <td> <asp:Label ID="Label10" runat="server" Text="Total Free Sent:"></asp:Label></td> <td><radI:RadTextBox ID="rtbFS" runat="server" Text='<%# Bind("FS") %>'> </radI:RadTextBox></td> </tr> <tr> <td><asp:Label ID="Label4" runat="server" Text="Last Name:"></asp:Label></td> <td><radI:RadTextBox ID="rtbLName" runat="server" Text='<%# Bind("SenderLastName") %>'> </radI:RadTextBox></td> <td><asp:Label ID="Label11" runat="server" Text="Total Box Sent:"></asp:Label></td> <td> <radI:RadTextBox ID="rtbBS" runat="server" Text='<%# Bind("TB") %>'> </radI:RadTextBox></td> </tr> <tr> <td> <asp:Label ID="Label5" runat="server" Text="Address:"></asp:Label></td> <td><radI:RadTextBox ID="rtbAddress" runat="server" Text='<%# Bind("SenderAddress") %>'> </radI:RadTextBox></td> <td><asp:Label ID="Label12" runat="server" Text="Status:"></asp:Label></td> <td><radI:RadTextBox ID="rtbStatus" runat="server" Text='<%# Bind("Status") %>'> </radI:RadTextBox></td> </tr> <tr> <td><asp:Label ID="Label6" runat="server" Text="City:"> </asp:Label></td> <td> <radI:RadTextBox ID="rtbCity" runat="server" Text='<%# Bind("SenderCity") %>'> </radI:RadTextBox></td> <td><asp:Label ID="Label13" runat="server" Text="End Balance:"></asp:Label></td> <td><radI:RadTextBox ID="rtbEndBalance" runat="server" Text='<%# Bind("EndBalance") %>'> </radI:RadTextBox></td> </tr> <tr> <td> <asp:Label ID="Label7" runat="server" Text="State:"></asp:Label></td> <td><radI:RadTextBox ID="rtbState" runat="server" Text='<%# Bind("SenderState") %>'> </radI:RadTextBox> </td> <td> <asp:Button ID="btnUpdate" Text='<%# IIf(CType(Container,GridItem).OwnerTableView.IsItemInserted,"Insert","Update") %>' runat="server" CommandName='<%# IIf(CType(Container,GridItem).OwnerTableView.IsItemInserted,"PerformInsert","Update") %>'></asp:Button> <asp:Button ID="btnCancel" Text="Cancel" runat="server" CausesValidation="False" CommandName="Cancel"></asp:Button></td> </tr> </table> </FormTemplate> </EditFormSettings> <Columns> <radG:GridEditCommandColumn ButtonType="ImageButton"/> <radG:GridTemplateColumn HeaderText="Sender ID" UniqueName="TCSenderID"> <ItemTemplate> <asp:Label ID="lblSenderID" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "SenderID") %>'></asp:Label> </ItemTemplate> </radG:GridTemplateColumn> <radG:GridTemplateColumn HeaderText="First Name" UniqueName="TCSenderFName"> <ItemTemplate> <asp:Label ID="lblSenderFName" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "SenderFirstName") %>'></asp:Label> </ItemTemplate> </radG:GridTemplateColumn> <radG:GridTemplateColumn HeaderText="Last Name" UniqueName="TCSenderLName"> <ItemTemplate> <asp:Label ID="lblSenderLName" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "SenderLastName") %>'></asp:Label> </ItemTemplate> </radG:GridTemplateColumn> <radG:GridButtonColumn UniqueName="ButtonColumn" ConfirmText="Are you sure?" Text="Delete" CommandName="Delete" ButtonType="ImageButton" ImageUrl="RadControls/Grid/Skins/Default/Delete.gif" /> </Columns> </MasterTableView> </radG:RadGrid></div> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConString_TO_Cargo %>" SelectCommandType="StoredProcedure" SelectCommand="sp_SelectSender" DeleteCommandType="StoredProcedure" DeleteCommand="DeleteSender" InserCommandType="StoredProcedure" InsertCommand="InsertSender" OldValuesParameterFormatString="original_{0}" UpdateCommand="UPDATE [Sender] SET [SenderID] = @SenderID, [SenderLastName] = @SenderLastName, [SenderFirstName] = @SenderFirstName, [SenderAddress] = @SenderAddress, [SenderCity] = @SenderCity, [SenderState] = @SenderState, [SenderZip] = @SenderZip, [SenderTel] = @SenderTel, [FS] = @FS, [TB] = @TB, [Status] = @Status, [EndBalance] = @EndBalance WHERE [RecNo] = @original_RecNo AND [SenderID] = @original_SenderID AND [SenderLastName] = @original_SenderLastName AND [SenderFirstName] = @original_SenderFirstName AND [SenderAddress] = @original_SenderAddress AND [SenderCity] = @original_SenderCity AND [SenderState] = @original_SenderState AND [SenderZip] = @original_SenderZip AND [SenderTel] = @original_SenderTel AND [FS] = @original_FS AND [TB] = @original_TB AND [Status] = @original_Status AND [EndBalance] = @original_EndBalance"> <DeleteParameters> <asp:Parameter Name="RecNo" Type="Int32" /> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="SenderID" Type="String" /> <asp:Parameter Name="SenderLastName" Type="String" /> <asp:Parameter Name="SenderFirstName" Type="String" /> <asp:Parameter Name="SenderAddress" Type="String" /> <asp:Parameter Name="SenderCity" Type="String" /> <asp:Parameter Name="SenderState" Type="String" /> <asp:Parameter Name="SenderZip" Type="String" /> <asp:Parameter Name="SenderTel" Type="String" /> <asp:Parameter Name="FS" Type="Int32" /> <asp:Parameter Name="TB" Type="Int32" /> <asp:Parameter Name="Status" Type="String" /> <asp:Parameter Name="EndBalance" Type="Decimal" /> <asp:Parameter Name="original_RecNo" Type="Int32" /> <asp:Parameter Name="original_SenderID" Type="String" /> <asp:Parameter Name="original_SenderLastName" Type="String" /> <asp:Parameter Name="original_SenderFirstName" Type="String" /> <asp:Parameter Name="original_SenderAddress" Type="String" /> <asp:Parameter Name="original_SenderCity" Type="String" /> <asp:Parameter Name="original_SenderState" Type="String" /> <asp:Parameter Name="original_SenderZip" Type="String" /> <asp:Parameter Name="original_SenderTel" Type="String" /> <asp:Parameter Name="original_FS" Type="Int32" /> <asp:Parameter Name="original_TB" Type="Int32" /> <asp:Parameter Name="original_Status" Type="String" /> <asp:Parameter Name="original_EndBalance" Type="Decimal" /> </UpdateParameters> <InsertParameters> <asp:Parameter Name="SenderID" Type="String" /> <asp:Parameter Name="SenderLastName" Type="String" /> <asp:Parameter Name="SenderFirstName" Type="String" /> <asp:Parameter Name="SenderAddress" Type="String" /> <asp:Parameter Name="SenderCity" Type="String" /> <asp:Parameter Name="SenderState" Type="String" /> <asp:Parameter Name="SenderZip" Type="String" /> <asp:Parameter Name="SenderTel" Type="String" /> <asp:Parameter Name="FS" Type="Int32" /> <asp:Parameter Name="TB" Type="Int32" /> <asp:Parameter Name="Status" Type="String" /> <asp:Parameter Name="EndBalance" Type="Decimal" /> </InsertParameters> </asp:SqlDataSource> <br /> <radG:RadGrid ID="rgSenderDetails" runat="server" AutoGenerateColumns="False" GridLines="None"> <MasterTableView> <ExpandCollapseColumn Visible="False"> <HeaderStyle Width="19px" /> </ExpandCollapseColumn> <RowIndicatorColumn Visible="False"> <HeaderStyle Width="20px" /> </RowIndicatorColumn> </MasterTableView> </radG:RadGrid><br /> </div> </form></body></html> hope you can help me guys/// stings...
View 1 Replies View RelatedHi all I having suffering from a strange behavior when trying to update. I receive the following error :
Here is my code: Procedure or function SavePhotoHotelLang has too many arguments specified.
<asp:SqlDataSource ID="SqlDataSourceHotelPhotoList" runat="server" ConnectionString="<%$ ConnectionStrings:smileDBConnectionString %>"SelectCommand="SELECT phl.PhotoHotelLangId, ph.smallfilepath, ph.photorank, pht.Type, phl.name, phl.description, ph.PhotoHotelId FROM datPhotoHotel ph
INNER JOIN datPhotoHotelType pht ON ph.PhotoHotelTypeId = pht.PhotoHotelTypeId
LEFT OUTER JOIN datPhotoHotelLang phl on ph.PhotoHotelId = phl.PhotoHotelId WHERE HotelId = @HotelId and ( LanguageId = @languageId or LanguageId is null)"
UpdateCommand="SavePhotoHotelLang" UpdateCommandType="StoredProcedure">
<SelectParameters>
<asp:QueryStringParameter Name="HotelId" QueryStringField="HotelId" Type="int32" />
<asp:ControlParameter Name="languageId" ControlID="ddlLanguageForGV" PropertyName="SelectedValue" Type="int32" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="name"/>
<asp:Parameter Name="Description" />
<asp:ControlParameter Name="languageId" ControlID="ddlLanguageForGV" PropertyName="SelectedValue"/>
<asp:Parameter Name="PhotoHotelLangId" />
<asp:Parameter Name="PhotoHotelId" />
</UpdateParameters>
</asp:SqlDataSource>
<Grids:BulkEditGridView
ID="GvHotelPhotoList" runat="server"
DataSourceID="SqlDataSourceHotelPhotoList" AutoGenerateColumns="false" SaveButtonID="saveBtn"
DataKeyNames="PhotoHotelLangId, PhotoHotelId">
<Columns>
<asp:TemplateField>
<itemtemplate>
<asp:Image id="smallimage" runat="server" ImageUrl='<%# Eval("smallFilePath") %>'></asp:Image>
</itemtemplate>
<Edititemtemplate>
<asp:Image id="smallimageedit" runat="server" ImageUrl='<%# Eval("smallFilePath") %>'></asp:Image>
</Edititemtemplate>
</asp:TemplateField>
<asp:BoundField DataField="Name" HeaderText="Name"/>
<asp:BoundField DataField="Description" FooterText="Description"/>
<asp:BoundField DataField="photorank" HeaderText="Rank" ReadOnly="true"/>
<asp:BoundField DataField="Type" FooterText="Type" ReadOnly="true"/>
</Columns></Grids:BulkEditGridView>
">'>'>
alter procedure SavePhotoHotelLang @name varchar(100), @Description varchar(500), @languageId int, @PhotoHotelLangId int, @PhotoHotelId intasbegin
if ( @PhotoHotelLangId is null ) begin
insert into dbo.datPhotoHotelLang ( name, Description, languageId ) values (@name, @Description, @languageId, @PhotoHotelId) end else begin
update dbo.datPhotoHotelLang set name = @name, Description = @Description where PhotoHotelLangId = @PhotoHotelLangId
endend