Exception Details: System.Data.SqlClient.SqlException: Procedure 'spInsertBillingQ' expects parameter '@bankname', which was not supplied.

Hello Coders,

 I need help fixing a problem in my code that I do not understand. I basically have a procedure that is supposed to take all user information and then insert it to the DB or update the Database based on user entry.

The call to the method is this

Dim

bankname As String = ""

If (objBill.BillTransaction(Session("conString"), Session("whattobill"), PROC_CURR, Session("lISN"), 0, Session("fISN"), Request.ServerVariables("REMOTE_ADDR"), "scott@mycleanstart.com", Session("fAmount"), Session("first_name"), Session("last_name"), Session("city"), Session("state"), Session("phone"), Session("address1"), Session("address2"), Session("postal_code"), Session("email_address"), Session("fDesc"), Session("ssn"), Session("nameoncard"), Session("PAN"), Session("cvv"), Session("cardexpirationdate"), bankname, Session("txtroutingnumber"), Session("txtaccountnumber"), Session("txtchecknumber"), Session("bqISN"), _

returnedbqISN, AuthCode, OrderNumber, DeclineCode, TermCode, ErrorMessage, authenticationValue, authenticationTransactionID, str_Centinal_ECI,

"signup", PAResStatus, SignatureVerification, paypalSubAgreeID, notificationLocation, strErrorNo, strErrorDesc, strTransactionID, strStatus, strStatusCode, strReasonCode)) Then

 

 And then below is the actual method itself........

NOTE: The code below is contained in a DLL

 

 

 

 

 

1    public bool BillTransaction(string strDBInstance, string ccORach, string whichProcessor,Int32 lISN, Int32 mISN, 
2    			Int32 fISN, string ip,string merchant_email,string total_amount, 
3    			string firstname, string lastname, string city,string state, string phone, string address1,string address2, string zip, string customer_email,
4    			string product_desc, string socialsecuritynum, string nameoncard, string creditcardnumber, Int32 cardverifynum, DateTime cardexpiredate,
5                string bankname, string routingnumber, string accountnumber, string checknumber, Int32 bqISN, 
6    			ref Int32 returnedbqISN, ref string AuthCode, ref string OrderNumber, ref string DeclineCode, 
7    			ref string TermCode, ref string ErrorMessage, 
8    			string authenticationValue,string authenticationTransactionID,string eci,string transactiontype,
9    			string PAResStatus, string SignatureVerification, string paypalSubAgreeID, string notificationLocation,
10   			ref string strErrorNo, ref string strErrorDesc, ref string strTransactionId, ref string strStatus, 
11   			ref string strStatusCode, ref string strReasonCode)
12    
13   		{
14    
15   			if (ccORach.Trim().Length <= 0)
16   			{
17   				ErrorMessage = "CC or Check?";
18   				return false;
19   			}
20    
21   			if (whichProcessor.Trim().Length <= 0)
22   			{
23   				ErrorMessage = "Blank processor";
24   				return false;
25   			}
26    
27   			decimal grand_total = Convert.ToDecimal(decimal.Parse(total_amount).ToString("N2"));
28   			string ProcessorResponse="";
29   			Database db = DatabaseFactory.CreateDatabase(strDBInstance);
30   			DBCommandWrapper dbCmdWrapper = null;
31   			bool retBilling = true;
32   			string sql = "";
33   			string bqAction = "SBILL";
34   			string strFirstName = "";
35   			string strLastName = "";
36   			string[] cardname = nameoncard.Split(new char[] {' '}); 
37   			strFirstName = cardname[0];
38   			for (int i=1; i <= cardname.GetUpperBound(0); i++)
39   			{
40   				strLastName = strLastName + ' ' + cardname[i].Trim();
41   			}
42    
43   			MCS_Encryption.Encryption mcscrypt = new MCS_Encryption.Encryption();
44   			//card number
45   			string enc_cardnumber = mcscrypt.Encrypt(creditcardnumber);
46   			//account number
47   			string enc_accountnumber = mcscrypt.Encrypt(accountnumber);
48    
49   			if (bqISN > 0)
50   			{
51   				//if bqISN is present, do UPDATE instead
52   				sql = "spUpdateBillingQ";
53   				dbCmdWrapper = db.GetStoredProcCommandWrapper(sql);
54   				dbCmdWrapper.AddInParameter("@bqISN",DbType.Int32,bqISN);
55   				dbCmdWrapper.AddInParameter("@email",DbType.String,customer_email);
56   				dbCmdWrapper.AddInParameter("@bankname",DbType.String,bankname);
57   				dbCmdWrapper.AddInParameter("@routingnumber",DbType.String,routingnumber);
58   				dbCmdWrapper.AddInParameter("@accountnumber",DbType.String,enc_accountnumber);
59   				dbCmdWrapper.AddInParameter("@checknumber",DbType.String,checknumber);
60   				dbCmdWrapper.AddInParameter("@nameoncard",DbType.String,nameoncard);
61   				dbCmdWrapper.AddInParameter("@cardnumber",DbType.String,enc_cardnumber);
62   				dbCmdWrapper.AddInParameter("@cardverifynum",DbType.Int32,cardverifynum);
63   				dbCmdWrapper.AddInParameter("@cardexpirationdate",DbType.DateTime,cardexpiredate);
64   				dbCmdWrapper.AddInParameter("@billaddress1",DbType.String,address1);
65   				dbCmdWrapper.AddInParameter("@billaddress2",DbType.String,address2);
66   				dbCmdWrapper.AddInParameter("@billcity",DbType.String,city);
67   				dbCmdWrapper.AddInParameter("@billstate",DbType.String,state);
68   				dbCmdWrapper.AddInParameter("@billzip",DbType.String,zip);
69   				dbCmdWrapper.AddInParameter("@billphone",DbType.String, phone);
70   				dbCmdWrapper.AddInParameter("@ip",DbType.String, ip);
71   				dbCmdWrapper.AddInParameter("@fISN",DbType.Int32, fISN);
72   				dbCmdWrapper.AddInParameter("@price",DbType.Currency, grand_total);
73   				dbCmdWrapper.AddInParameter("@description",DbType.String, product_desc);
74   				dbCmdWrapper.AddInParameter("@bqaction",DbType.String, bqAction);
75   				dbCmdWrapper.AddInParameter("@creditamount",DbType.Currency, 0);
76   				dbCmdWrapper.AddInParameter("@processor",DbType.String, whichProcessor);
77   				db.ExecuteNonQuery(dbCmdWrapper) ;	
78    
79   				returnedbqISN = bqISN;
80   			}
81   			else
82   			{
83   				//insert into billingQ or update if bqISN is passed
84   				sql = "spInsertBillingQ";
85   				dbCmdWrapper = db.GetStoredProcCommandWrapper(sql);
86   				dbCmdWrapper.AddInParameter("@lISN",DbType.Int32,lISN);
87   				dbCmdWrapper.AddInParameter("@mISN",DbType.Int32,mISN);
88   				dbCmdWrapper.AddInParameter("@email",DbType.String,customer_email);
89   				dbCmdWrapper.AddInParameter("@bankname",DbType.String,bankname);
90   				dbCmdWrapper.AddInParameter("@routingnumber",DbType.String,routingnumber);
91   				dbCmdWrapper.AddInParameter("@accountnumber",DbType.String,enc_accountnumber);
92   				dbCmdWrapper.AddInParameter("@checknumber",DbType.String,checknumber);
93   				dbCmdWrapper.AddInParameter("@nameoncard",DbType.String,nameoncard);
94   				dbCmdWrapper.AddInParameter("@cardnumber",DbType.String,enc_cardnumber);
95   				dbCmdWrapper.AddInParameter("@cardverifynum",DbType.Int32,cardverifynum);
96   				dbCmdWrapper.AddInParameter("@cardexpirationdate",DbType.DateTime,cardexpiredate);
97   				dbCmdWrapper.AddInParameter("@billaddress1",DbType.String,address1);
98   				dbCmdWrapper.AddInParameter("@billaddress2",DbType.String,address2);
99   				dbCmdWrapper.AddInParameter("@billcity",DbType.String,city);
100  				dbCmdWrapper.AddInParameter("@billstate",DbType.String,state);
101  				dbCmdWrapper.AddInParameter("@billzip",DbType.String,zip);
102  				dbCmdWrapper.AddInParameter("@billphone",DbType.String, phone);
103  				dbCmdWrapper.AddInParameter("@ip",DbType.String, ip);
104  				dbCmdWrapper.AddInParameter("@fISN",DbType.Int32, fISN);
105  				dbCmdWrapper.AddInParameter("@price",DbType.Currency, grand_total);
106  				dbCmdWrapper.AddInParameter("@description",DbType.String, product_desc);
107  				dbCmdWrapper.AddInParameter("@bqaction",DbType.String, bqAction);
108  				dbCmdWrapper.AddInParameter("@creditamount",DbType.Currency, 0);
109  				dbCmdWrapper.AddInParameter("@processor",DbType.String, whichProcessor);
110  				returnedbqISN = 0;
111  				returnedbqISN = (Int32)db.ExecuteScalar(dbCmdWrapper) ;	
112   
113  			}
114   
115   
116   
117  			//bill credit card or ACH
118  			switch (ccORach.Trim())
119  			{
120  				case "CC":
121  					retBilling = BillCreditCard(whichProcessor,ip,merchant_email,grand_total, strFirstName.Trim(), strLastName.Trim(),
122  						city,state, phone, address1,address2, zip, customer_email,
123  						product_desc, socialsecuritynum,creditcardnumber, cardverifynum, cardexpiredate,returnedbqISN,
124  						ref AuthCode, ref OrderNumber, ref DeclineCode, ref TermCode, ref ErrorMessage, ref ProcessorResponse,
125  						authenticationValue,authenticationTransactionID, eci, transactiontype, PAResStatus, SignatureVerification);
126  					break;
127  				case "ACH":
128  					retBilling = BillACH(whichProcessor, ip,merchant_email, grand_total, firstname, lastname,
129  						city,state, phone, address1,address2, zip, customer_email,
130  						product_desc, socialsecuritynum,bankname, routingnumber, accountnumber, checknumber, returnedbqISN,
131  						ref AuthCode, ref OrderNumber, ref DeclineCode, ref TermCode, ref ErrorMessage, ref ProcessorResponse);
132  					break;
133  				case "PAYPAL":
134  					retBilling = BillPayPal(ip,merchant_email,grand_total,firstname,lastname,
135  						city,state,phone,address1,address2,zip,customer_email,
136  						product_desc,socialsecuritynum,returnedbqISN, paypalSubAgreeID, notificationLocation,
137  						ref strErrorNo, ref strErrorDesc, ref strTransactionId, ref strStatus, 
138  						ref strStatusCode, ref strReasonCode);
139  					break;
140  			}
141   
142  			//insert into billingDetail
143  			char bqRecurring = 'N';
144  			sql = "spInsertBillingDetail2";
145  			dbCmdWrapper = db.GetStoredProcCommandWrapper(sql);
146   
147  			dbCmdWrapper.AddInParameter("@mISN",DbType.Int32,mISN);
148  			dbCmdWrapper.AddInParameter("@bqISN",DbType.Int32,returnedbqISN);
149  			dbCmdWrapper.AddInParameter("@bdamountcollected",DbType.Currency,grand_total);
150  			dbCmdWrapper.AddInParameter("@bdtransactioncode",DbType.String,AuthCode);	
151  			dbCmdWrapper.AddInParameter("@bdstatus",DbType.Boolean,retBilling);
152  			dbCmdWrapper.AddInParameter("@bdauthcode",DbType.String,AuthCode);
153  			dbCmdWrapper.AddInParameter("@bdordernumber",DbType.String,OrderNumber);
154  			dbCmdWrapper.AddInParameter("@bdtracecode",DbType.String,returnedbqISN);
155  			dbCmdWrapper.AddInParameter("@email",DbType.String,customer_email);
156  			dbCmdWrapper.AddInParameter("@bankname",DbType.String,bankname);
157  			dbCmdWrapper.AddInParameter("@routingnumber",DbType.String,routingnumber);
158  			dbCmdWrapper.AddInParameter("@accountnumber",DbType.String,enc_accountnumber);
159  			dbCmdWrapper.AddInParameter("@checknumber",DbType.String,checknumber);
160  			dbCmdWrapper.AddInParameter("@nameoncard",DbType.String,nameoncard);
161  			dbCmdWrapper.AddInParameter("@cardnumber",DbType.String,enc_cardnumber);
162  			dbCmdWrapper.AddInParameter("@cardverifynum",DbType.Int32,cardverifynum);
163  			dbCmdWrapper.AddInParameter("@cardexpirationdate",DbType.DateTime,cardexpiredate);
164  			dbCmdWrapper.AddInParameter("@billaddress1",DbType.String,address1);
165  			dbCmdWrapper.AddInParameter("@billaddress2",DbType.String,address2);
166  			dbCmdWrapper.AddInParameter("@billcity",DbType.String,city);
167  			dbCmdWrapper.AddInParameter("@billstate",DbType.String,state);
168  			dbCmdWrapper.AddInParameter("@billzip",DbType.String,zip);
169  			dbCmdWrapper.AddInParameter("@billphone",DbType.String, phone);
170  			dbCmdWrapper.AddInParameter("@ip",DbType.String, ip);
171  			dbCmdWrapper.AddInParameter("@bqrecurring",DbType.String, bqRecurring);
172  			dbCmdWrapper.AddInParameter("@Message",DbType.String, ErrorMessage);
173  			dbCmdWrapper.AddInParameter("@ProcessorResponse",DbType.String, ProcessorResponse);
174  			dbCmdWrapper.AddInParameter("@processor",DbType.String, whichProcessor);
175   
176  			dbCmdWrapper.AddInParameter("@strErrorNo",DbType.String, strErrorNo);
177  			dbCmdWrapper.AddInParameter("@strErrorDesc",DbType.String, strErrorDesc);
178  			dbCmdWrapper.AddInParameter("@strTransactionId",DbType.String, strTransactionId);
179  			dbCmdWrapper.AddInParameter("@strStatus",DbType.String, strStatus);
180  			dbCmdWrapper.AddInParameter("@strStatusCode",DbType.String, strStatusCode);
181  			dbCmdWrapper.AddInParameter("@strReasonCode",DbType.String, strReasonCode);
182   
183   
184  			Int32 returnedbdISN = 0;
185  			returnedbdISN = (Int32)db.ExecuteScalar(dbCmdWrapper) ;				
186  			if (retBilling)
187  			{
188  				if (UpdateBillingQStatuses(strDBInstance,returnedbqISN,'S'))
189  				{
190  					return true;
191  				}
192  			}
193  			else
194  			{
195  				if (UpdateBillingQStatuses(strDBInstance,returnedbqISN,'F'))
196  				{
197  					return false;
198  				}
199  			}
200  			return false;
201   
202  		}

 

 

 


.Net Web/Software Engineer
0
Dollarjunkie
3/1/2007 8:16:08 PM
asp.net.sql-datasource 29906 articles. 0 followers. Follow

2 Replies
874 Views

Similar Articles

[PageSpeed] 23
Get it on Google Play
Get it on Apple App Store

Dollarjunkie:
83   				//insert into billingQ or update if bqISN is passed
84 sql = "spInsertBillingQ";
85 dbCmdWrapper = db.GetStoredProcCommandWrapper(sql);
86 dbCmdWrapper.AddInParameter("@lISN",DbType.Int32,lISN);
87 dbCmdWrapper.AddInParameter("@mISN",DbType.Int32,mISN);
88 dbCmdWrapper.AddInParameter("@email",DbType.String,customer_email);
89 dbCmdWrapper.AddInParameter("@bankname",DbType.String,bankname);
90 dbCmdWrapper.AddInParameter("@routingnumber",DbType.String,routingnumber);
91 dbCmdWrapper.AddInParameter("@accountnumber",DbType.String,enc_accountnumber);
92 dbCmdWrapper.AddInParameter("@checknumber",DbType.String,checknumber);
93 dbCmdWrapper.AddInParameter("@nameoncard",DbType.String,nameoncard);
94 dbCmdWrapper.AddInParameter("@cardnumber",DbType.String,enc_cardnumber);
95 dbCmdWrapper.AddInParameter("@cardverifynum",DbType.Int32,cardverifynum);
96 dbCmdWrapper.AddInParameter("@cardexpirationdate",DbType.DateTime,cardexpiredate);
97 dbCmdWrapper.AddInParameter("@billaddress1",DbType.String,address1);
98 dbCmdWrapper.AddInParameter("@billaddress2",DbType.String,address2);
99 dbCmdWrapper.AddInParameter("@billcity",DbType.String,city);
100 dbCmdWrapper.AddInParameter("@billstate",DbType.String,state);
101 dbCmdWrapper.AddInParameter("@billzip",DbType.String,zip);
102 dbCmdWrapper.AddInParameter("@billphone",DbType.String, phone);
103 dbCmdWrapper.AddInParameter("@ip",DbType.String, ip);
104 dbCmdWrapper.AddInParameter("@fISN",DbType.Int32, fISN);
105 dbCmdWrapper.AddInParameter("@price",DbType.Currency, grand_total);
106 dbCmdWrapper.AddInParameter("@description",DbType.String, product_desc);
107 dbCmdWrapper.AddInParameter("@bqaction",DbType.String, bqAction);
108 dbCmdWrapper.AddInParameter("@creditamount",DbType.Currency, 0);
109 dbCmdWrapper.AddInParameter("@processor",DbType.String, whichProcessor);
110 returnedbqISN = 0;
111 returnedbqISN = (Int32)db.ExecuteScalar(dbCmdWrapper) ;

This would seem to be the pertinent part of your code.  Unfortunately you are using a custom object (dbCmdWrapper) and a custom method (AddInParameter) for building your SQL command, so it's probably going to be tough for us to help you without seeing that code.  What does dbCmdWrapper look like right before you execute line 111?


Terri Morton
Engagement Manager, Neudesic

How to ask a question

0
tmorton
3/1/2007 9:25:58 PM

Hi,

From the error message, we can see that the @bankname parameter is missing in the stored procedure execution.

In this case, you can check in your wrapper class to see if it has been added successfully.

HTH. If this does not answer you question, please feel free to mark it as Not Answered and post your reply. Thanks!


Sincerely,
Kevin Yu
Microsoft Online Community Support

Please remember to click “Mark as Answer” on the post that helps you, and to click “Mark as Not Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
0
Kevin
3/8/2007 4:04:38 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...

'TypeConverter' is unable to convert 'System.Data.SqlClient.SqlConnection' to 'System.Data.SqlClient.SqlConnection'.
Hey, I was hoping someone could shed some light on this error for me. I am using the TypeConverter in the System.ComponentsModel Namespace, and when I attempt to take an object, which in this case is a SQLConnection, and perform a TypeConvert (code example below) I get the following error: Error: ---------------------------------------------------------------------------- 'TypeConverter' is unable to convert 'System.Data.SqlClient.SqlConnection' to 'System.Data.SqlClient.SqlConnection'. ---------------------------------------------------------------------------- ...

'''''
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 '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 '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 'Create_User' expects parameter '@Password', which was not supplied.
Hi AllGetting Procedure 'Create_User' expects parameter '@Password', which was not supplied errorI 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.Redirec...

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 '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 '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...

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 '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=@...

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 '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(...

Web resources about - Exception Details: System.Data.SqlClient.SqlException: Procedure 'spInsertBillingQ' expects parameter '@bankname', which was not supplied. - asp.net.sql-datasource

Resources last updated: 11/24/2015 6:10:12 AM