Which SqlCommand Object property is used for passing Query or StoredProcedure name in the code?

CommandText is used for passing any query or SP name in the code.

For example:-

SqlCommand cmd = new SqlCommand();
cmd.CommandText = "your query"; //inline query

//or
cmd.CommandText = "your stored procedure name";