Passing variables

• Lane

  Newbie

  Points: 1

  More actions

  May 20, 2004 at 11:02 am

  #162585

  Im trying to pass a string using C# to a stored procedure, yet it only registers one letter of my string, i can pass ints successfully with out issue, does anyone know why???

   

  string p22 ="hello" ;

  SqlCommand ocmd = new SqlCommand("EXEC transact '"+p22+"'", sqlConn);

  ocmd.CommandType = CommandType.Text;

   SqlDataReader oreader = ocmd.ExecuteReader();

    oreader.Close();

• Wayne Lawton

  Hall of Fame

  Points: 3532

  More actions

  May 20, 2004 at 12:44 pm

  #507174

  Can you post the text of the stored proc?  Or at least the signature?

• Terence

  Newbie

  Points: 2

  More actions

  May 21, 2004 at 7:14 am

  #507262

  Hi Lane,

  Please check the length of the datatype you have used in ur stored proc(sp). I assume u have used varchar as ur datatype. If u have not given any length than it will take the first character of the string that u have passed as a parameter to u r sp.

  by the way please post ur sp if u could.

  bye

• Calvin Lawson

  SSChampion

  Points: 11030

  More actions

  May 21, 2004 at 2:20 pm

  #507353

  Build the string first and then print to the console to verify that they command is correct (or you can use profiler).

   

  string p22 ="hello" ;

  string tSQL = "EXEC transact '"+p22+"'";

  --Print to console or whatever to check string

  SqlCommand ocmd = new SqlCommand(tSQL , sqlConn);

  ocmd.CommandType = CommandType.Text;

   SqlDataReader oreader = ocmd.ExecuteReader();

    oreader.Close();

  take the output and run directly in Query Analyser and verify that your getting the expected results.  If not, then I have no idea what's wrong.

   

  Signature is NULL