----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Girdhar77 Message 5 in Discussion Hi Vinayak, What is coming to the SQLQuerry? I mean How does it look. check it. rgds, rishi -----Original Message----- From: HiVinayK [mailto:[EMAIL PROTECTED] Sent: Saturday, March 20, 2004 12:23 PM To: BDOTNET Subject: Procedure or function has too many arguments specified ----------------------------------------------------------- New Message on BDOTNET ----------------------------------------------------------- From: HiVinayK Message 1 in Discussion Hi, I have started implementaion for stored procedure in our application. I have to reuse the existing method used in the DataAccess Layer.. Following the code snippet for the execute method in Data Access Layer. public int ExecuteSql(string SQLQuery) { int rowAffected = 0; try { string str = DBCon.State.ToString(); SqlCmd.CommandType = CommandType.StoredProcedure; SqlCmd.CommandText = "TestInsert"; SqlCmd.Parameters.Add("@sqlString", SQLQuery.Trim()); SqlCmd.ExecuteNonQuery(); SqlCmd. SqlCmd.Parameters.Clear(); SqlCmd.CommandType = CommandType.Text; SqlCmd.CommandText = ""; return rowAffected; } catch(Exception e) { throw e; } } Stored procedure takes the sql string.. This stores procedure just executes the sql string.. I am getting "Procedure or function has too many arguments specified". This Exception is not always generated... Stored Procedure Syntax : CREATE PROCEDURE TestInsert (@sqlString text) AS BEGIN EXEC (@sqlString) END GO Solution to this issue required urgently.. please help ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDOTNET/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED] ********************************************************************* Disclaimer: The information in this e-mail and any attachments is confidential / privileged. It is intended solely for the addressee or addressees. If you are not the addressee indicated in this message, you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. Please advise immediately if you or your employer does not consent to Internet email for messages of this kind. ********************************************************************* ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDOTNET/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
