Error converting data type nvarchar to int. in Store Procedure RSS

• • Reply
  

  zeeshanfazal

  Member

  9 Points

  40 Posts

  Error converting data type nvarchar to int. in Store Procedure

  May 05, 2012 12:18 PM|LINK

  -------Store Procedure--------------

  ALTER PROCEDURE [dbo].[Insert_Contactinfo](@Contact_num VARCHAR(50),@Cell_num VARCHAR(15),@Contact_ID int OUTPUT )
  AS
  BEGIN
       SET NOCOUNT ON
  
       INSERT INTO dbo.ContactInfo
            (            
            [Contact_Num]
            ,[Mobile_Num]             
                            
            )
       VALUES
            (
              @Contact_num,
              @Cell_num                      
            ) ;
          set @Contact_ID = Scope_Identity();        
          return cast(@Contact_ID as int);
  END

  **********************************************

  C sharp Code

  cmd = new SqlCommand();
  
          cmd.CommandText = "[dbo].[Insert_Contactinfo]";
          cmd.CommandType = CommandType.StoredProcedure;
          cmd.Parameters.AddWithValue("@Contact_num", Contact_txt.Text);
          cmd.Parameters.AddWithValue("@Cell_num", Cell_txt.Text);
          cmd.Parameters.AddWithValue("@Contact_ID", SqlDbType.Int);
          cmd.Parameters["@Contact_ID"].Direction = ParameterDirection.Output;
          conn.Open();
          cmd.Connection = conn;      
          cmd.ExecuteNonQuery();
          conn.Close();
          cmd.Parameters.Clear();

  _____________________________________________________________________

  The data is inserted in the table but give me this error ...

  Error converting data type nvarchar to int. in sqlserver

  Please help me out i m waiting For angel to sorted me out

  Thanks in advance..

  • Edited by zeeshanfazal on May 05, 2012 12:24 PM
  • Moved by Mikesdotnetting on May 05, 2012 05:35 PM
• • Reply
  

  Ken Tucker

  All-Star

  16797 Points

  2608 Posts

  MVP

  Re: Error converting data type nvarchar to int. in Store Procedure

  May 05, 2012 01:21 PM|LINK

  Shouldn't this 

   cmd.Parameters.AddWithValue("@Contact_ID", SqlDbType.Int);

  be

   cmd.Parameters.Add("@Contact_ID", SqlDbType.Int);

  Developer at Sea World
  Space Coast .Net User Group
  • Marked as answer by Chen Yu - MSFT on May 18, 2012 09:14 AM
• • Reply
  

  Chen Yu - MS...

  All-Star

  21569 Points

  2493 Posts

  Microsoft

  Re: Error converting data type nvarchar to int. in Store Procedure

  May 09, 2012 09:37 AM|LINK

  Hi,

  Please follow @Ken Tucker's method to modify your code, it will work fine.

  Here is a Similar thread : http://forums.asp.net/t/1800373.aspx

  Thanks.

  Please mark the replies as answers if they help or unmark if not.
  Feedback to us
  
  Develop and promote your apps in Windows Store
  
  
  • Edited by Chen Yu - MSFT on May 09, 2012 09:39 AM
  • Marked as answer by Chen Yu - MSFT on May 18, 2012 09:14 AM